Ask Your Question

Libre Office Calc i want to apply thick border for cell [closed]

asked 2014-09-05 12:37:18 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How do i apply thick border for cell? Like in excel you have both option in cell border ribbon, of thin and thick border line. I cannot find same option in calc. I required frequently to apply thin and thick border for many cells randomly. Is there any way where i can add custom border to the border section? Or any alternative for this. Thanx in advance

Also any option of creating my custom toolbar in calc

Following above is screenshot

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 16:43:07.918854


above are screenshot of the calc. The selected border i want to have line thickness by 2.0 pt by default how woul i do that and i want to add one more border option with the current default point value. As microsoft excel offers both at same time, is there any atlernative in LibreOffice Calc. Please review and reply.

Nickpas gravatar imageNickpas ( 2014-09-07 05:53:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-09-07 08:16:36 +0200

oweng gravatar image

updated 2014-09-07 08:17:52 +0200

  1. In the sidebar (View > Sidebar if it is not displayed) select the Styles & Formatting panel.
  2. Right-click on the Default cell style entry > New...
  3. Give the new style a meaningful name e.g., "Thick borders" or "2pt borders all around" > select Borders tab > under Line Arrangements section select All Four Borders > under Line section set the required Width (e.g., 2.00 pt) > click OK.
  4. For any cell requiring this newly defined border, apply the cell style either by double-click on the cell style entry in the sidebar or assign this cell style to a keyboard shortcut (Tools > Customize... > Keyboard tab > Category of "Styles" and "Cell Styles" > Function of the name of the newly created style).
edit flag offensive delete link more


But how to change default value from toolbar icon? whenever I apply some borders, the default border line is 0,05. And I want 1 pt. Is this possible? I don't want additional style.

Ljiljan gravatar imageLjiljan ( 2016-05-09 09:39:27 +0200 )edit

@Ljiljan, I believe the Design/UX team are currently working on changing the default value to something more reasonable than the current hairline of 0.05 pt. Refer tdf#53011 and tdf#99027.

oweng gravatar imageoweng ( 2016-05-10 07:13:35 +0200 )edit

I read it, but it does not seem that anything is going to be changed soon. There is no some work around? Thanks for your help.

Ljiljan gravatar imageLjiljan ( 2016-05-11 18:22:21 +0200 )edit

This functionality is so basic, and easy to do in Office: it it is one of many reasons I just nope out of this software after about 200 key strokes in. Basic things like how does the spreadsheet look are not even on the horizon for being made convenient. grrr...

neuronet gravatar imageneuronet ( 2017-04-15 15:57:47 +0200 )edit

Question Tools

1 follower


Asked: 2014-09-05 12:37:18 +0200

Seen: 11,671 times

Last updated: Sep 07 '14