To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105659 Issue #|105659 Summary|Calc: ODF: Split Conditional Formatting Details from C |ontent Stream Component|Spreadsheet Version|DEV300m60 Platform|PC URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|discoleo
------- Additional comments from [email protected] Tue Oct 6 18:58:38 +0000 2009 ------- A.) THE PROBLEM Lets suppose we want to do some useful, but more complex Conditional Formatting: 1.) suppose we want to identify every *start* of a new series of records (rows) - suppose row 1 is the header row - 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 number of rows delimit unique items, 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. I want to have this conditional formatting schema applied easily to different spreadsheets. B.) SOLUTION >From my point of view, I would like something like CSS within HTML: separate >the 2 layers: *Content* and *Conditional Formatting*. 1.) This 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
