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

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

Anonymous

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

flag of United Kingdom of Great Britain and Northern Ireland

20859 ●19 ●60 ●59 http://etmg.altervista...

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

Comments

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 ( 2013-01-04 10:44:59 +0100 )edit

add a comment

5

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

Olivier

284 ●17 ●32 ●58

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

Comments

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 ( 2015-07-20 12:10:44 +0100 )edit

add a comment

0

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

ROSt52

15876 ●121 ●169 ●193

@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 https://www.libreoffice.org/get-help/bug/

edit flag offensive delete link

add a comment

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

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

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

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

Comments

2 Answers

Comments

Question Tools

Stats

Related questions

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

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