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