[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?
Thanks.
Last edited by Hagar Delest on Sun Mar 20, 2011 12:28 am, edited 3 times in total.
Reason: tagged [Solved].
pavelb
 
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.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28560
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 29 guests