https://bugs.documentfoundation.org/show_bug.cgi?id=160371
Bug ID: 160371 Summary: import filter xlsx does not replace MS intersect operator with LibreOffice intersect operator Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: saywel...@gmail.com Created attachment 193308 --> https://bugs.documentfoundation.org/attachment.cgi?id=193308&action=edit Cell B4 should have been converted to =INDIRECT(B2)!INDIRECT(B3) The import filter for xls replaces the space (Excel intersect operator) in the formula correctly with an exclamation mark when opened in Calc. The same file, saved as .xlsx, gives an error ERR:509 missing operator when opened in LibreOffice. The space remains and has not been replaced. It fails in versions of LibreOffice I have tested from 6.4.7.2 to 28.8.0.0.alpha0 Issue arose in https://ask.libreoffice.org/t/intersection-value-using-named-ranges-and-indirect/103897 Attached .xlsx, which opens correctly in Excel 2010, has error in cell B4, easily corrected by manually entering an exclamation mark between the two INDIRECT references. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b38974391e8d4bf0d450abfaa86bbccbe1022995 CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: en-NZ (en_NZ); UI: en-GB Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.