OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Word Wrapping in Formula

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
ShunDi
Newbie
Newbie


Joined: 30 Jun 2005
Posts: 1

PostPosted: Thu Jun 30, 2005 8:45 am    Post subject: Word Wrapping in Formula Reply with quote

Hi there - I got the following problem:

I got some values (text) in lets say A1,A2 and A3.
Now I want to put these values in one cell, but each wrapped:
______
| Man |
|---------|
| Horse |
|---------|
| Rain |
|---------|
schould automatically be written in a pre-defined cell as:
______
| Man |
| Horse |
| Rain |
|---------|

I thought of a way like this: Formula: =A1&CarriageReturn&A2&CarriageReturn&A3
It's nonesense of course, but is there a way to integrate a CR,LF,etc. into a formula?

Thanks in advance,

Shun Di

PS: Please no CTRL+Return-Answer - I don't need a manual-break/automatic-cell-break
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Thu Jun 30, 2005 11:12 am    Post subject: Re: Word Wrapping in Formula Reply with quote

ShunDi wrote:

PS: Please no CTRL+Return-Answer - I don't need a manual-break/automatic-cell-break


Well, I'll try to meet you half way:

Suppose you have a b c in cells A1, B1, C1.

Define a new style if convenient, or simply pre-format the cell where you want to show a vertical alignment ...
a
b
c

You'll see what to do in the dialogue; in fact you click on the button that shows a vertical alignment..

With cells preformatted, then in D1 you'd simply need to concatenate. I see no way to do this formatting within the formula. Perhaps someone else will.

David.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group