Am 15.04.2015 um 14:44 schrieb martin f krafft: > 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. >
Don't be too picky. Concentrate on the cells that need constant editing. There is nothing wrong when you apply some hard attributes to fixed (protected) content. > 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". > Blending data, appearance and calculation is the major weak point of all spreadsheet tools. Spreadsheets are quick and dirty tools. Quick and dirty tools are expert tools and never "fool proof" by any means. All the meticulousness invested by millions of "Excel experts" is a waste of time. A single copy and paste or the unforeseen error of an untrained user may override everything. > 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? > ... and if you include borders, you have percentages-plain-left, percentages-plain-upper. percentages-plain-lower, percentages-plain-right -- 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
