Calc default border thickness change

[John5456]

The newest updates have default border thickness of 0,75pt in stead of 0,05pt (the old one)

How to change this back to 0,05pt?

This question has been asked over and over again, and it has NEVER been answered.

Default styles or templates do NOT work, they do not change it. Changing the style in every sheet separately does NOT work. Changing the thickness from the toolbar buttons does NOT work

The ONLY thing that works is

Clicking mouse right button
—> format cells
—> borders -tab
—> drop menu of border thicknesses
—> select 0,05pt
—> close menu

And you have to do this to EVERY area of borders separately! 6 clicks for every single area of borders, in every single sheet you ever do, for the rest of your life!

Just because someone decided to change the default to 0,75pt

1. Change the default back to 0,05pt
2. Give people a chance to set the defaults themselves

[Zizi64]

@John5456

The ONLY thing that works is

Clicking mouse right button
—> format cells
—> borders -tab
—> drop menu of border thicknesses
—> select 0,05pt
—> close menu

My tips:

• Use the Cell Styles, and delete the direct (manual) formatting properties.
• Create and use Templates with the desired Styles.

[John5456]

That doesn’t work, not even within a single sheet file.

Even if I select all the cells, delete direct formatting, go to Cell Styles, change the border thickness to 0,05pt and save as default Template … even after that, creating new borders they become 0,75pt and I have to change the borders to 0,05pt to every single area separately.

[Zizi64]

I meant working templates and your spreadsheet documents with the desired and well adjusted Cell Styles, but not the Default Template.

[sokol92]

@John5456

6 clicks for every single area of borders

You can do these operations in one click.

1. Place the following macros in any module of any library from My Macros & Dialogs.
2. Assign any keyboard shortcut you like to the SelectionBorderHairline macro.
3. Select any range (or multiple ranges) of cells and apply a keyboard shortcut.

Option Explicit

' Sets the border of cells in oRange to Hairline width.
Sub RangeBorderHairline(ByVal oRange As Object)
  Dim tBorder, lBorder 
 
  tBorder=oRange.TableBorder2
  With tBorder
    lBorder=.TopLIne
    lBorder.LineStyle=0
    lBorder.LineWidth=2   ' HairLine (0.05pt)
    
    .TopLine=lBorder        : .IsTopLineValid=True    
    .BottomLine=lBorder     : .IsBottomLineValid=True
    .LeftLine=lBorder       : .IsLeftLineValid=True    
    .RightLine=lBorder      : .IsRightLineValid=True            
    .HorizontalLine=lBorder : .IsHorizontalLineValid=True    
    .VerticalLine=lBorder   : .IsVerticalLineValid=True            
    .IsDistanceValid=False
  End With  
  oRange.TableBorder2=tBorder
End Sub

Sub SelectionBorderHairline
  RangeBorderHairline ThisComponent.CurrentSelection
End Sub

[agr00m]

Also not a fan of the new thickness. The macro only works if you want to set outer border & all inner lines. If you just want to add a top/bottom/side/etc border, you’ll still need to do the full 6-step process.

You could potentially make a separate macro for each of the 15 border options, assign them to the toolbar, replacing the original Borders command, but since you can’t create a drop-down menu, this would take up considerable real-estate.

Better if they would just change it back to 0.05pt, or allow the user change it in the default template.

[eeigor]

I used to use a thickness of 0.05 (hairline), but now I use 0.75 (thin). When printing, it will be the same if you replace the new cartridge with the old one.

[erAck]

@John5456

The newest updates have default border thickness of 0,75pt in stead of 0,05pt (the old one)

I don’t know from which ancient version you upgraded, already 5.3.7 had 0.75pt default.

@John5456

Just because someone decided to change the default to 0,75pt

My memory may fool me, it was ages ago, but I slightly remember it had something to do with saving certain line types to Excel formats that didn’t survive for thinner widths.

[mikekaganski]

You likely confused something. @John5456 talks about the toolbar button that applied borders; and it puts 0.05pt in 5.3, as well as in 7.0. Related to tdf#48622 and tdf#145828 (v.7.3).

[erAck]

Oh somewhere in the middle of his description he mentions a toolbar button among other things… So, making the toolbar button actually follow the long standing default setting makes sense to me.