https://bugs.freedesktop.org/show_bug.cgi?id=73822
Priority: medium
Bug ID: 73822
Assignee: [email protected]
Summary: EDITING: Reference to local Names become invalid after
adding new sheet before the current one
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 92427
--> https://bugs.freedesktop.org/attachment.cgi?id=92427&action=edit
Spreadsheet with two sheet and Name 'test' defined and used from Sheet1
Problem description:
Steps to reproduce:
1. Input a column of data (say, 1,2,3,4 it A1:A4) in Sheet 1, and select it
2. Insert/Names/Define
2.1. Name: test
2.2. Range: the data column (should already be initialised)
2.3. Scope: Sheet1
3. Select B1:B4, and enter '=test' then Ctrl+Shift+Enter to create an array
filled from the data contained in named reference 'test' just defined
4. Insert a new sheet after Sheet1
5. Select Sheet2.B1:B4, and enter '=Sheet1.B1:B4' then Ctrl+Shift+Enter
=> it works: it contains data initially entered in Sheet1.A1:A4 and repeated in
Sheet1.B1:B4 through the Sheet reference
6. Go to Sheet1
7. Insert/Names/Manage
=> the Range for Name test appears as Sheet1.A1:A4, as defined
6. Insert a new sheet before Sheet1
7. Hit F9 to recalculate or, sometimes, save the document, close it and reopen
it
8. Go to Sheet1 (now the second one)
9. Insert/Names/Manage
Current behavior:
=> test now appears as Sheet2.A1:A4, rather than the previous Sheet1.A1:A4
(still in Scope Sheet1, though)
=> no data is present anymore in Sheet1.B1:B4 and Sheet1.A1:A4 as they now
refer to a set of empty cells in Sheet2, rather than Sheet1 as defined
Deleting/readding Sheet3 toggles Name 'test' to refer to the range in Sheet1 or
Sheet2 (try in after.ods, attached)
Expected behavior:
The range for name test should not change, and the recalculated data should be
identical to before recalculating.
Operating System: Linux (Other)
Version: 4.1.4.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
