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
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: *Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.1 or later) https://www.libreoffice.org/download/ *If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior *If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT *Update the version field *Reply via email (please reply directly on the bug tracker) *Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-04-18
Reproduced with test documents. Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ Build ID: 01a189abcd9a4ca472a74b3b2c000c9338fc2c91 TinderBox: Win-x86@39, Branch:master, Time: 2015-06-14_07:46:28 Locale: fi-FI (fi_FI)
Fixed with commit 336d816176650726f6d14539464d9fd28ddd032d in master and https://gerrit.libreoffice.org/23323 for 5-1 (5.1.3) and https://gerrit.libreoffice.org/23324 for 5-0 (5.0.6) Pending review https://gerrit.libreoffice.org/23439 for 5-1-2