To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76603 Issue #|76603 Summary|Conditional formatting based on fixed referenced ("$C$ |1) are not correctly updated when the referenced cells | are moved (cut&paste), a new column is inserted, etc. Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|hcprieto
------- Additional comments from [EMAIL PROTECTED] Mon Apr 23 07:31:54 +0000 2007 ------- The issue happens when you have conditional formatting applied to some cells, whose behavior is based on the content of some others cells, which the conditional formatting formula references using a fixed reference (like "$C$1). If for any reason you move the cells to another place in the worksheet, the conditional formatting formula does not get updated. It will still reference the old cell location. Different ways to "move" the cell include: cut&paste of the cell, inserting a new column, etc. Please note that, for normal formulas like: =$C$1+$C$2, the references are updated in case the cell is moved. It's only happening to the conditional formatting formulas. A workaround exists. It's still possible to manually change the references. But this behavior is confusing: When inserting, for example, a new column... the user is not expecting such changes in the formating. It could happen he/she doesn't notice the missbehavior till much later. And then, it will not recognize why suddenly the formating of their cells happened. Thanks for your hard work!! --------------------------------------------------------------------- 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]
