Bug 91929 - Multirow formulas coming from XLSX are cut
Summary: Multirow formulas coming from XLSX are cut
Status: CLOSED DUPLICATE of bug 56036
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-08 09:21 UTC by dmusil
Modified: 2015-06-08 17:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description dmusil 2015-06-08 09:21:48 UTC 
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.
Comment 1 raal 2015-06-08 11:49:46 UTC 
Hello,
please attach testing file. Thank you
Comment 2 m_a_riosv 2015-06-08 14:18:52 UTC 
Seems solved for 5.0 for import, as they are converted to spaces.

Please if you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 56036 ***
Comment 3 dmusil 2015-06-08 17:22:20 UTC 
confirmed as duplicate, same behaviour.