Apache OpenOffice (AOO) Bugzilla – Issue 120820
Define name which cell range in other file will saved incorrect to .xls and .ods
Last modified: 2023-04-27 12:24:53 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.
This issue also repro on Trunk build Revision 1380503
Created attachment 79297 [details] Source file Add sample file souce .xlsx file
Created attachment 79298 [details] sample.xlsx Add sample file sample.xlsx
Already reported Calc does not support external named ranges *** This issue has been marked as a duplicate of issue 3740 ***