https://bugs.documentfoundation.org/show_bug.cgi?id=158288
--- Comment #28 from Sahil Gautam <printfdebugg...@gmail.com> --- Hi, I had some more ideas related to this bug, and the related bugs. So as per my understanding, a merged cell is the top left cell of the merge range, just covering the other cells (hiding them). This means that the data for the covered cells (covered by the top left cell) is also being stored in the sheet. Also since the merge cell is different form other cells, as it's dimensions are different form other cells, it adds friction when selection interacts with the merge cell rectangle. Some of the things like "I want to select this or that" don't work smoothly out of the box. And this is the standard behaviour across all the spreadsheet software available. I propose we go out of the box. So when dragging and selecting, we should show all the hidden cells as shadows, so that the selection/dragging becomes more intuitive and once the select/drag is over, we can just hide the shadows of the hidden cells, letting the top left cell cover the whole merge area. This would eliminate a whole lot of merge x selection bugs + would be more user friendly. -- You are receiving this mail because: You are the assignee for the bug.