Been starting some user testing on my app and I am getting a complaint about how inefficient it is to edit data in a table.
We have a list of line items and the Quantity column is editable. They click to enter the cell, backspace to remove the current value that is there then type the new value. Then they have to click to set the new value and click again to start editing a new cell and backspace to remove the current value and so on.
I would like to just get by with one click - accept the edited value of the previous cell, open the newly selected cell and auto-select the contents of the cell. When you have a few dozen cells to edit, taking two clicks out of each one goes a long way.
Ideas on how to do this?