https://bugs.freedesktop.org/show_bug.cgi?id=78154
Priority: medium
Bug ID: 78154
Assignee: [email protected]
Summary: VIEWING: Computed field does not display the correct
value
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.5.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 98294
--> https://bugs.freedesktop.org/attachment.cgi?id=98294&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs