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.
