Ask Your Question
0

Cell Borders (in thick black lines, not thin)

asked 2021-01-13 18:53:20 +0100

samwise gravatar image

updated 2021-01-13 19:37:21 +0100

Hi,

I have just changed to Libre Office this week.

When I add a ''border'' (from toolbar-icon) around a 'cell' I only get a thin black line (not a thick border)

Can anyone tell me what I have to do to get the 'Toolbar Icon' to automatically add a thick border around a cell please.


(A) This is what i did, but it did not work: Styles> Default>Modify>Borders>Line arrangement>Line>(ok)

Upon rechecking my new instruction had been correctly saved by the software.

Back to my spreadsheet. Press border icon = once again no thick outer line border to any cell?


I have been trying to follow this:

(B) https://help.libreoffice.org/latest/e...

It says 'go to user defined settings! Not sure where that is ?? I was in the RHS hidden screen = 'styles' and 'defaults' The options are: DEFAULT / ACCENT / HEADING / RESULT / STATUS // TEXT But not sure if this is the correct place to be!!


Silly question, but should the software not automatically be configured to put in a thick lined border from the special ''toolbar icon'' !!

Thank you......Sammy

edit retag flag offensive close merge delete

Comments

You closed the question with "right answer was accepted" but you didn't accept the answer. Therefore I reopen so that you can accept it. Site rules, you know ...

ajlittoz gravatar imageajlittoz ( 2021-01-14 07:51:02 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2021-01-13 20:02:46 +0100

ajlittoz gravatar image

LO in general is based on styles. Styles in Calc are less developed than in Writer but the principles are roughly the same.

Toolbar buttons and keyboard shortcuts for formatting are poor substitutes for styles. Buttons apply developers-defined defaults. Unfortunately, contrary to Writer, you can't customise these defaults.

This is apparent with the border button. The associated dropdown menu allows you to choose the "degree" of framing (1-, 2, 4-sided plus internal lines) but you can't select any line width. The adjacent buttons are for line style and colour but there is none for line width.

As already said, there is no menu item nor Tools>Options one to change the defaults.

You have only two options to adjust your borders:

  • fully manual with Format>Cells, Borders tab, applied to the selected cells
  • styling after defining a custom style

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

In case you need clarification, edit your question (not an answer which is reserved for solutions) or comment the relevant answer.

edit flag offensive delete link more

Comments

Oh, what a pity!!! It seemed such a good software choice at first!! I was not aware that the buttons were not working and there is no way of changing them!! Seems to defeat the object of displaying the buttons and has wasted a lot of my time over the past few days!! Now I have to look for an alternative or go back to excel!!! What a drag!! sammy

samwise gravatar imagesamwise ( 2021-01-13 23:38:55 +0100 )edit
0

answered 2021-01-13 18:55:53 +0100

Opaque gravatar image

updated 2021-01-13 18:58:19 +0100

Hello

LibreOffice Help - User Defined Borders in Cells

(There are use cases, which are covered by LibreOffice Help)

edit flag offensive delete link more

Comments

I followed the 1st instruction. Unfortunately this does not create a border after i formatted the border from the toolbar - just a thin black line.

I followed the 2nd instruction in Default. Unfortunately it does not create a border when i click the border button, just a thin black line.

I did try both these options before posting my question, as unsure what else to try.

I

samwise gravatar imagesamwise ( 2021-01-13 19:05:57 +0100 )edit

If you already did that, why don't you let know that fact to possible volunteering in you question. We can't know were you are, and were to start telling how ... what's that hard to tell "Followed description in ... and did not succeed"

Opaque gravatar imageOpaque ( 2021-01-13 19:09:47 +0100 )edit

Is this a duplicate of 287330/how-to-set-a-bold-border-default?

If so, there is already an answer there. In case the answer is not satisfactory, comment it instead of creating a nearly identical question.

ajlittoz gravatar imageajlittoz ( 2021-01-13 19:19:56 +0100 )edit

I felt i had not explained my problem correctly. I posted new question, more to the point. That's all. No offence meant.

samwise gravatar imagesamwise ( 2021-01-13 19:27:14 +0100 )edit

There's no offence. But the ergonomics of this site is, well, below usual standards and it is easy to get users confused. In such a case, when you feel you weren't clear enough, it is much better to edit the initial question to reword it. Contributors who answered get notified and can change their answer to fit your needs.

Asking a new question may get unnoticed. This is why in case of follow-on or duplicate it is wise to add a cross-link to both.

ajlittoz gravatar imageajlittoz ( 2021-01-13 19:46:15 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-01-13 18:53:20 +0100

Seen: 14 times

Last updated: Jan 13