You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/11/09 22:37:41 UTC
[Bug 123668] New: Excel import: newlines in formulas not supported
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: issues@openoffice.apache.org
Reporter: firstofnone@web.de
CC: issues@openoffice.apache.org
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |rb.henschel@t-online.de
Ever confirmed|0 |1
--- Comment #3 from Regina Henschel <rb...@t-online.de> ---
The line feed character belongs to the white spaces, that are allowed in
ODF1.2. see section 5.14 Whitespace in ODF1.2 part 2,
"Evaluators shall treat SPACE (U+0020), CHARACTER TABULATION (U+0009), LINE
FEED (U+000A), and CARRIAGE RETURN (U+000D) as whitespace characters."
and even more,
"Evaluators should retain whitespace entered by the original formula creator
and use it when saving or presenting the formula, and should not add additional
whitespace unless directed to do so during the process of editing a formula."
For details see
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html
So this is not only a valid request for interoperability with OOXML but also a
needed feature for ODF1.2.
Currently UI replaced entered line feeds with a space character. This makes
sense because AOO hasn't got a 'multiple line' input line yet.
But opening too replaces line feeds with space characters and if I understand
section 5.14 correctly, that should not happen.
--
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
Prosper Uniger <fi...@web.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |interop_OOXML
--- Comment #2 from Prosper Uniger <fi...@web.de> ---
(In reply to Edwin Sharp from comment #1)
> Excel 2007:
> A1 =SUM(
> B3 =B1
That's odd, my ancient but fully patched Excel 2003 can read and write formulas
with newlines.
here the link to the POI bug report and how they fixed it:
https://issues.apache.org/bugzilla/show_bug.cgi?id=50440
added interop_OOXML since the bug is with .xlsx-files only
> IMHO Calc shouldn't mimic this useless feature.
But the current behavior suggests the user everything went fine, while parts of
the formula are missing.
--
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
Barrie <ba...@quantimatics.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |barrie@quantimatics.com
--
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
--- Comment #6 from Barrie <ba...@quantimatics.com> ---
Created attachment 81916
--> https://issues.apache.org/ooo/attachment.cgi?id=81916&action=edit
A subset of an MS Excel app using line feeds in formulas
--
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
--- Comment #7 from Barrie <ba...@quantimatics.com> ---
Comment on attachment 81916
--> https://issues.apache.org/ooo/attachment.cgi?id=81916
A subset of an MS Excel app using line feeds in formulas
Edwin,
This may be a repeat of an earlier comment - not sure. The attached .xlsx file
contains a fragment of an MS Excel app that uses line feeds to clarify long
formulas. Without the line feeds, parsing the formula makes me both cross eyed
and cross. When this file is opened in OO only the first line of the formulas
are captured and usually is leads to an Err condition. Thanks for your
interest
--
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
--- Comment #4 from Barrie <ba...@quantimatics.com> ---
I find this defect to be a big headache. I create applications in MS Excel and
I liberally use the alt + enter feature when creating large formulas. The line
feeds provide a lot more readability. Some of my user community like to use OO
Spreadsheet but the apps I send them are rendered useless because all these
long formulas are decapitated to show only the first line.
--
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
Edwin Sharp <el...@mail-page.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |elish@mail-page.com
--- Comment #1 from Edwin Sharp <el...@mail-page.com> ---
Excel 2007:
A1 =SUM(
B3 =B1
IMHO Calc shouldn't mimic this useless feature.
--
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.
[Bug 123668] Excel import: newlines in formulas not supported
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123668
--- Comment #5 from Edwin Sharp <el...@mail-page.com> ---
(In reply to Barrie from comment #4)
> I find this defect to be a big headache. I create applications in MS Excel
> and I liberally use the alt + enter feature when creating large formulas.
>
Please do share an example.
--
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.