Issue 120820

Summary:

Define name which cell range in other file will saved incorrect to .xls and .ods

Product:

Calc

Reporter:

Terry Yang <polo8495>

Component:

save-export

Assignee:

AOO issues mailing list <issues>

Status:

CLOSED DUPLICATE

QA Contact:

Severity:

Normal

Priority:

CC:

knmc, oooforum

Version:

4.0.0-dev

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Source file	none
sample.xlsx	none

Description Terry Yang 2012-09-05 08:49:00 UTC

Build: AOO3.4.1 rev.1372282
Steps:
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]
sample.xlsx

Add sample file sample.xlsx

Comment 4 oooforum (fr) 2023-04-27 09:09:20 UTC

Already reported
Calc does not support external named ranges

*** This issue has been marked as a duplicate of issue 3740 ***