How can I make a newline in an Openoffice.org Calc formula?
Solution 1:
It looks like char(10) actually did the trick, but it's just not visible in the sheet. When the data from the spreadsheet is used in a mail merge later (for address labels), the newline is there!
Solution 2:
On Linux you can use:
=CONCATENATE("line 1";char(10);"line2")
Solution 3:
Type CTRL+Enter in an unused cell, then in the formula for K2 use I2&(address of the cell with the CTRL+Enter)&J2
I stumbled upon it by accident (playing a hunch) and it displays correctly and prints correctly...