Bug 89350 - FILEOPEN: Excel-generated cells with formulas containing line breaks not parsed correctly
Summary: FILEOPEN: Excel-generated cells with formulas containing line breaks not pars...
Status: RESOLVED DUPLICATE of bug 56036
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.5.2 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-12 19:29 UTC by dan
Modified: 2015-02-12 22:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
excel file with multi-line formula (rows 6-9, column D) (41.11 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-02-12 19:29 UTC, dan 		Details
View All 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 dan 2015-02-12 19:29:32 UTC 
Created attachment 113350 [details]
excel file with multi-line formula (rows 6-9, column D)

In excel, you can insert line-breaks into your formulas to break up long complicated formulas (on OS-X, this is done by hitting command+option+enter in the formula editor):

http://imgur.com/qfVGywR

When you open these files in libreoffice, none of the formula after the first line appears, and libreoffice treats it as an invalid formula:

http://imgur.com/83MIHUC

Attached is an excel file that reproduces this
Comment 1 m_a_riosv 2015-02-12 21:51:24 UTC 
I think this is a duplicate.

Please if you are not agree reopen it.

*** This bug has been marked as a duplicate of bug 76310 ***
Comment 2 dan 2015-02-12 22:06:50 UTC 
76310 seems to be discussing more about edit support, while this is saying that bringing in such an excel file causes your spreadsheet to break. 

Nevertheless, 76310 links to https://bugs.documentfoundation.org/show_bug.cgi?id=56036, which is probably the better dupe reference.

Thanks for catching that!
Comment 3 m_a_riosv 2015-02-12 22:23:41 UTC 
Right, then better we can change the duplicate bug.

*** This bug has been marked as a duplicate of bug 56036 ***