Apache OpenOffice (AOO) Bugzilla – Issue 118841
Number format for newline
Last modified: 2013-01-23 01:41:45 UTC
I would like to have a cell with the date broken over two lines. The day and month would go on the first line. The year would go on the second line. So I'm looking for something like "D/M¶YY" where the '¶' forces a newline (wrap) within the cell. Or maybe even an escape sequence like '\n' or some such thing. Is this possible?
I want it too, see https://bugs.freedesktop.org/show_bug.cgi?id=40685 No, it is not possible to use special characters in format code. In Apache OpenOffice you can currently set the cell alignment to "wrap text automatically" and insert a blank into the format code. But it will only wrap there, if the cell is not width enough, and it will wrap inside of numbers too. Be aware, that other application like Excel2010 or LibreOffice will not wrap those content in your document. Workaround: Put the date itself into another, possible hidden cell and use text functions for displaying it with unicode(10) for the line break.
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.