[Solved] Line break in formulas

Discuss the spreadsheet application

[Solved] Line break in formulas

Postby pavelb » Tue Dec 11, 2007 12:46 pm

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?
Last edited by Hagar Delest on Sun Mar 20, 2011 12:28 am, edited 3 times in total.
Reason: tagged [Solved].
Posts: 1
Joined: Tue Dec 11, 2007 12:36 pm

Re: Line break in formulas

Postby Hagar Delest » Wed Dec 12, 2007 11:28 pm

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
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Posts: 29006
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Return to Calc

Who is online

Users browsing this forum: No registered users and 11 guests