2008/4/18, Kenn Goutal <[EMAIL PROTECTED]>:
>
> Nearly always, I like to have my spreadsheets look a certain way.
>
> I like to have all the cells have top-left alignment, with no wrapping,
> no borders, default colours, default font, etc --
> *except* the column headers (cells in the first row that are not empty)
> in which case I want them to have bottom-left alignment, with no wrapping
> 1pt (?) black borders around each cell, boldface,
> nd a special background colour.
>
> On one hand, I'd like to have every new sheet
> be created with these characteristics, by default.
>
> I'd like these formats to be associated either with the row or the column,
> *and* be conditional on whether there's a value in the cell.
> I really don't want to specify that the entire first row
> be populated by cells that look like blank column headers --
> especially given that (I believe) this would make the sheet infinitely
> wide,
> making it hard to print.
>
> But on any given sheet, I could override these formats.
>
> Anybody have any ideas how to accomplish anything like this?
Hello,
What about making a template of this set-up and saving it as .ots?
You can make it the standard or whatever you want in the File > Templates >
Organize window
HTH
--
Guy
using dutch OOo Aqua Beta 3.0.0 (and older) on a iMac Intel DualCore Tiger
and brazilian OOo SRC 680 m241 on an Intel MacBook Pro Leopard
-- please reply only to users@openoffice.org --
Dodoes can't afford to have headaches
