https://bugs.documentfoundation.org/show_bug.cgi?id=89484
Bug ID: 89484
Summary: "Expand references when new columns/rows are inserted"
spoils SUM formula when row is inserted in another
sheet
Product: LibreOffice
Version: 4.4.0.3 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ren...@gmx.net
I am not sure if it is the same than Bug 81659. Sorry, if duplicate.
1. Turn on: "Expand references when new columns/rows are inserted"
2. Add 1 to A1 on Sheet1
3. Add formula =SUM(A1:A1) into B1
4. Add second sheet
5. Go to line number 2 in second sheet
6. Insert Rows
7. Look at formula in B1 in sheet 1. It has changed to =SUM(A1:A2)
I expect formulas in sheet 1 to stay unchanged when inserting rows into sheet 2
because sheet 2 is not in the scope of the formulas reference
--
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
