Issue 118841

Summary:	Number format for newline
Product:	Calc	Reporter:	gonegahgah <gonegahgah>
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P5 (lowest)	CC:	issues, rb.henschel
Version:	OOo 3.2.1
Target Milestone:	---
Hardware:	PC
OS:	Windows Vista
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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 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.

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.