Problem description: Steps to reproduce: 1. Create a conditional format for a range The "Conditional format" list contains now exactly this entry 2. Copy the contents of one cell in this range to another (Copy&Paste) or do some other Copy&Paste actions 3. Look at the conditional formats The "Conditional format" list now contains lots of entries for several parts of the range (which in sum give the range). 4. (additional bug) Then undoing the copy&paste action, the contitional formats remains fragmented. Expected behavior: Copy&Paste within a conditional formated range must not change/split the range. Paste with ("only text/numbers/...") selected into a conditional formated range must not change/split the range. Pasting content with different format may fragment the range. But undo must revert this. Best solution would be some automatism that merges multiple conditional formated ranges with the same conditions and formats to a single range. This should either get triggered after each change that would otherwise change the ranges. Alternatively it's a button in the conditional formats list. Operating System: Linux (Other) Version: 4.2.6.2 release
Hello Michael, thanks for reporting. Enhancement request regarding this issue has been filed. You'll be CCed on that bug then *** This bug has been marked as a duplicate of bug 80768 ***