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