Issue 40910

Hi Martin,

basically we act in the same way as Excel does. Main difference is that we show
the selected cell highlighted while Excel just set the cell cursor. So there is
not really a need to change this. So I close this Issue as wontfix.

Frank

BTW CTRL+Z takes back any changes.

ehem - this was closed a little too fast I guess

"HIGHLIGHTED" means selected - giving the opportunity to move within selected
area with ENTER, smart feature - maybe okay. To leave or unselect the
cursor-keys are used. That feature might be acceptable, when multi-cells are
selected.

But: If only one cell is selected, the ENTER will neither move nor leave the
cell!! This is unexpected behavior, and thats why we have this issue here. 

Let me hear, why - if there is nothing to go to for the cursor - the cell can
not be at least unselected on ENTER, if it is one cell only ?

martin

Hi Niklas,

please give us some comment.

Frank

I agree with Martin. It is counterintuitive that after you press enter that the
cell remains highlighted. Pressing enter means you finished editing so there's
no need for that cell to stay highlighted.

I find it poor usability when quickly entering data and having to switch to the
arrow keys or use the mouse to move to the next cell.

Following the same steps, excel moves to the next cell on Enter.

the defect is also reproduced for copy and paste

Confirmed in 1.9.74. If you cut from cell A and past in cell B, OOo will keep
cell B highlighted and selected. Pressing Enter does nothing. 

This is wrong because Excel does not highlight Cell B after pasting. If you copy
from cell A, cell A will have the 'moving dash' outline around it indicating it
is the cell being copied from. You then select cell B, the cell to be copied to.
Cell B has a normal black outline around it. After pasting in cell B, its
contents change, but cell A still has its 'moving dash' outline indicating it is
the cell being copied from. Cell B is still the selected cell. If you press
Enter, cell A no longer has its moving dash outline, but cell B is still
selected (not highlighted). Pressing Enter again moves to the cell below cell B.

If we follow the same flow with OOo: If you copy from cell A, there is no
indication it is the cell being copied from. When you select cell B, the cell to
be copied to, it is selected normally with a black outline. After pasting in
cell B, its contents change, but the cell becomes highlighted. Pressing enter
has no effect.

I agree with Diane. The flow should follow Excel. 

Marking this as confirmed. Updating the summary to be more descriptive.

We have the distinction between "nothing selected" and "a single cell selected"
(shown inverted). Pasting cells selects the target cells. Enter moves within the
selected cells if there is a selection. All of this works as designed.

Before anything is changed about this, there has to be a complete specification
of the desired new behavior. There's no sense in changing single aspects or
special cases to look "more like Excel". So this has to follow the usual
enhancement process.

I agree, no need to follow the behavior of different applications, in prnciple.
But in this case I really think the Excel-behavior might be a good idea.

Pls note, that a basically FUNCTIONAL key (the Enter-key) should in no way
return a no-action to a hit, that is confusing.
The behavior to "walk" through a selected area with <enter> is nice.
So it is just a problem in the one-and-only case, that one cell only is selected.
It should not really be problem to check that the focus has no different cell to
move to, so it can unselect area/cell and move to next cells as usual.

martin