Bug 137606 - Formulas is not recalculated if they are in cells in row >= 2
Summary: Formulas is not recalculated if they are in cells in row >= 2
Status: RESOLVED DUPLICATE of bug 137248
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-19 21:31 UTC by Jesper Korsholm Brogaard
Modified: 2020-10-20 04:53 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jesper Korsholm Brogaard 2020-10-19 21:31:32 UTC 
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).
Comment 1 Ming Hua 2020-10-20 04:53:02 UTC 
Thanks for reporting.  This issue has been reported as bug 137248, and has since been fixed in master as well as in 7-0 branch.  The upcoming 7.0.3 release will include the fix.

So I'm marking this bug as a DUPLICATE.

*** This bug has been marked as a duplicate of bug 137248 ***