https://bz.apache.org/ooo/show_bug.cgi?id=101573

mroe <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |CONFIRMED
           Hardware|Other                       |All
           Keywords|                            |interop_OOXML,
                   |                            |ms_interoperability
             Latest|---                         |4.1.3
    Confirmation in|                            |
                 OS|Windows Vista               |All

--- Comment #6 from mroe <[email protected]> ---
Unzip the test file and open <folder>/xl/worksheets/sheet1.xml with a text
editor.
There one find the code:
--- code xlsx begin ---
<c r="D4"><f>A4+B4
+C4</f><v>6</v></c>
--- code xlsx end ---

Between “B4” and “+C4” there is simply a “newline”. Maybe the parser stops at
this newline.

AOO Calc doesn't allow a newline inside a formula. If one enter a newline it
will always changed to a space.
--- code ods begin ---
table:formula="of:=[.A4]+[.B4] +[.C4]"
--- code ods end ---

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.

Reply via email to