https://bugs.freedesktop.org/show_bug.cgi?id=76310
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from m.a.riosv <[email protected]> --- Hike Mike, I'm not sure about your interpretation of OASIS specification. Normal text in a cell, not formula, retains line feed, and you can locate it from functions or use directly through a reference in other cell. About to use it in text inside formulas: "Evaluators shall treat SPACE (U+0020), CHARACTER TABULATION (U+0009), LINE FEED (U+000A), and CARRIAGE RETURN (U+000D) as whitespace characters." I think you are talking about use a line feed inside a formula, if entered in text between quotes with keyboard Ctrl+Enter it is transformed in a white space, but you can use CHAR() function to get it, e.g. A1: =LEFT("123"&CHAR(10)&"456";7) shows two lines. B1: =A1 shows two lines also. -- 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
