https://bugs.documentfoundation.org/show_bug.cgi?id=151880
--- Comment #4 from Colin <[email protected]> --- If The range is created with the dates and CFed with the colour scale and a cell is then inserted into the middle - it extends the range of the CF which is what I would expect. If I copy the last cell into the empty location with paste special it does indeed conform to the three colour scale. However, if I insert yet another cell directly above the first insertion (the darkest green one) and copy the last cell into that location the new cell is not CFed - The colour scale has been annulled but this annulment is not reflected in the CF manager. The CF manager now indicates that the singleton cell thus created has its own scale format. The characteristics of this orphan format are identified as identical to the surrounding range - from which the source was copied - but in reality, no formatting is effected. Surely this can't be right. The copied cell brought its own format which is the range format in which it resides but the new cell is unformatted despite every indication that it has been formatted. The orphan together with the two non-contiguous ranges ineffectively overlap. I think, if Excel is identical, then they both have an "interesting" interpretation of this particular situation. It's probably fair to say that moving things into and out of the defined CF range adheres to the existing logic and mechanics of such an action and the consequences of that action need to be better understood by users who may intuitively believe the change wil aLways be what they are expecting rather than the logical consequences of complex "follow me" processing. -- You are receiving this mail because: You are the assignee for the bug.
