[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 12:09:52 UTC 2024


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

--- Comment #14 from Eyal Rozenberg <eyalroz1 at gmx.com> ---
(In reply to ady from comment #13)
> Calc is behaving the same as any other spreadsheet tool.

No, it doesn't. That is, not in principle. We consider what other spreadsheet
apps do, and then decide whether to adopt such behavior or not. Very often, we
adopt; but also often - we don't, or not quite.

> If you don't want a
> rectangular selection, then use [CTRL] in order to add the ranges you want
> selected.

No. Ctrl is for a disjoint selection. When you want to select a contiguous
sequence of cells, you use the Shift key.

> 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).

Which is why the entire merged cells are, and should be, selected when the
otherwise single-column selection is made using the Shift. But - cells which
have _not_ been merged should be unaffected, w.r.t. selection, when other
cells, in other rows, have been merged.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list