https://bugs.freedesktop.org/show_bug.cgi?id=76310

          Priority: medium
            Bug ID: 76310
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: ODF incompliance: Cannot use newline in formula
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: mikekagan...@hotmail.com
          Hardware: Other
            Status: UNCONFIRMED
           Version: Inherited From OOo
         Component: Spreadsheet
           Product: LibreOffice

OASIS OpenFormula specification allows using SPACE, TAB, LINE FEED and CARRIAGE
RETURN as space characters. It also specifies that embedded newline be
represented by single LINE FEED, and requires implementations to "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" (see
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017970_715980110).

Currently, Calc does allow entering newline when editing cell content (using
Ctrl+Enter), but as soon as cell editing is finished, all newlines in formula
are converted to spaces.

This is incompliant with the specification. This limitation is inherited from
OOo 3.3.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to