[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]

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

--- Comment #18 from ady <adylo811517 at gmail.com> ---
(In reply to Eyal Rozenberg from comment #14)
> (In reply to ady from comment #13)

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

I didn't want to get into the detailed steps; I assumed the intention of my
words would be understood.

1. Click on a cell and drag the mouse to select an area.
2. Release the mouse button. The area is selected.
3. Press the [CTRL] key and repeat the mouse operation on another range of
cells; they can be adjacent to the previously-selected area or not. Without
pressing the [CTRL] key, the prior area would no longer remain selected.

Again, the specific original problem of selecting A1:A4 is _solved_ by means of
the Name Box.

As for the L shape, I don't recall ever working like that with the keyboard,
nor with the mouse, on any spreadsheet tool. As for the behavior when there are
(partial) merged cells, my experience has always been like it is ATM on every
spreadsheet tool I have used; and I have taken advantage of this behavior too.
But maybe I am getting too old to remember.

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