[Libreoffice-bugs] [Bug 137659] New: Calc does not recalculate sheet properly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137659

            Bug ID: 137659
           Summary: Calc does not recalculate sheet properly
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dimstar at opensuse.org

I observed this in one of my more complex (but by far not really complex)
spreadhseets, that cells seem not to be recalculated, neither automatically nor
when pressing F9

I created a dummy test file, with simple layout like


   A     |     B      |    C
------------------------------
   1     |     0      |  =SUM:A:A)
   2     |     1      |  =SUM(B:B)
   3     |     2      |  =C1-C2
   4     |     3      |
   5     |     4      |
   6     |     5      |
   7     |     6      |
   8     |     7      |
   8     |     8      |


So, all cells in column C are formulas. When updating any cell in column A, C1
is recalculated, C2 unaffected, but C3 is only recalculated if A3 (or B3) is
changed

Similar for changes in column B: C2 is properly calculated, C3 only when one
happens to change the value in B3

Other changes in column A and B do not propagate to C3

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201021/ba836665/attachment.htm>