Ask Your Question

Vertical alignment default in calc.

asked 2019-08-30 09:09:03 +0100

Rip Van gravatar image

The vertical alignment default in calc is "bottom". I (nearly) always change this to "middle". Can the default be changed to "middle" and if so, how is it done?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-30 14:26:41 +0100

Opaque gravatar image

updated 2019-08-30 14:53:31 +0100


you can do that by making your own Calc default template: To do so, perform the following

Procedure deleted - see Update 1

Procedure tested using:

Version:, Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

Update 1: adapted procedure regarding the comment of @Mike Kaganski

  • Open an empty new Calc spreadsheet
  • Open Styles -> Manage Styles (or F11)
  • Right click on style Default
  • Select Modify
  • Go to tab Alignment
  • Make your preferred setting in dropdown Vertical (in your case Middle)
  • Ckick button OK
  • Go to File - Templates -> Save As Template
  • Provide a Template Name (e.g. "MyCalcDefault")
  • Select a Template Category (e.g. "My Templates")
  • Tick option Set as default template (This is the important step)
  • Click button Save
  • Close your file (File -> Close and no save required)
  • Open a new spreadsheet and check you new default setting

If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


Possibly making the said change in the Default cell style of the template would seem more proper?

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-30 14:34:16 +0100 )edit

Of course you are right - this is the consistent style-based approach. Added an update to my answer. Thanks for the hint.

Opaque gravatar imageOpaque ( 2019-08-30 14:37:30 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-30 09:09:03 +0100

Seen: 37 times

Last updated: Aug 30