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.
Created attachment 192123 [details] The example file in Excel 2016 and Calc master after hard recalc
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.
(In reply to m_a_riosv from comment #2) > @Eike Could be interested. CC'd
This seems to be fixed in master after Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f1f5e9c8d7be16a969e58ebf7cfae99eef5bcb6e Resolves: tdf#162087 TableRef item specifier may occur standalone It will be available in 25.2.0. Recalculation works in all cases now. Thanks Eike!
Also needed is the second part https://git.libreoffice.org/core/commit/4aa2d5ede17ddf7345804deb200983367990a7e2 Or squashed in one https://git.libreoffice.org/core/commit/25a42da1f94cfd0555fc83126888eb605a9014f2 for 24-8
Note that something like Animals[@current_row] is an Excel UI thing, written to file and imported as is here is Animals[[#This Row],[Adoptable]]
(In reply to Gabor Kelemen (allotropia) from comment #4) > Resolves: tdf#162087 TableRef item specifier may occur standalone FWIW, JIC and FTR, that should be bug 162093 (as mentioned by Eike in tdf#162087 comment 3 and in 25a42da1f94cfd0555fc83126888eb605a9014f2), not 162087.