[Solved] Cell border frustrations

Discuss the spreadsheet application

[Solved] Cell border frustrations

Postby manntis » Mon Mar 25, 2019 9:04 pm

Sometimes in a spreadsheet, we like to put borders around cells or groups of cells. But this can be an exercise in frustration

For example, let's say I have a row of headings over columns. The headings and column entries all have 4 sided borders around the cells. But to demark the headings from the columns, I want the heading row to have a double border along the bottom of the row.

No matter how many times I select "bottom only", Calc insists on putting the double border around all 4 sides of each individual cell.

If I blank out the cell borders first, *sometimes* "bottom only" will work... but then if I go to put back the missing top and sides with a single border, it'll also overwrite the bottom border with a single line, bringing me back to square one.

Column headings in a spreadsheet are pretty common. It seems like there should be an easy way to do this. Obviously, because I'm posting here, I've yet to discover how.
Last edited by Hagar Delest on Tue Mar 26, 2019 8:53 am, edited 1 time in total.
Reason: tagged solved
openoffice 4.1.1 on Windows 10
manntis
 
Posts: 11
Joined: Sat May 28, 2016 4:49 am

Re: Cell border frustrations

Postby John_Ha » Mon Mar 25, 2019 9:26 pm

Please upload a small file showing the problem so that it can be analysed. Use the Upload attachment tab below where you type (128 kB max); or use a file share site, Dropbox or Google Drive for a larger file.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6815
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Cell border frustrations

Postby manntis » Mon Mar 25, 2019 10:09 pm

You can't intuit from my description above?

Attempting to change just the bottom border in a cell that already has a border on all 4 sides won't allow the bottom border to be changed without changing all sides. It's pretty straightforward.
openoffice 4.1.1 on Windows 10
manntis
 
Posts: 11
Joined: Sat May 28, 2016 4:49 am

Re: Cell border frustrations

Postby John_Ha » Mon Mar 25, 2019 10:13 pm

Suit yourself.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6815
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Cell border frustrations

Postby manntis » Mon Mar 25, 2019 10:28 pm

Is there a workaround so one can change just the bottom border?
openoffice 4.1.1 on Windows 10
manntis
 
Posts: 11
Joined: Sat May 28, 2016 4:49 am

Re: Cell border frustrations

Postby RoryOF » Mon Mar 25, 2019 10:31 pm

Screenshot_2019-03-25_20-32-43.png
Screenshot_2019-03-25_20-32-43.png (1.41 KiB) Viewed 169 times
Select the icon for four sides. Then click on the bottom border to unselect it, click on the desired line style and reclick on the bottom border.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29584
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Cell border frustrations

Postby keme » Mon Mar 25, 2019 11:27 pm

The shortcut buttons above the borders preview pane will modify (set or remove) all borders of the selected cell(s) simultaneously.

To modify borders for each edge individually, you have to select that edge by clicking inside the preview pane, picking line style, weight and color for each.
User avatar
keme
Volunteer
 
Posts: 3258
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Cell border frustrations

Postby manntis » Tue Mar 26, 2019 1:07 am

Perfect! many thanks, RoryOF and keme :)
openoffice 4.1.1 on Windows 10
manntis
 
Posts: 11
Joined: Sat May 28, 2016 4:49 am


Return to Calc

Who is online

Users browsing this forum: Zizi64 and 17 guests