Bug 112640 - Auto-Calculate does not work properly after column insert
Summary: Auto-Calculate does not work properly after column insert
Status: RESOLVED DUPLICATE of bug 111428
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-09-25 10:47 UTC by fred4u
Modified: 2017-10-07 13:44 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 fred4u 2017-09-25 10:47:15 UTC 
Steps to reproduce
Enter the following:
A1: 1
B1: 1
C1: SUM(A1:B1)
C1 displays 2 (OK)

Now:
Right-click on C1 header; select "Insert columns on the left".
Blank column C1 appears, the sum moves to D1.
Click on D1, press F2 to edit formula and change B1 to C1 (now formula is SUM(A1:C1)
Go to C1 and enter "1" for the cell.

Sum in D1 remains unchanged (2 instead of 3), only until force re-calculate D1 using F9 key.

Win7/64. OpenGL enabled.
Comment 1 m_a_riosv 2017-09-25 21:34:32 UTC 

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