https://bugs.documentfoundation.org/show_bug.cgi?id=101583
Bug ID: 101583
Summary: Range Name References Updated Incorrectly
Product: LibreOffice
Version: 5.2.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126881
--> https://bugs.documentfoundation.org/attachment.cgi?id=126881&action=edit
Range Name Example
Windows 10, LibreOffice 5.2.0.4
When inserting rows and/or columns range name references are not updated
correctly.
In the attached file there is a simple table with the column headings
'Description' and 'Weight' along with a short list. The Table is named
'Fruits_LUT' and the columns 'Fruits' and 'Weight'. Above the table is a simple
formula to return the maximum weight.
Inserting a column to the left of column A moves the data to the right but the
'Fruits_LUT' range name now covers columns A to C. 'Fruits' now also includes
column A. 'Weights' updates correctly.
Inserting two rows above the table results in each of the range name references
being extended to include the inserted rows.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
