Created attachment 122063 [details]
Summary of Expenditures
When you open file, you can see what is about. Check the cell with the formula. If the entry is empty cell, the formula is evaluated incorrectly. This error began to show in the old workbook after upgrade LibreOffice.
I am sorry for my English.
Select all (ctrl+A) and do an hard recalculation (ctrl+shift+F9).
Closing as WorksForMe. Feel free to reopen if you disagree.
Best regards. JBF
Ctrl+A isn't needed for hard recalc, Shift+Ctrl+F9 is sufficient. Recalc cures the symptom, but it would be interesting to know how this document state sprang into existence..
The document apparently was saved without being recalculated, however that may have happened, it might be that AutoCalculate was off when modifying the document and then switched on before saving but without actually having recalculated. Was that the case? Did you delete/empty cells in the colored columns while AutoCalculate was off?
Current versions don't recalculate documents when loading.
If you have more than this document in such state you may want to enable Tools->Options->Calc->Formula "Recalculation on File Load" for ODF spreadsheet.
I know hard recalc, but it isn't solve of problem. Columns with formulas in this workbook are usually hidden and user have spotted only bad values in summary (after upgrade Libreoffice). Autocalculate was always on. After use hard recalc, this error happened again after some time. May be resolving is set "Recalculation on File Load", but how is it possible that it happens? Origin of this workbook is about 2 years old and till the version 18.104.22.168 worked properly.
I have found that hard recalc, even settings "Recalculation on File Load" doesn't work only in user's notebook. When I completly fixed workbook (in my PC) and user after that open it in his notebook - bad cells still there were, but not all. Interesting. If the file without errors is opened at this notebook, bug appears again and again immediately after open.
ASUS, Windows 7 Home Premium 64bit, SP1; AMD A4-3300M, RAM 6GB.
(In reply to Martin from comment #4)
> doesn't work only in user's notebook. When I completly fixed workbook (in my
> PC) and user after that open it in his notebook - bad cells still there
> were, but not all. Interesting. If the file without errors is opened at this
> notebook, bug appears again and again immediately after open.
> ASUS, Windows 7 Home Premium 64bit, SP1; AMD A4-3300M, RAM 6GB.
And what program and which version does that user use to open the file?
User using version as i wrote 22.214.171.124
I have installed today the same version on my PC, and everything works properly. That's why i don't understand why it do this error in the same release on the other computer.
> I have installed today the same version on my PC, and everything works properly.
> That's why i don't understand why it do this error in the same release
> on the other computer.
Maybe an OpenCL bug (for example: https://bugs.documentfoundation.org/show_bug.cgi?id=97150)
Does it work if you to disable OpenCL?
(In reply to Oliver Brinzing from comment #7)
> Maybe an OpenCL bug (for example:
> Does it work if you to disable OpenCL?
Yes, it does. Disabling OpenCL solves the issue.
Origin worksheet contain many rows (more the 1000) with formulas and enabling OpenCL causes incorrectly evaluated formulas in some types of computer.
Thank you for help.
One more time i must to sorry for my english.
This is yet another "calculating wrong with OpenCL" report.
Any estimate if, how and in what time frame it can be fixed on your side?
As an interim measure I suggest to default the OpenCL option to disabled
in all releases.
So in which version is the bug present? The bug reporter tells that in 4.4.7 LibreOffice works correctly, unless I am mistaken. So the Version field is likely wrong?
Ah, re-reading, so he does see an error in 4.4.7 on some machine(s). Ignore my previous comment.
Anyway, this sounds a lot like a problem that was fixed in 5.0. Duplicate of bug #94924?
The incorrect data disappears when one does a hard recalc (Ctrl+Shift+F9) in a LibreOffice version that contains a fix for this bug (i.e., earlier duplicate bug reports). For instance 126.96.36.199.
*** This bug has been marked as a duplicate of bug 94924 ***