Bug 137847

Summary: FILESAVE XLSX Named range pointing to data range in external file breaks
Product: LibreOffice Reporter: NISZ LibreOffice Team <libreoffice>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: 79045_79045, attila.szucs, miguelangelrv, nemeth
Priority: medium Keywords: filter:xlsx
Version: 7.1.0.0.alpha0+   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=137846
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 104839, 137805    
Attachments: Data source file with data table from Excel
Example file with defined name referencing the data table in the other file
The example file as saved by current Calc
The example file opened in Calc
The Calc-saved example file opened in Excel 2013

Description NISZ LibreOffice Team 2020-10-29 08:29:22 UTC 
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.

Actual results:
External file reference not saved, Excel indicates broken named range on open.

Expected results:
External file reference saved.

LibreOffice details:
Version: 7.1.0.0.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
Calc: CL

Note: this may be a consequence of bug #137846 but filing just in case it's not.
Comment 1 NISZ LibreOffice Team 2020-10-29 08:29:49 UTC 
Created attachment 166831 [details]
Example file with defined name referencing the data table in the other file
Comment 2 NISZ LibreOffice Team 2020-10-29 08:30:10 UTC 
Created attachment 166832 [details]
The example file as saved by current Calc
Comment 3 NISZ LibreOffice Team 2020-10-29 08:30:30 UTC 
Created attachment 166833 [details]
The example file opened in Calc
Comment 4 NISZ LibreOffice Team 2020-10-29 08:30:50 UTC 
Created attachment 166834 [details]
The Calc-saved example file opened in Excel 2013
Comment 5 Roman Kuznetsov 2021-08-02 21:44:25 UTC 
confirm in

Version: 7.3.0.0.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
Calc: CL
Comment 6 m_a_riosv 2021-09-21 14:58:27 UTC 
*** Bug 144636 has been marked as a duplicate of this bug. ***
Comment 7 m_a_riosv 2021-09-21 15:00:42 UTC 

*** This bug has been marked as a duplicate of bug 144397 ***
Comment 8 NISZ LibreOffice Team 2021-09-23 07:15:50 UTC 
(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.
Comment 9 Sophie Sipasseuth 2023-09-18 07:29:24 UTC Comment hidden (obsolete)
Comment 10 Sophie Sipasseuth 2023-09-18 07:32:43 UTC Comment hidden (obsolete)