Line break in cell

Topics: User Forum
Mar 13, 2009 at 5:42 PM

I want to put many line breaks in a cell but i have problem with this. When im using "\n" for this then it works fine for oocalc but not for Microsoft Office. In Microsoft Office everything is in one line and instead line break there is "ugly" char;)

Also tried "\r\n" - doesn't work either.

Mar 13, 2009 at 8:06 PM
For some reason, MS Office Excel requires that the wrap text attribute is set. This should work:


Mar 23, 2009 at 8:03 AM
Thanks. Works fine.