Page 1 of 1

[Solved] Line break in formulas

PostPosted: Tue Dec 11, 2007 12:46 pm
by pavelb
Is any chance to add line break character to formula?

For example:
=”First line text” & if(A1;”
Second line text”;””)

The formula is shown as a plain text when I add line break.

The expected result is:
First line text
Second line text

Have you any idea?

Re: Line break in formulas

PostPosted: Wed Dec 12, 2007 11:28 pm
by Hagar Delest
This is a bug, you should subscribe and vote for it (up to 2 votes per issue) : Issue 18302 - Allow insertion of newline in a cell using a formula