Created attachment 199824 [details] Sample XLSX The attached XLSX, created from minimizing forum-mso-en4-144022.xlsx, contains an external reference in A1, and when it is opened in Excel, the formula reads something like this: ='D:\Users\Peter\Dropbox\Excel Trips\[Holiday trip planner to Alice Springs.xlsx]Sheet15'!C0 (the external link is relative, the beginning will be where the file was opened from) Opening the same file in Calc shows this incorrect formula in A1: =[1]sheet15!c0 Saving the file back to XLSX makes Excel complain about the file, choosing repair removes the formula, with the following message: Removed Records: Formula from /xl/worksheets/sheet1.xml part Observed using LO 25.8.0.0.alpha0+ (9299d425f3ed941d983f68d6dc1e979b4d4d1060) and 3.3.0 / Windows. The link, as exists in xl/externalLinks/_rels/externalLink1.xml.rels inside the original archive is: Users/Peter/Dropbox/Excel%20Trips/Holiday%20trip%20planner%20to%20Alice%20Springs.xlsx The formula that is stored in the sheet's XML file in A1 is: [1]Sheet15!C0 Apparently, this is normal notation. Also attaching a different sample Excel XLSX, where the external link is correctly imported and saved in Calc.
Created attachment 199825 [details] forum-mso-en4-144022.xlsx
Created attachment 199826 [details] Another sample XLSX (doesn't exhibit the bug)
Created attachment 199827 [details] Screenshot of first sample in Excel
Maybe in relation with https://bugs.documentfoundation.org/show_bug.cgi?id=161470 Implement implicit intersection operator "@" like Excel's https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34 Implicit intersection operator: @