UX Issue: Difficulty Editing Number Cells in Glide Data Grid

[vpsinghg]

Description

When editing a number in a grid cell that uses NumberCell, there's a UX issue where leading zeros are ignored after deleting digits. This makes it difficult for users to maintain the correct formatting and length of numbers during editing.

Example:

Suppose the current value in the cell is 1000023, and I want to change it to 2000023. I delete the leading 1 using backspace, expecting to enter 2, but the input resets to just 23 because all the leading zeros (00000) are ignored. As a result, I lose track of how many zeros were there, making it hard to format the number correctly.

Other examples:

For a value like 5000078, if I delete the 5, it will reset to 78, and I don’t know how many zeros to add after 7.

For 3004005, deleting 3 would result in 4005, again with no indication of the number of zeros that were present.

Use case:

This behavior is problematic in cases where the length and structure of the number are important (e.g., financial values, IDs, etc.). The user needs a way to edit numbers without losing critical formatting, as it's hard to guess how many zeros were originally present, leading to frustration and potential errors in data entry.

Expected Behavior:

While editing, the grid cell should preserve the existing structure of the number (including zeros) until the user finalizes the edit, allowing them to modify only the desired parts of the value.

Current Behavior

https://github.com/user-attachments/assets/b6d6846f-e7bd-4972-a2f5-e46d7a0fda37

Fixed and Expected behavior

https://github.com/user-attachments/assets/7a9ed66c-42f2-46ed-bd22-89b73d410859

[vpsinghg]

@jassmith I would like to fix this. Can you please assign this to me? I have already faced this issue few times and added some hack to avoid this. But I think lot of people would have faced such experience.

[vpsinghg]

@lukasmasuch Can you please review and suggest if any further changes required ?