https://bugs.documentfoundation.org/show_bug.cgi?id=94959
Bug ID: 94959
Summary: SUM formula update incorrect when the sum range is to
the last column in spreadsheet and a new column is
inserted
Product: LibreOffice
Version: 5.0.0.5 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: sviatos...@outlook.com
Created attachment 119518
--> https://bugs.documentfoundation.org/attachment.cgi?id=119518&action=edit
Sample spreadsheet
When the SUM formula sums columns to the end of the spreadsheet (column AMJ),
and when a column is inserted somewhere in the summed range, the formula is not
updated correctly with reference to AMJ becoming #REF!.
To reproduce:
1. Open attached sample spreadsheet
2. Insert 1 column anywhere after column D
3. Observe formula in cell D3
--
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
