https://bugs.freedesktop.org/show_bug.cgi?id=78633
Priority: medium
Bug ID: 78633
Assignee: [email protected]
Summary: Row insertion spoils SUM formula
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 98941
--> https://bugs.freedesktop.org/attachment.cgi?id=98941&action=edit
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
