Dear Calc Team,
I would like to easily copy the *Conditional Formatting* across
different sheets.
[see issue: http://www.openoffice.org/issues/show_bug.cgi?id=105659]
A.) THE PROBLEM
Lets suppose we want to do some useful, but more complex Conditional Formatting:
[These examples are functional in Excel 2007; there is a significant
shortcoming in OOo unrelated to this issue.]
1.) suppose we want to identify every *start* of a new series of records (rows)
- suppose row 1 is the header row
- suppose column A identifies distinct groups of records (e.g. vendors)
<VENDOR> <PRODUCT> <QTY>
ORACLE prod1 3
ORACLE prod2 5
IBM prod1 1
IBM prod1 6
- we select everything (except row 1), and enter the following
conditional formatting, based on the formula:
=IF($A1 = $A2; FALSE; TRUE)
[as said, A1 was not selected]
- IF a unique set is identified based on a number of columns,
than we need slightly more complex formulas:
=IF(CONCATENATE($A1; $B1; ...) = CONCATENATE($A2; $B2; ...); FALSE; TRUE)
2.) suppose we create a really complex conditional formatting schema
[Actually, I think this is not possible yet in OOo, but I often do such work in
Excel 2007.]
3.) suppose now that we want to apply this conditional formatting to multiple
sheets and spreadsheets.
B.) TASK
I want to have this conditional formatting schema applied easily to different
spreadsheets.
C.) SOLUTION
From my point of view, I would like something like CSS within HTML: separate
the 2 layers: *Content* and *Conditional Formatting*.
1.) This probably needs ODF-changes, too: add a separate stream for conditional
formatting.
2.) Allow exporting/importing the conditional formatting stream. This way, it
becomes easy to clone the conditional formatting to different sheets, and to
apply minor tweaks to this formatting.
This would greatly enhance the conditional formatting experience.
Many thanks,
Leonard
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
