To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4155
------- Additional comments from hes...@openoffice.org Thu Aug 20 18:37:05 +0000 2009 ------- This should be considered a bug. I make extensive use of conditional formatting, and doing so in Open Office stops any further activity on the spreadsheet because any row / coloumn changes (add / delete) immediately breaks all conditional formatting, and is not acceptable. If you use relative references in your conditional formatting, you can't add/ delete a row/coloumn that moves your formatted cell. If you use absolute references, you cannot add/delete a row/coloumn that will move your referenced cell. This is the single most important reason I can't use OpenOffice, and I can't recommend it in this condition. It's that serious of a bug. I use conditional formatting to quickly visualise the state of the data and it helps me prevent any editing errors, for example. But I cannot do it using OpenOffice, because once I design the conditional formatting functions, the document is pretty much fixed. --------------------------------------------------------------------- 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