[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed May 22 11:12:33 UTC 2024


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

--- Comment #13 from ady <adylo811517 at 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.


More information about the Libreoffice-ux-advise mailing list