Bug 90025

I'd like to propose an enhancement to handling conditionally formatted cell ranges when cells are copied.

Example: Cell range B2:B10 is conditionally formatted. The list delivered by "Format\Conditional Formatting\Manage..." has a single entry for B2:B10.

Current behavior:

a) Copying inside the same CF range: When cell B4 is copied to B8, the CF range is split into three independent ranges (B2:B7, B8, and B9:B10) with the exact same conditional formatting.

b) Copying from within the CF range to the outside: When cell B4 is copied to D4, an new CF range is created for D4 with the exact same conditional formatting.

Proposed behavior:

a) When cells from within the range are copied to a destination that is also within the same existing CF range, the range should remain exactly as is. In the above example, there would be a single CF range "B2:B10" even after the copying.

b) When cells from within the range are copied to a destination outside the range, the existing CF range should be extended to include the destination. In the above example, there would be a single CF range "B2:B10;D4" after the copying.

The principle could then be extended to copying multiple cells or cell ranges, and maybe the corner case where the destination range partly overlaps with the original CF range. In effect, splitting CF ranges into independent smaller ranges with identical formatting should be avoided wherever possible.