To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71104
------- Additional comments from [EMAIL PROTECTED] Fri Jan 12 06:00:37 -0800 2007 ------- Sorry, but I am not sure we mean the same. I DID NOT make the column relative. I just mentioned that the sheet reference is relative, since I omitted this. I have created a sample doc and attached it. It is exactly my previous example. And it is a defect. Just open the document, select the header of column B, and then insert a column (between A and C). You will see, that A has still the value aa1 as before, although it is a formula (previously pointing to C1, and now pointing to D1), but the format changed from Heading to Normal, since the conditional formating still points to C1. This is not consistent and it is annoying to adapt conditional formatting formulas everytime you insert a column between the referring and the referenced column. If you insert a new colum before A or after C, there is no problem. Best regards --------------------------------------------------------------------- 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]
