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

Reply via email to