Ask Your Question
1

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

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

anonymous user

Anonymous

updated 2013-01-03 15:51:07 +0200

manj_k 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

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

2 Answers

Sort by » oldest newest most voted
5

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

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 gravatar imageptoye ( 2015-07-20 12:10:44 +0200 )edit
0

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

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 14,754 times

Last updated: Jan 05 '13