[SOLVED] Editing existing string in DataTable, excel style

I can’t seem to edit an existing string in a DataTable, only blow away the datatable contents. How can I edit just the substring in a DataTable?

EDIT: It appears this is possible by double clicking THEN moving the arrow keys. Possible, but unlike any spreadsheet editor I’ve seen. Requires hitting enter to save changes, if you lose focus, they’re gone. Doesn’t seem possible to only edit the data table with a keyboard. There is no undo via CTRL+Z either.

Seems like data entry “excel style” is not a use case that the DataTable will support.

Versions:
dash==2.0.0
dash-table==5.0.0

Based on a GitHub issue this used to be possible. Any words on a fix? It seems like editing cells is a core use case of software like Dash but the UX makes it unusable if you want to edit existing cell values.

My question is basically the same as these:

Similar issues raised on GitHub: