Issue 120820 - Define name which cell range in other file will saved incorrect to .xls and .ods
Summary: Define name which cell range in other file will saved incorrect to .xls and .ods
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.0.0-dev
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-09-05 08:49 UTC by Terry Yang
Modified: 2012-09-06 03:26 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Source file (8.84 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-09-05 08:53 UTC, Terry Yang
no flags Details
sample.xlsx (9.62 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-09-05 08:55 UTC, Terry Yang
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Terry Yang 2012-09-05 08:49:00 UTC
Build: AOO3.4.1 rev.1372282
1.Create a Souce.xlsx file in MS office, in put string in A1 

2.Create a sample.xlsx file in MS office, Define 2 different names test and test1, one scope for Sheet1, one scope for workbook, the cell range point to Cell A1 in Souce.xlsx.
In Sheet1 select cell A1, input "=test", and in Sheet2 select cell A1, input "=test"

3.Open those 2 file in AOO, update the links, then saved the sample.xlsx to sample.xls, then reload sample.xls.

4.After reload, update the link, but the cell value, there are 2 "#REF!" error type in those 2 cell range is wrong in Define name.

If we saved sample.xlsx to .ods in step 3, we also will get this error type, and Edit->Links->Update even the name cell range is correct.
Comment 1 Terry Yang 2012-09-05 08:51:41 UTC
This issue also repro on Trunk build Revision 1380503
Comment 2 Terry Yang 2012-09-05 08:53:46 UTC
Created attachment 79297 [details]
Source file

Add sample file souce .xlsx file
Comment 3 Terry Yang 2012-09-05 08:55:15 UTC
Created attachment 79298 [details]

Add sample file sample.xlsx