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: [email protected] -- To unsubscribe e-mail to: [email protected] 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
