Hi Rob,
Another thing you could consider is using a text box. This approach has some advantages, such as giving you complete control over size and placement independent of column widths and keeping text which exists as one logical unit together rather than breaking it accross several cells.

To access the text boxes you need to show the Drawing toolbar and click on the T icon.

Brian



Anthony Chilco wrote:

Hi Rob,
I don't think that the method below will give you the same result as the excel command. Justify in excel will split the text into separate cells. The closest would be to select the cells, click 'format / merge cells' then 'format / cells' and check 'wrap text automatically' on the 'alignment' tab. Not exactly the same, but it will look the same.
tc

Ain Vagula wrote:

Rob Poe wrote:

Replying to my own post.  Anyone??


[EMAIL PROTECTED] 10/28/2005 12:19:41 pm >>>


In MS Excel.  If you had a long sentence in one cell (smaller cell than
the sentence).

You painted (selected) an area you wanted the text to appear, then Edit
| Fill | Justify.

Is there anything like that IN OOo Calc?


I answered you some hours after your message, when you have not seen this, maybe you are not subscribed.

Format - Cell - Alignment - Shrink to fit in cell (or something similar, not using English OO.o, it is the last entry in dialog)

ain


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to