[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 Heiko Tietze changed: What|Removed |Added Severity|normal |enhancement Priority|medium |low Keywords|needsUXEval | CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org --- Comment #23 from Heiko Tietze --- We discussed the topic in the design meeting. On the one hand, one can argue that a selection starts on top-left and goes to bottom-right. In case of merged cells it just includes the full area. In this regard we are compatible with Excel - actually even better since extending the selection beyond the merged cell we keep the narrow range. Reason for this is that a merged cell is just "covering" what is below and values are kept (unlike in case of Excel). However, it might be also reasonable to depict the actual selection and to not extend. Both methods would have benefits. A major blocker is the fact that disjoint cells cannot be selected, only ranges. As long this isn't possible we must not change the current behavior. Totally unclear why this should be a regression. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #22 from Aron Budea --- (In reply to Eyal Rozenberg from comment #19) > It's a straight column-segment. Which becomes an L-shape if one of the cells > on those line is wider than the column. It seems we're still stuck at identifying what a range selection is. Selecting with shift creates a range selection, and range selection extends to the encompassing rectangle. It cannot be a straight column segment with horizontal extensions where there are merged cells. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #21 from ady --- IMHO... (In reply to Bigor from comment #0) > Expected Results: > selected a2:a5 An alternative method to achieve that is already available: Name Box. As for the default behavior in this matter, I do not agree that it should be modified. If at some point some advance compatibility option for a different behavior is added for this, it would not really be Excel-compatible but rather any-other-spreadsheet-compatible, and the current behavior should still be the default. I am not against having alternatives. Calc lacks lots of features that cannot be achieved at all, and requires a lot of very important improvements that are really limiting users (including myself). -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #20 from Eyal Rozenberg --- (In reply to ady from comment #18) > 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. I know what using Ctrl means, but this is avbout the behavior of Shoft. > Again, the specific original problem of selecting A1:A4 is _solved_ by means > of the Name Box. It's not solved. The user does not want to, nor should they need to, click on anything. They just perform a vertical selection using Shift and the down key, and what they get is a wide rectangle, which is not the expressed intent. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #19 from Eyal Rozenberg --- (In reply to Aron Budea from comment #17) > > But of course it's the L shape! > Please test in any version you'd like, no need for merged cells, just plain > old Shift + arrow key behavior: hold Shift, down arrow, then right arrow. It > was never an L shape. It's a straight column-segment. Which becomes an L-shape if one of the cells on those line is wider than the column. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #18 from ady --- (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.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #17 from Aron Budea --- (In reply to Eyal Rozenberg from comment #16) > It's always worked like that, except for the buggy behavior when it comes to > merged cells. If the behavior had been _consistent_, then you could make the > "this is how it's always worked argument" Let me repeat: > (In reply to Aron Budea from comment #11) > > If you press and hold Shift, and press down arrow and right arrow, do you > > expect cells to be selected in an L shape > > But of course it's the L shape! Please test in any version you'd like, no need for merged cells, just plain old Shift + arrow key behavior: hold Shift, down arrow, then right arrow. It was never an L shape. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #16 from Eyal Rozenberg --- (In reply to Aron Budea from comment #15) > It's never worked like that. It's always worked like that, except for the buggy behavior when it comes to merged cells. If the behavior had been _consistent_, then you could make the "this is how it's always worked argument" > We shouldn't change how Shift + selection using > mouse / arrow works on a whim. The rationale for the change has been explained in multiple comments. The arguments against seem to be: 1. Generally prefer no-change in behavior to change. 2. Microsoft Office has the same behavior is we do right now. These two arguments are not without merit, but they are meta-arguments rather than concrete ones. I find they are trumped by the arguments for the change. That being said - this is a candidate for another MS Office compatibility toggle. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #15 from Aron Budea --- (In reply to Eyal Rozenberg from comment #12) > (In reply to Aron Budea from comment #11) > > If you press and hold Shift, and press down arrow and right arrow, do you > > expect cells to be selected in an L shape > > But of course it's the L shape! It's never worked like that. We shouldn't change how Shift + selection using mouse / arrow works on a whim. Again, I'm all for having a mode that behaves the way you would like, but please leave Shift + selection as it is. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #14 from Eyal Rozenberg --- (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.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #13 from ady --- (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.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #12 from Eyal Rozenberg --- Created attachment 194268 --> https://bugs.documentfoundation.org/attachment.cgi?id=194268=edit How a shift+down selection should look like with multiple rows with merged cells (In reply to Aron Budea from comment #11) > If you press and hold Shift, and press down arrow and right arrow, do you > expect cells to be selected in an L shape But of course it's the L shape! If I didn't press right or left, I definitely don't want cells to the right and left of my selection, on previous lines, to get selected - I just want an extension by 1 down. And more generally, see this attachment for what I expect to get when I start from the top cell and go down, in the presence of all sorts of merges. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #11 from Aron Budea --- (In reply to Eyal Rozenberg from comment #10) > (In reply to Aron Budea from comment #8) > > - When you merge A4 to C4, there's no A4 cell anymore, only A4:C4 range, > > I'm not sure that's exactly correct, but let's assume that's the case. If you enter A4 in the cell selector in the formula bar, it turns into A4:C4. > That's the buggy behavior. When I hold down shift and use the cursor keys, I > expect the next cell down from the highlighted cell to be selected. I do not > expect to select "the minimum rectangular range containing the existing > selection plus the next cell" . If you press and hold Shift, and press down arrow and right arrow, do you expect cells to be selected in an L shape, or in a rectangle? I assume you would expect the rectangle to be selected. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #10 from Eyal Rozenberg --- (In reply to Aron Budea from comment #8) > Let's see if my understanding if correct: > - When you merge A4 to C4, there's no A4 cell anymore, only A4:C4 range, I'm not sure that's exactly correct, but let's assume that's the case. > - A range is a rectangular area of cells, > - When you select cells using Shift, or hold the left mouse button and drag, > you select a range. That's the buggy behavior. When I hold down shift and use the cursor keys, I expect the next cell down from the highlighted cell to be selected. I do not expect to select "the minimum rectangular range containing the existing selection plus the next cell" . -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #9 from ady --- (In reply to Bigor from comment #0) > Expected Results: > selected a2:a5 Just click on any cell (so there is no "selected range"), then click on the upper-left "Name Box" and type-in "a2:a5" (without quotation marks). I am not sure about the consequences of applying any action to that selected a2:a5 range, considering that cell a4 is no longer just a4 alone. Now, while the selection itself is possible as I just mentioned, I agree with Aron in comment 5. I am not sure this should be considered a bug. FWIW, Calc already has some possibilities (on the individual cells that conform the merged area, a4:c4 in the example) that are not available in Excel (IIRC, but I cannot check it myself ATM). If you still need to perform actions on individual cells, them maybe they should not be really merged at all and the user should consider some alternative layout. Moreover, there are situations in which the current behavior is desired. Having said that, maybe the OP could provide some practical use-case where the request is more meaningful. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #8 from Aron Budea --- Let's see if my understanding if correct: - When you merge A4 to C4, there's no A4 cell anymore, only A4:C4 range, - A range is a rectangular area of cells, - When you select cells using Shift, or hold the left mouse button and drag, you select a range. This implies once the cells are merged in the example, there is no A2:A5 range anymore, and the smallest range including A2:A5 (and consequently A4:C4) is A2:C5. I'm not arguing there shouldn't be a way to select the least amount of cells+ranges that come with selection of cells, it just won't be a range anymore, and it should be a separate way apart from range selection. (In reply to Eyal Rozenberg from comment #7) > This seems like a bug to me, because it denies us the expressive potential > of the selection. We can choose to select a 3x5 region covering the merged > cell; and we can (try to) select 1x5 region, in one of 3 ways (left, middle, > right). Why should all four user behaviors result in the same thing, while > almost no mouse-down selection behavior can produce a selection of > a1,a2,a3,merged-a4-through-c4,a5 ? I see no argument in this comment why the selection you're looking for shouldn't be done in a different way, perhaps would be good to think about that first, instead of fragmenting the behavior by adding a compatibility flag. -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #7 from Eyal Rozenberg --- (In reply to Aron Budea from comment #5) This seems like a bug to me, because it denies us the expressive potential of the selection. We can choose to select a 3x5 region covering the merged cell; and we can (try to) select 1x5 region, in one of 3 ways (left, middle, right). Why should all four user behaviors result in the same thing, while almost no mouse-down selection behavior can produce a selection of a1,a2,a3,merged-a4-through-c4,a5 ? As for Excel compatibility... perhaps a toggle for our compatibility options in Tools > Options? -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 --- Comment #6 from Heiko Tietze --- LibreOffice behaves exactly like MS Excel, at least on macOS. However, I can follow the idea that selecting b1:b5 should not add a1 and c5 if a2:c4 is merged (as you get it via ctrl). -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 158288] When you select part of a column with merged cells, all columns that are part of the merged cell are selected
https://bugs.documentfoundation.org/show_bug.cgi?id=158288 Aron Budea changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org --- Comment #5 from Aron Budea --- Thinking about this, I'm not sure this should be considered a bug. There's a merged cell in the range, which means your selection isn't strictly within column A, but spans to column C. Excel also behaves the same way. Let's ask the UX team, can you please share your thoughts? -- You are receiving this mail because: You are on the CC list for the bug.