https://bugs.documentfoundation.org/show_bug.cgi?id=158288
--- Comment #13 from ady <adylo811...@gmail.com> --- (In reply to Eyal Rozenberg from comment #12) > But of course it's the L shape! Calc is behaving the same as any other spreadsheet tool. If you don't want a rectangular selection, then use [CTRL] in order to add the ranges you want selected. I already mentioned a way to select the range A1:A5 without selecting other cells that would be also selected by doing it by dragging the mouse or by arrow keys. A merged range of cells is no longer just an independent group of cells. They are related, and behaving almost (and for the most part) as a unit (except for some extra advantages that Calc provides which are not available in some other spreadsheet tools). IMHO, the initial problem of selecting a specific range only (A1:A5) without having the merged cells being selected too, has a solution. For most situations, the current behavior is broadly used and acceptable. For less-frequent needs, there are alternatives (for either selecting cells or for implementing a different layout). I don't see a good-enough reason to change the default behavior (which users have been using for several decades on every spreadsheet tool). -- You are receiving this mail because: You are on the CC list for the bug.