[libreoffice-users] Calc style management

Dear all,

we're working with pretty complex spreadsheets in a project and I've
been pushing for the strict adherence to styles (rather than direct
formatting). But I am approaching levels of complexity that make it
really hard for everyone, and I would love to hear some advice on
what I am doing wrong or how our approach could be improved.

Say you have a simple table with row 1 being a "header" row, row 20
a "results" row, and "plain" rows between, column A holding "dates"
and column B "percentages".

Currently, we have 6 styles to represent all combinations, and after
formatting the entire column A as "dates-plain" and column B as
"percentages-plain", we need to format A1 as "dates-header", B1 as
"percentages-header", A20 as "dates-total", and B20 as
"percentages-total". If ever column A or B needed reformatting (e.g.
because rows were pasted wrongly), then the manual overwriting of
the cells in rows 1, 20 and between would need to be redone.

Is there a better way to approach this? Can styles be somehow
combined, such that cell A1 would simultaneously be a "header" and
a "date" cell, given that the two styles are perpendicular and
don't really affect each other?

Thanks for any insights!

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"science without religion is lame,
 religion without science is blind."
                                                    -- albert einstein
 
spamtraps: madduck.bogus@madduck.net

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted