Do you want to: Report a bug
OS version: Fedora 39
App version: 8.3.3.21 (rpm)
Downloaded from: github offpage
i have xlsx file created in MS Excel with enable “Set Precision as Displayed”. If open it in OnlyOffice, the function “iterative calculation” is not active and, accordingly, the results of the functions are different. If you try to turn on “iterative calculation”, the situation does not change. I started to figure it out. I opened this file in LibreOffice Calc and turned on the “iterative references” option. The function values became the same as in Excel, I saved the document and opened it again in OnlyOffice and the “Set Precision as Displayed” function started working and enabled. I don’t know if I explained it clearly. I can send you this file.
Thx.
Hello @i.ddqd,
Yes, please provide the original file for analysis, you can remove/replace sensitive data if any
We are currently checking, please wait
Sorry for the delayed response, here is our conclusion:
The issue occurs due to the fact that you have the “Precision as displayed” setting enabled in Excel, and during calculations, Excel only considers the visible values in the cells.
Our editor, on the other hand, calculates without taking the screen rounding into account and provides more accurate values.
If the “Precision as displayed” setting is turned off in Excel, the calculations in our editor and Excel become the same.
That’s right. But a similar setting in LibreOffice Calc solves this problem. This looks like a broken function in OnlyOffice, I’m talking about “iterative calculation”
Please check - there is actually no iterative calculation in the document provided above.
Concerning the particular issue that you faced we have added your request to a functionality suggestion in our tracking system - to add “Set precision as displayed” settings option
Most likely I’m confusing something about iterative calculations. but “Set precision as displayed” is a very important function for compatibility with MS Excel, thanks
We understand and will be working on it, I’ll notify as soon as the version with the feature is introduced