[Libreoffice-bugs] [Bug 137606] New: Formulas is not recalculated if they are in cells in row >= 2

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Oct 19 21:31:32 UTC 2020


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

            Bug ID: 137606
           Summary: Formulas is not recalculated if they are in cells in
                    row >= 2
           Product: LibreOffice
           Version: 7.0.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jesper at brogaard.eu

Description:
If the same formula is placed in e.g. cell A1 and A2, the formula in A2 is not
recalculated

An example: 
Formula =SUM(A5:C12) Is placed in A1 as well as in A2
Insert some numbers in some of the cells in A5:C12

Formula in A1 is updated every time a new number is inserted while the second
formula is never calculated.


Steps to Reproduce:
1. =SUM(A5:C12) is placed in A1
2. =SUM(A5:C12) Is placed in A2
3. Insert numbers in someof the cells in A5:C12

Actual Results:
Formula in A1 is updated after entering a number
Formula in A1 is NOT updated after entering a number

Expected Results:
Both formulas shows the same result


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Seems to has been introduced in 7.0.2.2 since the error doesn't appear in
7.0.1.2 and 6.4.6.2 which are the versions I have tested (installed via
Separate Install GUI v. 5.0.0.9).

-- 
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/20201019/7a854e98/attachment.htm>


More information about the Libreoffice-bugs mailing list