https://bugs.freedesktop.org/show_bug.cgi?id=61119
Priority: medium
Bug ID: 61119
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: Copying sheet btw documents messes up named
ranges
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: csti...@gwdg.de
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.5.2 release
Component: Spreadsheet
Product: LibreOffice
1. Create new spreadsheet document "spreadsheet1.ods"
2. Create a new named range "namedrange1" pointing to a single cell with value
42.
3. In a different cell, enter "=namedrange1" to confirm that the named range is
correctly defined. Result: 42
4. Create another spreadsheet document "spreadsheet2.ods"
5. Create a new named range "anothernamedrange" pointing to a single cell with
value 3.14
6. In a different cell, enter "=anothernamedrange" to confirm that the named
range is correctly defined in the second document. Result: 3.14
7. In "spreadsheet2.ods", right-click Sheet1 and select "Move-Copy Sheet".
Location/To Document: select "spreadsheet1". New Name:
"sheet1_fromspreadsheet2".
8. Go to "spreadsheet1.ods". Press Ctrl-F3 to check that both named ranges are
now defined here.
9. In an empty cell, enter "=namedrange1".
EXPECTED RESULT: 42, the value pointed to by "namedrange1"
RESULT: 3.14, the value pointed to by "anothernamedrange". In the cell edited
in step 9, the formula is changed to "=anothernamedrange".
No attachment, as not reproducible after saving and reopening.
--
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
