Bug 61119

Summary:	EDITING: Copying sheet btw documents messes up named ranges
Product:	LibreOffice	Reporter:	cstingl
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	high	CC:	markus.mohrhard
Version:	3.6.5.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:
Attachments:	Test document 1 Test document 2 Test document 2

Description cstingl 2013-02-19 14:18:41 UTC

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.

Comment 1 Markus Mohrhard 2013-02-20 22:07:05 UTC

Please attach a test document.

Comment 2 cstingl 2013-02-21 08:21:03 UTC

Created attachment 75235 [details]
Test document 1

Comment 3 cstingl 2013-02-21 08:21:23 UTC

Created attachment 75236 [details]
Test document 2

Comment 4 cstingl 2013-02-21 08:22:00 UTC

Created attachment 75237 [details]
Test document 2

Comment 5 cstingl 2013-02-21 08:23:02 UTC

Two test documents attached. To reproduce: Open both documents and proceed from step 7.

Comment 6 Jorendc 2013-08-06 20:20:17 UTC

(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.