To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71392
------- Additional comments from [email protected] Fri Jun 5 13:49:44 +0000 2009 ------- I recently noticed that it's now possible to use STYLE() directly in a conditional format formula. I don't think this has always worked, and I assume someone made the change on purpose, but it is not documented anywhere, as far as I know. E.g.: A conditional format with the formula: STYLE("Heading") will apply the "Heading" style to the cell. The value returned by STYLE() (always zero) and the "Cell style" specified in the CF dialog are apparently ignored. A CF: IF(B3<>0;STYLE("Heading");STYLE("Heading1")) applies either style based on the result of the condition. This nicely resolves the problem described here, even if in a slightly different way than requested. This issue can be closed as far as I'm concerned. --------------------------------------------------------------------- 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]
