https://bugs.documentfoundation.org/show_bug.cgi?id=89350

            Bug ID: 89350
           Summary: FILEOPEN: Excel-generated cells with formulas
                    containing line breaks not parsed correctly
           Product: LibreOffice
           Version: 4.3.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Spreadsheet
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 113350
  --> https://bugs.documentfoundation.org/attachment.cgi?id=113350&action=edit
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

-- 
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