https://bugs.documentfoundation.org/show_bug.cgi?id=91929
Bug ID: 91929
Summary: Multirow formulas coming from XLSX are cut
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
MS excel allows to store formulas with <CR> character, which leads to multiple
row formulas like this:
-------------------
="<vars "&$B$4&"="""&TEXT(B65;"000")&""" "&
" "&$C$4&"="""&C65&""" "&
" "&$D$4&"="""&D65&""" "&
...
" "&$AG$4&"="""&AG65&""" "&
"/>"
-------------------
When file gets open in LibreOffice, formula is cut on the 1st row end and fails
with an error.
To reproduce, create multiple row formula in excel 2010, store it into XLSX
format, open it in LibreOffice.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs