Bug 159341 - FILEOPEN XLSX Item references to table are not imported correctly
Summary: FILEOPEN XLSX Item references to table are not imported correctly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+ Master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://support.microsoft.com/en-us/o...
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-DataRange
  Show dependency tree / graph
 
Reported: 2024-01-23 15:40 UTC by Gabor Kelemen (allotropia)
Modified: 2024-02-25 10:10 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file from Excel 2016 (9.63 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-01-23 15:40 UTC, Gabor Kelemen (allotropia) 		Details
The example file in Excel 2016 and Calc master after hard recalc (73.75 KB, image/png)
2024-01-23 15:40 UTC, Gabor Kelemen (allotropia) 		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 Gabor Kelemen (allotropia) 2024-01-23 15:40:00 UTC 
Created attachment 192122 [details]
Example file from Excel 2016

Attached example file contains a table and some functions using structured references to its Item specifiers: #All #Data #Headers #Totals @[Column Name]

When the formulae are recalculated, the result is a #NAME? or Err:504 error.

1. Open attached file
2. Go to Data - Calculate - Recalculate Hard
-> Formula results are #NAME? error (for the formulae using #All #Data and #Totals item specifiers) and Err:504 (for the formulae using #Headers).

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d49b0c3654e50ff9b74545140e6f19e008009c33
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded

Looks like this since 5.0 when this started to be supported -> no regression.
Comment 1 Gabor Kelemen (allotropia) 2024-01-23 15:40:34 UTC 
Created attachment 192123 [details]
The example file in Excel 2016 and Calc master after hard recalc
Comment 2 m_a_riosv 2024-01-24 01:41:13 UTC 
Reproducible
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d49b0c3654e50ff9b74545140e6f19e008009c33
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

@Eike Could be interested.
Comment 3 Óvári 2024-02-25 10:10:51 UTC 
(In reply to m_a_riosv from comment #2)
> @Eike Could be interested.

CC'd