To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71392 Issue #|71392 Summary|Provide unlimited conditional formatting styles Component|Spreadsheet Version|OOo 2.0.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|jes
------- Additional comments from [EMAIL PROTECTED] Thu Nov 9 18:04:50 -0800 2006 ------- Enhancement: Provide unlimited conditional formats by allowing the conditional formula to return a string naming the style to be applied. Rationale: Conditional Formatting is the only method provided by Calc to change a cell's appearance based on a value entered in the cell by the user. Conditional Formatting provides at most three alternative styles, which is not adequate for many situations. If Calc was modified simply to allow the conditional formula to return a string naming the style to be applied, an unlimited number of alternative conditional styles could be provided. Detailed explanation: (This refers to the attached spreadsheet: cond_formatting_enhancement.ods) Here are a few cells containing random values. Each cell has a style applied based on it's value: from light blue (zero) to dark blue (100). The appropriate style is applied by the cell's formula, using the STYLE() function, selecting from a table on the other sheet using a VLOOKUP(CURRENT();...) expression. This works perfectly for cells that contain formulas. What if we want to apply styles to cells that contain user-entered data? In this case the cell cannot have a formula to apply the desired style. Instead, the cell style must be applied by conditional formatting, configured through the Format > Conditional Formatting dialog. Unfortunately, the Conditional Formatting (CF) dialog limits the cells to a maximum of only three styles. There is no way to apply more than three styles, even though the application is fully capable of selecting and applying many more styles, using formulas as shown above. The current CF dialog allows the condition to be either a cell reference, or a formula. If the condition's value is TRUE, a user-selected style is applied. The enhancement requested here would allow the conditional formula to return a string naming the style to be applied. If the conditional formula returns FALSE (or an error), then the next condition is evaluated. The user interface exposing this functionality could be as simple as providing one new entry in the CF dialog's “Style” dropdown list, indicating that the style to be applied is named by the formula result. --------------------------------------------------------------------- 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]
