To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=8812
------- Additional comments from gran...@openoffice.org Fri Jun 25 10:03:17 +0000 2010 ------- Wow, this issue is open for 8 years already … If I had time, I would do it. But I don't atm, so here my thoughts: * «Unlimited» number of rules would in fact be very easy. Very little adjustments would have to be done imho. Just use a list (of variable size) and store the conditions in there. * A bonus feature of this, coming at no cost, would be named conditions. Similar to styles: The user gives a condition a unique name, which can be used for identifying the condition in the list (HashMap e.g.), and, more important, for * Reusing existing conditions. Like, you select column B, add a new condition called «Nonzero» that marks all cells green which are not zero/empty, and apply this condition to the column B. Then select column C and apply the «Nonzero» condition here as well just by applying the already existing condition. * Priority of conditions. This could also be done via a list. The condition at the top is the most important and evaluated at last. For example, the top condition is «Divisible by 4», which colorizes the cells green, and the second condition is «Divisible by 2» which colorizes the cells yellow. Depending on the order either all cells are yellow (%2 at the top) or the ones divisible by 4 are green and the rest yellow. * Highlight cells with conditional formatting. Perhaps via a tool similar to the one that shows paragraphs, spaces, tabulators, and so on. This would be very helpful. * Other thoughts? :) Simon --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org