Do you want to: Report a bug
Document Server version: Kdrive / Infomaniak Partner
Browser version: Mac Os Sonoma Chrome 120 or Onlyoffice Desktop App.
In some rows a formula outputs a #REF! error.
You can check the following doc [INFRA] Suivi facturation Webmarketing récurrent (1).xlsx - Grids
Cell K77 → #REF! error.
Cell M77 → Good Result with the same formula as K77
The same file in Excel has no problem in K77 - Same result as M77.
Thank you for the provided file. We have reproduced the issue and are currently analyzing it. I will let you know the results.
Thank you for replying
I made further tests and find out a solution :
The cells in column K and the lines from 66 to 77 contain a formula that sums up all the values in column K.
This causes problems, as another cell (like K77) tries to calculate a value that contains the above-mentioned formula.
In order to get the desired result I need to specify ranges (e.g., K1:K60) instead of the entire K column in cells 66 to 77.
What misled me is that this function returns the correct result in Excel, but not in Onlyoffice.
I don’t know if you could evolve the function in Onlyoffice so that it works like in Excel?
We have reproduced the issue and registered a bug. When the fix is released, we will let you know.