Brian - Thank you for the hints for an automatic universal font change in Calc.
I will create a new template and invoke that for my spread sheet usage going forward. I will increase the number of sheets to 10, rather than the default 3, and set a properly (for my eyes) sized font on each sheet, and delete un used un needed sheets from various spreadsheet documents. Having all sheets within one document pre "formatted" to the desired font and size will be less frustrating than having to remember to invoke the template for each sheet added. Again, thank you. On Tue, Jul 19, 2016 at 1:33 PM, Brian Barker <b.m.bar...@btinternet.com> wrote: > At 12:57 19/07/2016 -0700, Jim McLaughlin wrote: > >> How do I change the default font in Calc? I have vision issues and both >> the Arial font structure as well as the default size are an issue for me. >> While I can change each new spreadsheet's font type and size on the tool >> bar, I'd prefer a manner in which I can change the default font to my >> preferred one. >> > > I think the only simple way to do this - which is very simple - is to > create a template. > > o Create a new spreadsheet document. > o Click in the small rectangle at top left (where the row and column > headers meet) to select the entire sheet. > o Make all the formatting changes you wish. > o Go to File | Templates > | Save..., give the new template a name, and OK > to save it - probably in My Templates. > > When you need a new spreadsheet, invoke this template via File | New> | > Templates and Documents, or the Templates and Documents entry in the > drop-down menu under the down-arrow next to the New button in the Standard > toolbar, or the Templates... button on the start screen. > > If you wish, you can make your new template the default for new > spreadsheet documents: > o Go to File | Templates > | Organise... . > o Open My Templates and select the new template. > o Click Commands | Set As Default Template. > > Note that this formatting affects only any sheets you apply it to > individually, so you should consider formatting all three of the sheets a > new document has by default - or perhaps even more. Even if you do this, > any new sheets you create in documents derived from this template will - > perhaps surprisingly - have the original defaults, not yours. You can work > around this by creating additional sheets by copying existing ones instead > of creating new ones. > > If it suits your practices better, you can save a template or a copy or a > shortcut to it wherever you prefer - perhaps on your desktop. > > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
