[sc-issues] [Issue 108013] No screen refresh for con ditional formatting with formulas
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108013 --- Additional comments from markyma...@openoffice.org Sat Jan 2 17:15:10 + 2010 --- I agree that a good short-term fix would be to have F9 refresh the screen, as that is the first key I hit (and hit, and hit...) when I didn't see the conditional formatting applied. For the root cause, I'm wondering (without having even glanced at the code) whether having a conditional format applied on a cell could have a flag set to indicate that cell needs to be always rendered upon any update anywhere on the spreadsheet. - 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
[sc-issues] [Issue 108013] Conditional formatting no t updating all cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108013 --- Additional comments from markyma...@openoffice.org Thu Dec 31 22:03:42 + 2009 --- I tried adding the rand() trick in the formula in the conditional formatting dialog box, and that did not seem to help. I will mention that in the original spreadsheet where I encountered the problem, when I added some additional formulas that reference the cells that have the conditional formatting, it works OK. - 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
[sc-issues] [Issue 108013] Conditional formatting no t updating all cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108013 --- Additional comments from markyma...@openoffice.org Fri Jan 1 04:24:26 + 2010 --- That work-around of Ctrl-Shift-R or scrolling to refresh does work for me too. So now I suppose this summary could be Conditional formatting not being reflected until screll is refreshed ... - 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
[sc-issues] [Issue 108013] Conditional formatting no t updating all cells
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 markyma...@openoffice.org Wed Dec 30 17:51:58 + 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$31;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: 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
[sc-issues] [Issue 108013] Conditional formatting no t updating all cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108013 --- Additional comments from markyma...@openoffice.org Wed Dec 30 17:53:31 + 2009 --- Created an attachment (id=66920) Sample spreadsheet showing problem - 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