https://bugs.freedesktop.org/show_bug.cgi?id=61119
Jorendc <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Priority|medium |high Ever confirmed|0 |1 --- Comment #6 from Jorendc <[email protected]> --- (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 -- 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
