Description: Open the attached file. A = 379.788 B = 268.577 The value for B6 should be (A-B)*100/B = 41.41 But it is zero. Press Ctrl+Shift+F9 (Hard Recalculate): B6 is now 41.41, as it should. If you would get this file you wouldn't know that you have to press something to see real results. Steps to Reproduce: see description Actual Results: The value from B6 is zero Expected Results: The value from B6 should be 41.41 Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.5.0.1 (X86_64) / LibreOffice Community Build ID: 77cd3d7ad4445740a0c6cf977992dafd8ebad8df CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded
Created attachment 184531 [details] demo document
After a first hard recalc, introducing new numbers the recalculation it's done automatically. Somehow, the file was saved without the recalculation done. D4 has zero as value in the file.
Thanks for looking at this report. The file is generated by an accounting software through an XML file, and the attachment it's a minimal reproduction file. It is supposed NOT to be edited by anyone, being automatically generated. The B6 value is a percentage that means the reduction of taxes. Big taxes with 10% means something. So, zero could mean in this case that we NOT apply the law. I know that modifying any number and UNDO resolve the case, but I am not the only user who use it (others don't know the trick). Could be hundreds of people who could be affected by this wrong percent. More important, I tested this file, and Microsoft Office is opening the file with the correct value. Just LibreOffice don't.
Confirm no auto-calculation with LO but it does with Microsoft Office Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 102846d45cb9660805e209b6954c7b8d707b8288 CPU threads: 8; OS: Mac OS X 12.3.1; UI render: Skia/Raster; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded
@Eike Some dev advise would be nice
The essential part here is that I am NOT allowed to modify the file. It's generated by software and used just to take the percentage and print it.
There is an option: Menu/Tools/Options/LibreOffice calc/Formula/Recalculation on File Load - ODF spreadsheet (not saved by LibreOffice) - Always recalculate That works for me.
(In reply to m.a.riosv from comment #7) > There is an option: > Menu/Tools/Options/LibreOffice calc/Formula/Recalculation on File Load - ODF > spreadsheet (not saved by LibreOffice) - Always recalculate > That works for me. Yes, thanks. It worked.