https://bugs.documentfoundation.org/show_bug.cgi?id=159341
Bug ID: 159341
Summary: FILEOPEN XLSX Item references to table are not
imported correctly
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
URL: https://support.microsoft.com/en-us/office/using-struc
tured-references-with-excel-tables-f5ed2452-2337-4f71-
bed3-c8ae6d2b276e
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 137805
Created attachment 192122
--> https://bugs.documentfoundation.org/attachment.cgi?id=192122&action=edit
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.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=137805
[Bug 137805] [META] XLSX (OOXML) Data range / Format as Table issues
--
You are receiving this mail because:
You are the assignee for the bug.
