Created attachment 120608 [details]
Example of conditional formatting being changed

When dragging a spreadsheet tab to a different position, conditional formatting that contains $Sheet1.$A$1 style absolute references gets changed, messing up the formatting.

Consider the example spreadsheet attached (CondFormatTest.ods). The cells with conditional formatting should all be green. The conditional formats in the example spreadsheet use different cell reference styles.

Drag Sheet1 to place it after Sheet2. The first and last cells change to red. Examining the conditional formatting rules shows that the rules for these two cells (that use the $Sheet1.$A$1 style) now refer to $Sheet2 instead of $Sheet1.

Next add a new sheet (Sheet3). Drag Sheet3 to become the first sheet. Now the conditional formatting rules for the first and last cells refer to $Sheet3.

It appears that $Sheet1.$A$1 style references are stuck referencing whatever spreadsheet tab is in the original position after the sheet is moved.

The behaviour seems kind of similar to bug 73655 only applied to conditional formatting