When cells in rows/columns are hidden with Data > Group and Outline > .. these cells are nevertheless overwritten with paste and also the content of these cells is included when copying.
This is contrary to the behavior with the cell that are hidden with filtering.
At least an option to disable this, would be useful.
Version: unspecified (expecting it's so from OOo times)
It's the same when cells are hidden via Hide Column, for example. Wonder how Excel behaves here. Eike, what do you think?
And for now this extension
is our friend.
(In reply to Cor Nouws from comment #2)
> And for now this extension
> is our friend.
Ehh, not :\
Great extension, but we need the 'complementary' function: paste-in-visble-cells-only ;)
*** Bug 114137 has been marked as a duplicate of this bug. ***
*** Bug 118841 has been marked as a duplicate of this bug. ***
We discussed this idea in the design meeting.
Hidden cells are actually zero-sized and it's not just the hidden group but also many other situations where format, paste, calculation are applied. If A:C contains 1 and B is hidden, you still get 3 as sum of A:C; if you copy three cells, it will be pasted in the hidden cells too; and applying a yellow background after selecting col A:C is also done for B.
Personally I would inform the user when any action affects hidden cells. But since this particular case was in request we recommend to keep the current behavior. => WF
Btw, Excel behaves exactly the same and familiarity for users who want to change is prime.