[Libreoffice-bugs] [Bug 113232] Cells in rows/columns that are hidden with Data > Group and Outline are overwritten with paste and included when copying

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Nov 12 09:27:51 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=113232

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #6 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201112/42ee1626/attachment.htm>


More information about the Libreoffice-bugs mailing list