You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/09/05 10:49:00 UTC
[Bug 120820] New: Define name which cell range is in other file will
saved incorrect after saved to .xls and .ods
https://issues.apache.org/ooo/show_bug.cgi?id=120820
Priority: P3
Bug ID: 120820
Assignee: ooo-issues@incubator.apache.org
Summary: Define name which cell range is in other file will
saved incorrect after saved to .xls and .ods
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: polo8495@hotmail.com
Hardware: All
Status: CONFIRMED
Version: AOO350-dev
Component: save-export
Product: spreadsheet
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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120820] Define name which cell range is in other file will
saved incorrect after saved to .xls and .ods
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120820
--- Comment #2 from Terry Yang <po...@hotmail.com> ---
Created attachment 79297
--> https://issues.apache.org/ooo/attachment.cgi?id=79297&action=edit
Source file
Add sample file souce .xlsx file
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120820] Define name which cell range is in other file will
saved incorrect after saved to .xls and .ods
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120820
--- Comment #1 from Terry Yang <po...@hotmail.com> ---
This issue also repro on Trunk build Revision 1380503
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120820] Define name which cell range in other file will saved
incorrect to .xls and .ods
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120820
Terry Yang <po...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Define name which cell |Define name which cell
|range is in other file will |range in other file will
|saved incorrect after saved |saved incorrect to .xls and
|to .xls and .ods |.ods
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120820] Define name which cell range is in other file will
saved incorrect after saved to .xls and .ods
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120820
--- Comment #3 from Terry Yang <po...@hotmail.com> ---
Created attachment 79298
--> https://issues.apache.org/ooo/attachment.cgi?id=79298&action=edit
sample.xlsx
Add sample file sample.xlsx
--
You are receiving this mail because:
You are the assignee for the bug.