[SOLVED] Borders AND Grids Conflict? Help please!

Discuss the spreadsheet application
Post Reply
Phil in SC
Posts: 6
Joined: Sat Apr 18, 2015 6:58 pm
Location: Sumter SC USA

[SOLVED] Borders AND Grids Conflict? Help please!

Post by Phil in SC »

How do you retain thinner gridlines WITHIN a table and keep a thicker border AROUND a table?

Whenever I wish to create a group of cells in a table, it appears that enabling a nice border around the cells will remove the gridlines within the table. I have used every combination available (?) in Format>Cells>Borders but still seem to be allowed only one style/choice of border. To clarify, in the past when using Excel, you could easily keep the internal lightweight grid, and place a thicker grid around the group of cells as well. This seems impossible to do in Calc, but hopefully there is a way that does not require a fancy set of commands?

I promise, I have searched in this Forum at length but cannot find an answer to this question - so my apologies if it has already been covered somewhere. SURELY, I am not the only one running into this problem. THANKS for any help!
Last edited by RoryOF on Sun Apr 19, 2015 8:43 am, edited 2 times in total.
Reason: Added green tick [RoryOF, Moderator]
Phil in SC USA
OpenOffice 4.1.1 on 2014 iMac OSX (Mavericks)
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Borders AND Grids Conflict? Help please!

Post by Villeroy »

Rectangle of cells with black outer border, pink back color and grid lines.
Rectangle of cells with black outer border, pink back color and grid lines.
Border_and_Grid.png (3.6 KiB) Viewed 562 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Phil in SC
Posts: 6
Joined: Sat Apr 18, 2015 6:58 pm
Location: Sumter SC USA

Re: Borders AND Grids Conflict? Help please!

Post by Phil in SC »

Thanks for the above post, but what I am trying to accomplish is to retain the internal grid AND add a slightly thicker border around that. Highlighting the area for the desired border and clicking OK will add the border BUT REMOVE the internal grid....at least until a solution is discovered.
Phil in SC USA
OpenOffice 4.1.1 on 2014 iMac OSX (Mavericks)
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Borders AND Grids Conflict? Help please!

Post by Villeroy »

Rectangle of cells with black outer border, pink back color and grid lines overlayed by pink inner borders.
Rectangle of cells with black outer border, pink back color and grid lines overlayed by pink inner borders.
Border_and_Grid2.png (3.18 KiB) Viewed 557 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Borders AND Grids Conflict? Help please!

Post by acknak »

It's certainly possible, although I'm not sure there is any "easy" way.

The exact sequence of steps here is important.

1) Select the range of cells

2) Format > Cells > Border ...

3) Select the line style for the outer border (say, solid black, 2.5 point)

4) Click on the "Set outer border only" preset (second icon, above the diagram on the left side)

5) Switch to the inner lines: Click in the exact center of the diagram to do this in one step.
Make sure the triangles around the edge of the diagram point only to the inner lines.

6) Click on the line style for the inner lines (say, solid blue, 1 point)

Click OK
AOO4/LO5 • Linux • Fedora 23
Phil in SC
Posts: 6
Joined: Sat Apr 18, 2015 6:58 pm
Location: Sumter SC USA

Re: Borders AND Grids Conflict? Help please! (SOLVED)

Post by Phil in SC »

THANK YOU, my genius friend!
The above instruction nailed it. All good now. I must have been suffering from a brief case of Excel-itis.

All the Best -
Phil
Phil in SC USA
OpenOffice 4.1.1 on 2014 iMac OSX (Mavericks)
Post Reply