Bug 78633 - Row insertion spoils SUM formula
Summary: Row insertion spoils SUM formula
Status: RESOLVED DUPLICATE of bug 77647
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-12 20:24 UTC by Tom
Modified: 2015-02-19 11:13 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Two steps calc example (18.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-05-12 20:24 UTC, Tom 		Details
Re-assessment under 4.2.5.2 (18.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-07-21 18:26 UTC, Tom 		Details
Show Obsolete (1) View All 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 Tom 2014-05-12 20:24:22 UTC 
Created attachment 98941 [details]
Two steps calc example

If an empty row is inserted in a consecutive row of formulas that use the built-in function "SUM" with a range argument, the formula in the rows below the inserted row are spoiled.

Example attached:
1) 1st sheet = initial spreadsheet
2) 2nd sheet = result after adding row 6
   The formulas in D7, D8, D9, D10 and D11 are wrong.
   E.g. "D7" should read "=SUM(A7:C7).
   The first argument of SUM() was obviously not incremented.

LibreOffice Calc 4.1.6.2 does not have this problem.

Regards
Tom
Comment 1 VLB 2014-05-12 20:54:14 UTC 
Tuis is solved in 4.2.5.
Comment 2 VLB 2014-05-12 20:56:50 UTC 

*** This bug has been marked as a duplicate of bug 77647 ***
Comment 3 Tom 2014-07-21 18:26:11 UTC 
Created attachment 103208 [details]
Re-assessment under 4.2.5.2

Sorry,

I just verified this issue under LibreCalc 4.2.5.2. Unfortunately, it is not solved. Please see the more detailed example with explanatory comments attached.

Regards
Tom
Comment 4 Tom 2014-07-21 18:27:54 UTC 
Sorry, this issue is not fixed. I just found the same issue under 4.2.5.2. Please see the new attachment.


Regards
Tom
Comment 5 ign_christian 2014-07-22 03:14:56 UTC 
Hi Tom.. I can't reproduce this using LO 4.2.5.2 and 4.2.6.1 under Ubuntu 12.04 x86.

Please reset user profile and if it works then remark this bug again as dup, otherwise UNCONFIRMED
Comment 6 Tom 2014-07-22 17:14:56 UTC 
Hi Christian,

after removing my LO user profile and starting LO4.2.5.2 from scratch, it turned out that the behavior of LO4.2.5.2 under is correct. Thanks for the hint on the user profile.

Regards
Tom

*** This bug has been marked as a duplicate of bug 77647 ***
Comment 7 Tom 2014-07-22 20:21:14 UTC 
Supplement: The behavior I observed can be reproduced by enabling the option "Expand references when new columns/rows are inserted" in the "General" tab of LO-Calc 4.2.5.2. Without this option enabled the formulas are correct after a new row is inserted.

Regards
Tom
Comment 8 ign_christian 2014-07-23 03:37:37 UTC 
(In reply to comment #7)
> "Expand references when new columns/rows are inserted"

Hi again.. Did you ever find a bug previously reported with that option enabled?

If no, how about open new bug report as suggested by Kohei:
https://bugs.freedesktop.org/show_bug.cgi?id=77647#c42