We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How does one change default value of column width? [closed]

asked 2012-08-08 01:46:23 +0200

anonymous user


updated 2012-08-08 01:47:21 +0200

In Calc, you can go Format > Column > Width to set the width of the column. The default value is .89 inches.

How do you change this default value?

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 2015-10-21 02:13:42.419285

1 Answer

Sort by » oldest newest most voted

answered 2013-01-30 20:52:57 +0200

razon_22 gravatar image

updated 2013-01-31 08:00:46 +0200

The default column width can be changed by using a template.

  1. Open LibreOffice and click Spreadsheet to create a new spreadsheet.
  2. Change the column width to the value you desire by going to Format > Column > Width
  3. Go to File > Templates > Save, enter a name for your new template, click My Templates under Templates - Categories and click Ok.
  4. Go to File > Templates > Organize and double-click My Templates. Select the name of the template you just created from the list that appears. Right click on the name of your template and select Set As Default Template. Click the Close button.
  5. Close the current spreadsheet without saving changes.

Now when you create a new spreadsheet the column widths will be set to the width you specified in your template. These steps can also be used to set the default row height by substituting Format > Row > Height in step 2.

edit flag offensive delete link more


This does not work in If you follow the instructions, it only changes the height of the first row. Every new document you open using your new template looks the same. But even if you select all cells before step 2, it does not change the standard height of 0.45 cm. If you open the "Row Height" dialog and set the "Default value"-checkbox, the old default value (of 0.45 cm) is used. So you can NOT change the default row value by this.

Andreas Heinke gravatar imageAndreas Heinke ( 2018-03-22 09:02:06 +0200 )edit

Question Tools

1 follower


Asked: 2012-08-08 01:46:23 +0200

Seen: 14,792 times

Last updated: Jan 31 '13