Issue 118841 - Number format for newline
Summary: Number format for newline
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.2.1
Hardware: PC Windows Vista
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-01-26 22:02 UTC by gonegahgah
Modified: 2013-01-23 01:41 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description gonegahgah 2012-01-26 22:02:51 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?
Comment 1 Regina Henschel 2012-01-26 22:59:27 UTC
I want it too, see

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.
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:29:27 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.