To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108013 Issue #|108013 Summary|Conditional formatting not updating all cells Component|Spreadsheet Version|OOO310m9 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|markymark7
------- Additional comments from [email protected] Wed Dec 30 17:51:58 +0000 2009 ------- I have a spreadsheet with 4 cells, B3...B6, each cell has a value of 0 or 1. There is a formula in cell C3 of =SUM(B3:B6) Each of the cells B3...B6 have a a conditional format set to the formula like this one in B5: AND($Sheet1.$C$3>1;B5=1) It uses a style to set the cell to a style using a Light Red font. If I have a 1 in cell B3, and the rest are 0, then I set B6 to be 1, B6 gets formatted correctly, but B3 formatting does not get updated to Light Red, unless I edit B3 and re-enter a 1. Hitting F9 to recalculate does not fix the formatting. Also, if I edit cells to end up with just one cell containing a 1, the cell still containing a 1 is still red. Example: http://www.meekmark.com/ConditionalFormattingNotRecalcing.zip --------------------------------------------------------------------- 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]
