Bug 78154 - VIEWING: Computed field does not display the correct value
Summary: VIEWING: Computed field does not display the correct value
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
Whiteboard: BSA target:4.2.3
Keywords: regression
Depends on:
Reported: 2014-05-01 13:20 UTC by Artur Linhart
Modified: 2014-05-18 13:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Document to which refers the description how to reproduce the problem. (532.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-05-01 13:20 UTC, Artur Linhart

Note You need to log in before you can comment on or make changes to this bug.
Description Artur Linhart 2014-05-01 13:20:43 UTC
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: release
Comment 1 Jean-Baptiste Faure 2014-05-01 17:18:51 UTC
Not reproducible for me with LibreOffice under Linux / Ubuntu 14.04 x86-64.
Your testfile crashes my LibreOffice 4.1.6 (generic Linux version)

Best regards. JBF
Comment 2 m_a_riosv 2014-05-01 19:19:26 UTC
There is needed a hard recalc [Ctrl+Shift+F9] to get the cell calculated.

With Win7x64Ultimate, crash opening with:
Version (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24)
Version: Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
Versión: Id. de compilación: 882f8a0a489bc99a9e60c7905a60226254cb6ff0

Crash after open, close without save, opening again With:
Version: Build ID: d4c441391e20647b3d2e8dde4d20aa868e77e515
Version: Build ID: 59906c3d54e6541185f4bf85b1d1c70530198059
   TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-04-30_09:30:13
Version: Build ID: 0b03f7ed575838f90e6b1ebec3538a3a214f81fb
   TinderBox: Win-x86@39, Branch:master, Time: 2014-04-30_01:30:46

Last working:
Version (Build ID: e183d5b)

Added to MAB 4.1 https://bugs.freedesktop.org/show_bug.cgi?id=60270
Comment 3 Kohei Yoshida 2014-05-18 13:55:44 UTC
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.
Comment 4 Kohei Yoshida 2014-05-18 13:56:35 UTC
I'll mark this resolved for 4.2.  4.1 is almost EOL.