https://bugs.documentfoundation.org/show_bug.cgi?id=173684
--- Comment #4 from ady <[email protected]> --- (In reply to LeroyG from comment #2) > (In reply to ady from comment #1) > Thanks for replying. It make me think. > > > Additionally, please consider the setting: menu Tools > Options > Calc > > > General > (Input Settings) "Position cell reference with selection". > I have it enabled. By disabling it, I see no difference in this issue. If you change the current behavior you would see a difference. > > > Whichever the case, I believe that the affected range is what the Name Box > > (upper-left corner on LTR worksheets) marks, independently of "active" cell. > No. > 1. Select by headers one or more rows > 2. Hold Ctrl and select downward by headers more that one row > 3. Hold Shift and press Up Arrow once > Look at the Name Box. I see nothing that I would not expect to see on the Name Box. (In reply to LeroyG from comment #3) > Not sure what to think about that, but if we... > 1. Select by headers one or more rows > 2. Hold Ctrl and select downward by headers more than one row (not the same > than those in step 1) By using Ctrl at this point you are already affecting the active cell. > 3. Hold Shift and press Up Arrow (at least) once > 4. Hit Enter (once or more) Since you have a specific range of cells selected at this point, the Enter key moves the position to the next cell within the selection. This is useful for introducing data on selected cells or for navigating within selected cells. This also works for individual selected cells. > 5. Hold Shift and hit Enter (once or more) That moves the position to the "prior" cell within the selected area, according to the settings for the Enter key within Options. The Tab key works in a similar way, within the selection. > Steps 4 and 5 could be inverted. Sure; you are navigating within the selected cells. > > Although after step 3 you can write in the active cell, regardless of > whether it is outside the selection, you can't come back to it with step 5. I must be misunderstanding something. I do understand that the initial active cell might not be part of the selected area. That depends on how exactly you select the area / cells. IOW, the initial active cell might not be part of the selection at some point; the former is not necessarily part of the latter. Row and Column headers (or "entire row / entire column") behave differently than (partially) selecting from within the cells area itself. The headers (and/or "entire rows / columns") are somewhat independent. It has always been like that, not only for selection, but for almost everything. -- You are receiving this mail because: You are the assignee for the bug.
