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.
Please attach a test document.
Created attachment 75235 [details] Test document 1
Created attachment 75236 [details] Test document 2
Created attachment 75237 [details] Test document 2
Two test documents attached. To reproduce: Open both documents and proceed from step 7.
(In reply to comment #0) > 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. Ctrl+F3 window looks empty here. Maybe another bug? (tested version see below) > 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". I can confirm this behavior. When I type =namedrange2 it'll have value 42 instead of value 3.14 Tested using Windows 8 with LibreOffice Version: 4.2.0.0.alpha0+ Build ID: 087a610fcd5c0c354a9ed6bfccd3451b667d62a3 TinderBox: Win-x86@6-debug, Branch:master, Time: 2013-08-04_21:41:24 Kind regards, Joren
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.