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

Reply via email to