[Solved] Line break in formulas

[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?
Thanks.

[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