Created attachment 98294 [details] Document to which refers the description how to reproduce the problem. Problem description: Steps to reproduce: 1. Open the attached file, go to the cell K50 on the default sheet "RhoMobile" 2. look at the field, it displays value 0. Current behavior: To the field K50 and look at the formula there. If you press the function button, then the analysis of the functions in the formula comes, there is displayed the result value 5, what is the correct number. If you change the formula somehow, the value of K50 is then recomputed correctly, or if you change the value in the cell J50, similar thing happens - the 0 in K50 is recalculated to the correct value, if you change the original J50 from 50% to other value and then back to 50%, the value of K50 changes from original 0 to the correct value 5. The problem occured after I have taken the sheet "_ToolFrame" and copied it to the new name "RhoMobile" and then moved the new sheet to the new location. Then, no from the cells in the column J, where have been put the number, has caused the recalculation of the corresponding K cell. I saved the document in this state, after the open all cells in teh column K are recalculated correctly after the change of the corresponding cell in the column J - unfortunatelly the original behavior with the non-functioning formulas in the column K I was not able to reproduce Expected behavior: Correct computation of the calculated fields at any time. Correctly recalculated Operating System: Debian Version: 4.1.5.3 release
Not reproducible for me with LibreOffice 4.2.5.0.0+ under Linux / Ubuntu 14.04 x86-64. Your testfile crashes my LibreOffice 4.1.6 (generic Linux version) Best regards. JBF
There is needed a hard recalc [Ctrl+Shift+F9] to get the cell calculated. With Win7x64Ultimate, crash opening with: Version 4.0.6.2 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24) Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a Versión: 4.2.3.3 Id. de compilación: 882f8a0a489bc99a9e60c7905a60226254cb6ff0 Crash after open, close without save, opening again With: Version: 4.2.4.1 Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515 Version: 4.2.5.0.0+ Build ID: 59906c3d54e6541185f4bf85b1d1c70530198059 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-04-30_09:30:13 Version: 4.3.0.0.alpha1+ Build ID: 0b03f7ed575838f90e6b1ebec3538a3a214f81fb TinderBox: Win-x86@39, Branch:master, Time: 2014-04-30_01:30:46 Last working: Version 3.6.7.2 (Build ID: e183d5b) Added to MAB 4.1 https://bugs.freedesktop.org/show_bug.cgi?id=60270
Using 4.2.3, after doing hard recalc, saving it and reopening it will no longer reproduce this bug. I think this was a bug in the ods export where formula results were not stored in the file correctly. Unfortunately once the file has incorrect formula results, there is nothing we can do about that during import. So the only way to correct the situation is to load the file in 4.2.x, do hard recalc, and save the file in order to store correct formula results in the file.
I'll mark this resolved for 4.2. 4.1 is almost EOL.