https://bugs.documentfoundation.org/show_bug.cgi?id=88979
Bug ID: 88979
Summary: EDITING. The sheet portion of label ref are always
absolute. Relative sheet ref not supported.
Product: LibreOffice
Version: 4.2.8.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dwyo...@mail.com
Created attachment 112992
--> https://bugs.documentfoundation.org/attachment.cgi?id=112992&action=edit
Simple demonstration of bug per Description
When a label is created, the reference is of form $sheet.$col$row. The sheet
portion of the reference is an absolute reference. The form sheet.$col$row is
not supported (i.e. with the sheet portion of the reference being a relative
reference). Therefore if the sheet is copied (i.e. Edit > Sheet > Move/Copy),
the labels on the new sheet always reference cells on the original sheet rather
than on the new sheet itself.
This can be demonstrated as follows. In the attached file,
LabelRelSheetAddress.ods, do "Insert > Names > Labels >". In the dialog field
for specifying the cell of the label, the reference is $Sheet1.$A$1 (wherein
the sheet reference is an absolute reference). It doesn't allow changing it to
Sheet1.$A$1 (wherein the sheet reference would be a relative reference).
This is a problem when copying the sheet as follows.
1. "Edit > Sheet > Move/Copy (Copy is preselected) > -move to end position- >
OK"
2. On new sheet "Sheet1_2", the reference in the formula of cell B2 to 'label1'
is to cell Sheet1.$A$2, so the sheet reference in 'label1' was indeed treated
as an absolute reference.
There's an additional problem that can be demonstrated with the attached file
LabelRelSheetAddress.ods (before the demonstration steps above are done) as
follows.
1. "Edit > Sheet > Move/Copy (Copy is preselected) > Insert before Sheet1 > OK"
2. On the new sheet "Sheet1_2", the cell B2 is evaluated to "#NAME?". The
reference to 'label1' seems to be the problem even though "Insert > Names >
Labels" shows that 'label1' is defined as column label $Sheet1.$A$1.
3. "Edit > Sheet > Move/Copy (Move) > -move to end position- > OK". Now on
"Sheet1_2", cell B2 is evaluated to 303. Moving the sheet shouldn't change the
evaluation of references to labels.
See related Bug 88963.
--
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
