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

Hiding grid lines via "Fill"

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


Joined: 27 May 2010
Posts: 3

PostPosted: Thu May 27, 2010 4:40 pm    Post subject: Hiding grid lines via "Fill" Reply with quote

Hello All:

Is there a way to hide selected grid lines? In Excel one could highlight an area and select a Fill Color, i.e; white to hide the grid lines. In Calc I can't seem to do this.

Thanks
Bill
Back to top
View user's profile Send private message
stevesaunders
OOo Advocate
OOo Advocate


Joined: 26 Dec 2009
Posts: 408

PostPosted: Sat May 29, 2010 9:06 am    Post subject: Borders Reply with quote

Select cells you wish to alter / Format / Cell / Borders ~ choose which lines, colors, size
_________________
Steve ~ Tennessee USA
Mac OS X 10.6.2 Open Office 3.1
Back to top
View user's profile Send private message
Sticks
Newbie
Newbie


Joined: 27 May 2010
Posts: 3

PostPosted: Sat May 29, 2010 12:45 pm    Post subject: Reply with quote

>Select cells you wish to alter / Format / Cell / Borders ~ choose which lines, colors, size

Thanks Steve:

I am able to format the borders. What I can't seem to do is color fill the default gray grid lines to disappear in a selected area.

Here are two screen shots of what I'm trying to explain:



Uploaded with ImageShack.us



Uploaded with ImageShack.us
Back to top
View user's profile Send private message
stevesaunders
OOo Advocate
OOo Advocate


Joined: 26 Dec 2009
Posts: 408

PostPosted: Sat May 29, 2010 1:11 pm    Post subject: Grid Lines Reply with quote

Sorry I was not plain enough.

If you choose black as a color for your borders you will see black grid lines, if you do not have a black background; in which case you woulf think there are no grid lines.

Change the color of your borders to white with a white background and you may not see them. There still there.
_________________
Steve ~ Tennessee USA
Mac OS X 10.6.2 Open Office 3.1
Back to top
View user's profile Send private message
Sticks
Newbie
Newbie


Joined: 27 May 2010
Posts: 3

PostPosted: Sat May 29, 2010 1:34 pm    Post subject: Reply with quote

Hi Steve:

Still a nogo. Below is what I did.

Line Style:


Background:


In Excel one could simply highlight an area, click the background fill color (in this case I would select white) and voila' the default gray grid lines were gone.
Back to top
View user's profile Send private message
ken johnson
Super User
Super User


Joined: 23 Apr 2009
Posts: 2032
Location: Sydney, Australia

PostPosted: Sat May 29, 2010 4:58 pm    Post subject: Reply with quote

To achieve the same effect in Calc...
1. Go Tools|Options to bring up the Options dialog.
2. Click the little + button to expand OpenOffice.org Calc then click on View.
3. Under the Visual aids heading remove the tick from the Grid lines option.
4. OK to close the dialog. This removes all of the grid lines on all of the sheets.
6. On your sheet, press Ctrl+A to select all cells.
7. Go Format|Cells to bring up the Format cells dialog.
8. Click the Borders tab.
9. Adjust the Style and Colour eg 0.05 pt continuous Light grey.
10. Adjust the Line arrangement eg click the 4th Default button, the one that looks like a 4-pane window.
11. OK to close the dialog. This applies grid-like borders to all cells on that sheet.
12. Select the range of cells where you don't want grid-like borders then remove those borders by clicking the top-left button on the Borders toolbar that pops-up when you click the Borders button on the Formatting toolbar. No need to use White fill.

Ken Johnson
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
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