https://bugs.freedesktop.org/show_bug.cgi?id=56036
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|DATALOSS: Nested ifs with |DATALOSS IMPORT XLS(X): |CRLF in formula get |CRLF (newline) in formula |truncated |garbles the formula --- Comment #7 from Mike Kaganski <[email protected]> --- Since 4.2.0.0.beta1, all formulas containing newline character result in Err:501 (Invalid Character). ==Some information== MS Excel allows to use newline in formulas (using Alt+Enter). LO allows to insert newline into a formula (using Ctrl+Enter), but automatically converts it to space character upon finished editing the cell. OASIS OpenFormula specification v.1.2, clause 5.14 "Whitespace", allows using line feed and carriage return as whitespace characters: > Whitespace ::= #x20 | #x09 | #x0a | #x0d (see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017970_715980110) So, this bug is not an ODF limitation, but a serious defect in import filter. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
