Created attachment 166830 [details]
Data source file with data table from Excel
Attached Excel made file contains a named range that points to an external file and references an Excel Tables values by their columns name.
When this file is saved unchanged in Calc and reopened in Excel, it finds invalid contents.
Steps to reproduce:
1. Open attached file, check Edit – Links to external files: link is there
2. Save as XLSX and open it in Excel.
External file reference not saved, Excel indicates broken named range on open.
External file reference saved.
Version: 188.8.131.52.alpha1+ (x64)
Build ID: f27c4ec5c864395f4cdaec32d7e95ff24e4f43c8
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Note: this may be a consequence of bug #137846 but filing just in case it's not.
Created attachment 166831 [details]
Example file with defined name referencing the data table in the other file
Created attachment 166832 [details]
The example file as saved by current Calc
Created attachment 166833 [details]
The example file opened in Calc
Created attachment 166834 [details]
The Calc-saved example file opened in Excel 2013
Version: 184.108.40.206.alpha0+ (x64) / LibreOffice Community
Build ID: 4677345e3695bac158bb04048b4d5c608ed764b4
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
*** Bug 144636 has been marked as a duplicate of this bug. ***
*** This bug has been marked as a duplicate of bug 144397 ***
(In reply to m.a.riosv from comment #7)
> *** This bug has been marked as a duplicate of bug 144397 ***
A filesave bug is duplicate of a fileopen one? Doubtful.