Ask Your Question

In Calc: Where is the custom default formatting setup? [closed]

asked 2013-01-03 10:51:06 +0200

anonymous user


updated 2020-07-29 11:48:20 +0200

Alex Kemp gravatar image

I need all cells to be always formatted by default as Vertical=middle and Horizontal=center alignment. If I select all cells and then set this formatting, it will change back each time I erase or delete cells etc and I have to do it again and again each time -a frustrating torture! So where is the custom default formatting setup, or at least an ini file? Does it exist? If not, this is a serious omission, like omissions found in software made by amateurs.

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-19 19:25:41.146455


Thanks Olivier, it works! I think though that is should be more intuitive to find the default formatting settings. For example, inside the Format Cells window, a button "Make these settings default" could've made it more user-friendly.

Zen gravatar imageZen ( 2013-01-04 10:44:59 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-01-03 14:11:30 +0200

Olivier gravatar image

You need to use styles.

Press F11 and the Styles and Formatting windows pops-up. Select cells styles on the leftmost button. Select "Default" and right-button click on "Default", then Modify.

The dialog that shows-up will allow you to set the attributes needed for all cells.

If you need this setup for specific new spreadsheet, then you need to save the above settings as a template, and open that template instead of opening a New spreadsheet.

If that template is to be the default template for every new spreadsheet, then go to Templates - Organize, select your desired template, open Commands and Set as Default

edit flag offensive delete link more


This may have worked in LOv3, but not in LO4. There isn't a Templates - Organize button.

You have to go to Templates - Manage which gives you a rather uninformative screen with tabs for the type of template (document, spreadsheet etc.). Once you've selected that, you get a selection of template folders which you then select to get to the templates. Then you select the relevant template and a toolbar magically appears - one of the options is "set as default".

There has to be an easier way!

ptoye gravatar imageptoye ( 2015-07-20 12:10:44 +0200 )edit

answered 2013-01-05 09:54:29 +0200

ROSt52 gravatar image

@Zen Although all format settings are always to be found and modified under Styles and Formatting , your idea is a reasonable one. Thus, why don't you report as an enhancement request in

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-01-03 10:51:06 +0200

Seen: 16,838 times

Last updated: Jan 05 '13