Created attachment 195380 [details] Source for import Open attached document. It has on the left side the import of Excel table "myData". It becomes a database range in LibreOffice. That is correct. Column K contains the formulas as text as they are used in Excel. Column I contains =FORMULA(col F) and shows, what LibreOffice has produced in import. Columns F:H should show the same data as columns B:D. You will see error #NAME?. (If you see a different error, that is likely bug 162087. In that case look at Tools > Options > Calc > Formula whether the option "Use English function names" is really off and reload the document.) The column I has for example {=myData[#headers]}. The lowercase 'headers' show, that the keyword is not detected. Reason for the error is, that the import generates a wrong expression. For LibreOffice it has to be {=myData[[#Headers]]}. Notice the double brackets. You can use column L to test this: Enter =myData[[#Headers]] in cell L4 and finish with Ctrl+Shift+Enter to generate a matrix formula.
Reproducible Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d5d4e1334957abc29c5c4f543a8cd15a5aaf8748 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Created attachment 195479 [details] Allow to use single brackets around keyword Hi Eike, next approach. Is that place correct? If not, can you provide me code pointers? If the place is correct, do you see problems, that I need to address in addition? Your advise is welcome.
Oh great, I accidentally committed almost the same (with wrong number of bug 162087), but only the second part.. worked though. 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. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. I'll check and may complete it with the other half with you as author.
Yeah right, the pre-skipping of everything up to the next ']' is executed then.
Regina Henschel committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/4aa2d5ede17ddf7345804deb200983367990a7e2 Related: tdf#162093 TableRef item specifier may occur standalone It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/25a42da1f94cfd0555fc83126888eb605a9014f2 Resolves: tdf#162093 TableRef item specifier may occur standalone It will be available in 24.8.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/171026 for 24-2
(In reply to Eike Rathke from comment #3) > I'll check and may complete it with the other half with you as author. I feel flattered :)
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/aa5a10016b1d78c4913775ac8990cebe48f1e38e tdf#162093: sc_subsequent_filters_test4: Add unittest It will be available in 25.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: dc9486f2443fa52588b625c0a2a288bff56a7a45 CPU threads: 32; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-24-2": https://git.libreoffice.org/core/commit/6cdc3e24b5089e94de04d753c5a9b00856ef04cb Resolves: tdf#162093 TableRef item specifier may occur standalone It will be available in 24.2.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-24-2-6": https://git.libreoffice.org/core/commit/b586e7285653e9de917716045de4f0935f9b0953 Resolves: tdf#162093 TableRef item specifier may occur standalone It will be available in 24.2.6. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.