Ask Your Question

How to set a bold border default [closed]

asked 2021-01-13 14:03:19 +0100

samwise gravatar image

updated 2021-01-13 17:20:01 +0100


I am looking for a 'pathway' to set a 'BOLD BORDER' by default.

So far, can only find a 'pathway' to set a 'bold border' just for the single cell i am workingin: PATHWAY = FORMAT>CELLS>LINE ARRANGEMENT>LINE>WIDTH>(OK)

But this pathway is not saved as a 'default border' for any other cell. This means using the toolbar icon for 'BOLD BORDER' does not produce a 'BOLD BORDER' for any individual cell. Just a normal thin line border (even if i press the 'BORDER STYLE' icon to sellect a bold style)

What I am looking for is a 'pathway' to set up my desired border thickness for every new spreadsheet.

Hoping someone more familiar with '''Libre Office''' can point me to the correct 'pathway set up'

Many thanks...............sammy

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by samwise
close date 2021-01-13 19:16:34.635674


Do not yell.

gabix gravatar imagegabix ( 2021-01-13 16:09:06 +0100 )edit

From an example file (editing your question and using the clip icon, to attach the file) with the real use of bosrdas. It may be necessary to create a style and include it in a new Menu in Calc.

Schiavinatto gravatar imageSchiavinatto ( 2021-01-13 17:18:58 +0100 )edit

@samwise: I reopened the question because I feel you didn't choose the right reason for closing it: your question is not off-topic and it is relevant for many users. Also, closing a valuable question without accepting an answer don't help other users who may experience the same trouble.

Be kind enough to either accept an answer or explain why it is not satisfactory. Then you can close the question. Thanks.

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

If this is a duplicate, mention the duplicate question number. You find it in the address bar of your browser.

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

Follow-up to this question is at 287392/cell-borders-in-thick-black-lines-not-thin

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

1 Answer

Sort by » oldest newest most voted

answered 2021-01-13 14:13:21 +0100

ajlittoz gravatar image

Calc has a notion of cell style, i.e. a collection of formatting to be applied to a cell.

Open the style side pane to see the list of predefined styles.

All these styles can be customised. However, I don't recommend to customise Default style because your modifications will also be forwarded to all other styles (unless they've been explicitly overridden in the other styles). Instead create your own preferred style. It will anyway inherit from Default.

Set your borders in this "preferred" style.

When a cell must be styled "preferred", select it and double-click on the style name.

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


Thank you for your 'Default' suggestions.

I selected the R/H/S Styles menu. I amended the 'DEFAULT' with a new thick border using the following 'pathway': STYLE>DEFAULT>(right mouse click > MODIFY)>BORDERS>(set borders field / set thick borders)>(OK)

I opened these fields again. My thick border preferences had been correctly saved.

I then went back to my open spreadsheet = (I pressed the 'Borders Icon' = it did not display a thick border in any cell when pressed (as per my preferences saved) I then opened another new spreadsheet = (I pressed the 'Borders Icon' = it did not display a thick border in any cell when pressed (as per my preferences saved) I then rebooted my pc = (I pressed the 'Borders Icon' = it did not display a thick border in any cell when pressed (as per my preferences saved)

So I must be somehow still using the wrong format ...(more)

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

Using the toolbar buttons (the border icon) is somewhat contradictory with the use of styles. The styles don't affect the toolbar buttons because these buttons are there to add an extra formatting to what is defined by a style.

Styles are saved in the spreadsheet document. Consequently, a customisation does not affect another file.

If you want to have this change available in all your personal spreadsheets, the best solution is to configure all your styles in a blank spreadsheet you save as a template. You make it then your default template.

After that, all new spreadsheets will display your own design.

If you're under Windows, creating a new spreadsheet from the file browser will not invoke your default template (this is a Windows issue, not an LO one). When you subsequently open this new spreadsheet, it will not be formatted according to your preference.

ajlittoz gravatar imageajlittoz ( 2021-01-13 15:12:34 +0100 )edit

Question Tools

1 follower


Asked: 2021-01-13 14:03:19 +0100

Seen: 26 times

Last updated: Jan 13