Created attachment 187392 [details] Example file from Excel Attached document contains a CELL() function call with the "filename" infotype parameter. (also all other supported infotypes using attachment 187170 [details] as external example file, but focus only on this one here) In Excel this gives a string in the driveletter:\<path>\[filename]Sheetname form, e.g C:\Users\Gabor\Documents\[cell-function.xlsx]Sheet1 In Calc this is opened differently (and as 'file:///C:/Users/Gabor/Documents/cell-function.xlsx'#$Sheet1 It would be more interoperable to imitate the Excel-like behavior, at least in case of xlsx-files. See also bug 106151 which suggests introducing a CELL.XL function for interop purposes, starting with a different interop problem. Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: b3c88dc039d447322b8c8c564ab6e2f0ce9c5b90 CPU threads: 14; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: threaded and back to 3.5
Created attachment 187393 [details] The example file in Excel 2016 and Calc master
Is it important to return the *file path* as opposed to *file URL* as the result, or is it important to only focus on using the Excel A1 syntax? These are two different targets. Excel can easily accept file URLs, and only needs the Excel A1 syntax to avoid errors, so IMO simply requiring that CELL function honored Options->Calc->Formula->Formula syntax, or maybe Detailed Calculation Settings->Custom->Reference syntax for string reference would already be interoperable.
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5c7196acbdd949005c1b52aeab34b5448e09011e tdf#155402 - sc improving CELL() function return value in case of OOXML It will be available in 24.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.
Balazs Varga committed a patch related to this issue. It has been pushed to "libreoffice-7-6": https://git.libreoffice.org/core/commit/6af0508592ea7d62e5452b88953c3aa7ddb0b281 tdf#155402 - sc improving CELL() function return value in case of OOXML It will be available in 7.6.0.0.beta2. 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.