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: @
Actually, the reason is the invalid cell reference: there's no 0th row, so C0 doesn't point to a cell. What Calc does differently is that it doesn't identify such a literal as any reference, while Excel does, it's just out of range. Let's mark as confirmed, since Calc shouldn't corrupt the file, but reduce priority, it probably only occurs very rarely.