Bug 137847 - FILESAVE XLSX Named range pointing to data range in external file breaks
Summary: FILESAVE XLSX Named range pointing to data range in external file breaks
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Corrupted XLSX-DataRange
  Show dependency tree / graph
 
Reported: 2020-10-29 08:29 UTC by NISZ LibreOffice Team
Modified: 2023-09-18 07:32 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Data source file with data table from Excel (8.97 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-10-29 08:29 UTC, NISZ LibreOffice Team 		Details
Example file with defined name referencing the data table in the other file (9.25 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-10-29 08:29 UTC, NISZ LibreOffice Team 		Details
The example file as saved by current Calc (5.28 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-10-29 08:30 UTC, NISZ LibreOffice Team 		Details
The example file opened in Calc (41.74 KB, image/png)
2020-10-29 08:30 UTC, NISZ LibreOffice Team 		Details
The Calc-saved example file opened in Excel 2013 (43.92 KB, image/png)
2020-10-29 08:30 UTC, NISZ LibreOffice Team 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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)