Apache OpenOffice (AOO) Bugzilla – Issue 39772
Conditional format formulas with relative references not correctly adjusted
Last modified: 2005-01-17 10:10:03 UTC
Conditional format formulas that contain any relative references are not adjusted correctly for cell moves eg In cell A1 put =$A$2 Put conditional format on cell A1 formula is - "$A$2" In cell A2 put TRUE/FALSE to show conditional format as set Now insert a new row 2 The formula in A1 is now $A$3, and the conditional format formula has been similarly adjusted as expected. Now repeat the above using relative refences. The cell formula is updated but the conditional formula is not. Inserting a new row 1 does cause the conditional format to be updated, presumably because the cell containing it does move.
Hi, this is a double to Issue 4155 . Frank *** This issue has been marked as a duplicate of 4155 ***
closed double