To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92628 Issue #|92628 Summary|Cell References with $ in Conditional Formatting incor |rectly updated when rows are inserted or deleted Component|Spreadsheet Version|OOo 2.4.1 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|waynemv
------- Additional comments from [EMAIL PROTECTED] Sun Aug 10 05:40:42 +0000 2008 ------- If new rows are added, or rows deleted, above a region of the spreadsheet containing conditional formatting with dollar signs... the cell references in the conditional formatting do not stay in sync with the new locations of the cells they were intended to reference. Let conditional formatting in cell B4 be "B$3<=$A4". If row 1 of the spreadsheet is deleted, cell B4 is now referenced as B3, and its conditional formatting changes to "B$3<=$A3". But it should change to "B$2<=$A3". (The dollar signs should not prevent any cell references from being updated in this case.) --------------------------------------------------------------------- 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]
