Dash DataTable - Cell Editing

Hello Plotly Community,

I’m currently working on a project using Dash DataTable and we are experiencing some challenges related to cell editing.

Our aim is to provide an intuitive data entry experience for our users, however, we’ve found some limitations:

  1. In Dash DataTable, a user must double-click a cell to edit its content, which highlights all the existing content. If a user single clicks and starts typing, it erases the full cell content. This behavior can be counterintuitive for users accustomed to single-click cell editing.

  2. Dash DataTable doesn’t allow placing the cursor at a specific location within the cell to edit a portion of the content. A user must overwrite the entire content or use arrow keys to navigate within the highlighted content.

  3. Changes are not saved unless the user hits Enter after editing. If the focus is lost before hitting Enter, the changes are lost. This could lead to data loss if a user is not careful.

Our ideal solution would be for Dash DataTable to support editing – single click to place the cursor at a specific location in the cell, intuitive saving of changes, and support for undo operations.

I’m reaching out to see if anyone has encountered a similar issue and found a workaround, or any advice or information would be greatly appreciated.

Thank you in advance!

Best Regards,
AJ

You can use the editable mode in AntdTable, very nice experience:

https://fac.feffery.tech/AntdTable-basic#可编辑单元格

1 Like

hi @ajith.suyambujeya
:wave: welcome to the community.
I’m not sure how much of the 3 limitations can be overcome with the DataTable.

Have you considered using Dash Ag Grid? For example, changes should be registered even if focus is lot. You can see more on the editing page. Also, regarding point #1, in Dash Ag Grid, if a user clicks once on a cell you can start editing. But I’m not completely sure what exact limitation you’re trying to overcome with bullet point #1.

1 Like

Hi @adamschroeder

Thank you so much for your suggestion! Dash Ag-Grid seems to be an interesting alternative and I’m excited to explore it further. I appreciate your guidance and will certainly give it a try.

I will update you as soon as I have more insights from my testing. Your help is greatly appreciated!

best,
AJ

1 Like

Hi @CNFeffery,

Thank you so much for the suggestion. I will try the native dash-ag-grid solution, which seems similar to what you shared with me. I’ll explore this option and update you on the status soon.

uh-huh, in AntdTable editable mode, you don’t need to double-click the cell to trigger editing mode.