https://issues.apache.org/ooo/show_bug.cgi?id=123668
Bug ID: 123668
Issue Type: DEFECT
Summary: Excel import: newlines in formulas not supported
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 81904
--> https://issues.apache.org/ooo/attachment.cgi?id=81904&action=edit
test case, borrowed from Apache POI
in Excel newlines are valid in formulas, like:
=B1 (Alt + Enter)
+B2
gets the same result as =B1+B2
the sample file is taken from:
http://svn.apache.org/repos/asf/poi/trunk/test-data/spreadsheet/NewlineInFormulas.xlsx
in Excel the cells are:
A1 =SUM(
1;2
)
B3 =B1
+B2
AOO shows:
A1 =SUM()
B3 =B1
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
