https://bugs.documentfoundation.org/show_bug.cgi?id=99937
Bug ID: 99937
Summary: Absolute references change when deleting/inserting
rows/columns
Product: LibreOffice
Version: 5.1.3.2 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 125158
--> https://bugs.documentfoundation.org/attachment.cgi?id=125158&action=edit
spreadsheet with data illustrating the problem
First, I'm not sure if this is a bug or a expected behaviour and I'm sorry if I
wasted your time...
If I have absolute reference in a formula, and then delete rows or columns that
are part of cell range defined by absolute references, the formula changes, the
range defined by absolute references gets smaller. Similar for inserting
rows/columns. In the example spreadsheet, there is a column and a row of data,
and two formulas in B1 and C1, summing the data using absolute references.
If I delete one or more rows containing data (right-click on selected rows,
Delete rows), the formula in B1 changes, for example if I delete rows 10-12,
the formula changes from =SUM($A$4:$A$20) to =SUM($A$4:$A$17).
I was expecting for this to happen to non-absolute references, but not with
absolute ones. And I could be wrong for expecting this.
If this isn't a bug, but expected behaviour, is there a way to make references
constant, so they don't change when deleting/inserting columns/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
