As a user, I’d like to have a grid view/editor, so that I can:
- Navigate and quickly edit cells, just like Excel. It may not be as power as Excel. All that I want is to use keyboard to do this, without any mouse click, to speed up my work.
- Copy range of values (without formula) to paste to some where else (Teams chat, Excel, Word, Google Docs,…)
- Paste range of values into the grid, overwrite the existing items. The sources are Excel, web table, Word table, CSV,… Current pasting feature is only inserting new items.
Validation:
- If value is not matched with column type, the value will not be pasted for that cell, with some highlighting (like red flash).