https://bugs.freedesktop.org/show_bug.cgi?id=76310
--- Comment #2 from Mike Kaganski <[email protected]> --- (In reply to comment #1) Hi m.a.riosv, Thank you for considerations. Please note that clause 5 (as vell as the whole OpenFormula spec) covers formulas, not ordinary text entered to cells. With that in mind, please note the following excerpt from 5.15 "Whitespace": >An embedded line break shall be represented by a single LINE FEED character >(U+000A), not by a carriage return-linefeed pair. When embedded in an XML >attribute the linefeed character is represented as “
”. In my opinion, this is the specific gideline how to implement NEWLINES in formula body, not a character matching pattern used as a function's input paramener. Treating this as a function meaningful parameter is illegal, because the whole clause 5.14 is devoted to lexical element "Whitespace" that's usage is defined in 5.2, and that is used (according to 5.2) OUTSIDE any parameters. The mention of string literals in 5.14 is somewhat misleading, and I believe that this mention serves the only purpose to emphasize that the same characters, when, inside such literals, must NOT be interpreted as Whitespace lexical unit. Thus, as the Whitespace is required to stay as user entered it, and as embedded line break is defined in Whitespace, I believe that not allowing this in formula is non-compliance. Specifically, using newlines inside complex formulas may allow for more readable formula (nested IFs starting on new lines with indent, for instance). -- 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
