remaining spreadsheet navigation and editing UI updates

[chriddyp]

originally from discussion in #172 (comment)

We should fix all of the items marked with an ✖️ . Feel free to break out these items into separate issues as you work on them.

focussed mode

1. ✅ a cell is in focussed when you click on it (once) or when you navigate to it with the keyboard

2. ✅ arrowing (in any direction) or tabbing in focussed mode changes the cells, keeps it in focussed mode

3. ✅ typing in focussed mode overrides the cell's contents with what you have typed

4. ✖️ enter moves the cell down (Excel) or into edit mode (Google Docs)

   • we do this the google docs way rather than the excel way. we should do it the excel way if possible. i'm not concerned about this for launch.

5. ✅ pasting a string will replace the cells contents with that string

6. ✅ pasting a group of cells will paste the contents across those cells

7. visually, edit is distinct from focussed mode by:
   a. ✅ not having a cursor
   b. ✖️ not having any highlighted text. seeing the highlighted text when in focussed mode does not look right and it makes it harder to distinguish between the two modes. this would be a 'nice to have' for launch.

8. 🔧 141 move in cell #172. typing text keeps the cell in focussed mode: after typing, arrowing moves the cell, it does not move the cursor

9. ✅ delete deletes the cell

10. ✅ escape reverts the edit back to what the cell's contents originally were

edit mode

1. ✖️ a cell is in edit mode when you double-click
   • slow double click works, but not the typical fast double-click
2. ✅ a cursor for editing the contents of the text appears
3. ✖️ In excel, F2 also gets you into edit mode
4. ✅ arrowing left-right in edit mode changes the cursor by single character.
5. ✅ arrowing up-down in edit mode moves the cursor to the front or the back of the cells contents
6. ✅ enter moves the focus down one cell into focussed mode
7. ✅ tab moves the focus to the right one cell into focussed mode
8. ✖️ pasting a string will paste the contents in the cursor location
9. ✖️ pasting a series of cells isn't allowed in excel. in google docs it will paste it as a multi-line string.
   • we actually do neither of these - we have the same behaviour as focussed: it pastes into several cells.
10. visually, edit is distinct from focussed mode by:
    a. ✅ having a cursor
    b. ✅ allowing text to highlight
11. ✅ delete deletes the letter
12. ✅ escape reverts the cell back to what the cell's contents originally were and transitions the cell into focussed mode

multi-select

• ✅ shift-arrow-keys brings you into multi-select
• ✅ shift-click brings you into multi-select
• ✅ delete clears the contents of each cell
• ✅ tabbing around cells moves the "active" cell around
• ✅ arrow transitions the cell into focussed, and moves the active cell down
  • ✅ note that the active cell may not necessarily be the first cell, as the user may have tabbed around in multi-select mode first
• ✅ the active cell acts like a focussed cell w.r.t typing and entering
• ✅ deleting will always delete the contents, even if the active cell has moved around

[Marc-Andre-Rivet]

@chriddyp Most of the items in this "epic" have been completed and no further movement has happened for quite some time now. I feel this is partly due to poor discoverability of these issues.

I suggest we open individual issues for the remaining items and close this "epic".

Can you either open issues or list the items that are still relevant? Thanks.