https://bugs.freedesktop.org/show_bug.cgi?id=81659
Priority: high
Bug ID: 81659
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: "Expand references when new columns/rows are inserted"
spoils SUM formula when row is inserted
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: tom...@freenet.de
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 103318
--> https://bugs.freedesktop.org/attachment.cgi?id=103318&action=edit
LO Calc 4.2.5.2 example
If an empty row is inserted in a consecutive row of formulas that use the
built-in function "SUM" with a range argument while the option "Expand
references when new columns/rows are inserted" is enabled, 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 while option "Expand ..." is ENabled
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.
3) 3rd sheet = result after adding row 6 while option "Expand ..." is DISabled
The formulas in D7, D8, D9, D10 and D11 are correct.
LibreOffice Calc 4.2.4.2 has the same problem but
LibreOffice Calc 4.1.6.2 does not have this problem.
Regards
Tom
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
