[Solved] Word Wrap

Discuss the spreadsheet application

[Solved] Word Wrap

Postby No Idea » Tue Mar 25, 2008 4:46 pm

Hi

When using a spreadsheet, is there a "word wrap" I can use within the colums
Last edited by No Idea on Tue Mar 25, 2008 6:00 pm, edited 2 times in total.
OO 3.2 en-US - Windows XP
No Idea
 
Posts: 30
Joined: Thu Mar 20, 2008 4:24 pm

Re: Word Wrap

Postby r4zoli » Tue Mar 25, 2008 4:50 pm

Format>Cells on Alignment tab down in Properties
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Word Wrap

Postby No Idea » Tue Mar 25, 2008 4:52 pm

Ah ha, fantastic, and thanks for the quick reply.

Much appreciated.

P.S Where is the "Solved" button for this thread?
OO 3.2 en-US - Windows XP
No Idea
 
Posts: 30
Joined: Thu Mar 20, 2008 4:24 pm

Re: Word Wrap

Postby r4zoli » Tue Mar 25, 2008 4:55 pm

Go to the first post, click on edit and edit subject.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Word Wrap

Postby No Idea » Tue Mar 25, 2008 4:58 pm

r4zoli wrote:Go to the first post, click on edit and edit subject.


OK thanks, sorry, I have one more question, is there a way of keeping word wrap permently ticked within properties, I noticed I have to keep ticking it for each colum?
OO 3.2 en-US - Windows XP
No Idea
 
Posts: 30
Joined: Thu Mar 20, 2008 4:24 pm

Re: Word Wrap

Postby r4zoli » Tue Mar 25, 2008 5:40 pm

Click on the left up corner of sheet (where columns and rows meets left to A and up to 1), all sheet will be selected and in this position select Format cells.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
r4zoli
Volunteer
 
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Word Wrap

Postby Hagar Delest » Tue Mar 25, 2008 5:43 pm

You've to create a new cell style or to modify the curent one. Open the Stylist (F11), the list of the styles is there.

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.
AOO 4.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25087
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved]

Postby No Idea » Tue Mar 25, 2008 5:58 pm

Many thanks for everyone's help.
OO 3.2 en-US - Windows XP
No Idea
 
Posts: 30
Joined: Thu Mar 20, 2008 4:24 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 25 guests