Description: In the attached file cells F2 and G2 contain the same formula but produce different results. AutoCalculate is ON, and I have manually Recalculated many times, with no effect. This may be related to recalculation as some (but not all) changes made to the sheet cause the cell results to become the same. Now I do not know whether the calculation results in any cell in any spreadsheet are valid. Steps to Reproduce: 1. Open attached spreadsheet. 2. Look at formulae in cells F2 and G2. 3. Observe that the values in these cells are different, despite being the same calculation. Actual Results: Cell F2 displays value 0.00185, cell G2 displays value 0.00146. Expected Results: Values in cells F2 and G2 should be the same. Reproducible: Sometimes User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 5.3.7.2 Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059 CPU Threads: 4; OS Version: Mac OS X 10.13.2; UI Render: GL; Layout Engine: new; Locale: en-US (en_US.UTF-8); Calc: group User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_2) AppleWebKit/604.4.7 (KHTML, like Gecko) Version/11.0.2 Safari/604.4.7
Created attachment 139030 [details] Calc file showing incorrect calculations
Doing a hard recalc [ctrl+shift+F9], solves the issue. Maybe it was saved in a wrong state. I don't there is a bug. Can you reproduce with a new file from scratch.
Created attachment 139045 [details] original file demonstrating bug
Hard recalc odes not work on my machine (MacOS 10.13.2). control + shift + F9 has no effect, nor does control + shift + fn + F9, and I cannot find any menu item for "hard recalc". I do not know how to reproduce this in a few file; copying and pasting from this file to another does not demonstrate the bug. However I have attached another file, which is the original file where this bug was first observed. The smaller file I attached with the bug report was that file with lots of cells deleted. Assuming I can get hard recalc to work (how?) then how does one know when that must be done? In other words, how can I tell that some calculations in a sheet are wrong and must be reset?
If I'm not wrong control key in Mac is Command ⌘ It should be ⌘ + shift + fn + F9 Maybe you can see the key combinations in Menu/Tools/Customize/Keyboard
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20180731
changing the formula in H3 =F3; and H26; to =IF(F2="";F3;H3) seems to solve the problem, saving the document and then reopen no need to hard recalculation. Version: 5.3.7.2 Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059 CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 6.2.0.0.alpha0+ Build ID: 83d8331581ab43cf35325ca674cf62d4ba5dc5ad CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group threaded I think it can be closed as WFM
Doing a simple F9 recalc (when cells selected) solves the issue: https://help.libreoffice.org/6.2/en-US/text/scalc/01/06080000.html Asking for fileopen recalc also solves the issue: https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01060900.html I always set "Prompt User". And here it promtps, you say Yes and solved. Default is "Never recalculate". Bug 107929 to set "Prompt user" as default for "Recalculation on file load" is WontFix. I close this one as WFM.