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?
Hello
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: 6.3.0.4, 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 @mikekaganski
- Open an empty new Calc spreadsheet
- Open
Styles -> Manage Styles(orF11) - 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 -> Closeand 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.
Possibly making the said change in the Default cell style of the template would seem more proper?
Of course you are right - this is the consistent style-based approach. Added an update to my answer. Thanks for the hint.
I don’t have enough points to upvote, but this works for me. Thank you.