Babocky, Pavel wrote:
Dear Sirs,
I try to convert Excel data sheet to Calc. I found the following
problem.
Break line is possible add to text by CTRL+ENTER. Can I add Break Line
character to a formula?
For example (new line character is shown by NL)
The following example is correct
"First line NL second line"
The following example is not correct
="First line" & IF(L2;"NL Second line";"")
Can you help to me how to add New Line character to a formula?
Best regards
Pavel Babocky
It should be possible to insert a line break using CHAR(10) but Calc
does not recognise that. In fact, it will read a line break as CHAR(32)
which is a space. The best you can do is insert a space where you want
the line break, adjust the column width and format the cell to wrap.
There is at least one thread on the forum dealing with the deficiency:
http://www.oooforum.org/forum/viewtopic.phtml?t=32392
--
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
