[Feature request] Batch insert
Is your feature request related to a problem? Please describe.
I'm always frustrated when I need to quickly populate multiple selected cells with the same value, but there’s no easy way to do so. Currently, I can delete multiple selected rows by selecting them and pressing Backspace. However, there's no equivalent functionality for inserting a value into multiple selected cells at once.
Describe the solution you'd like
I would like the ability to type a value (e.g., "0"), press Enter, and have all selected cells filled with that value. This would streamline workflows where bulk editing of cells with a single value is needed.
Describe alternatives you've considered
- Copying and pasting the desired value into each cell manually, which is time-consuming and inefficient.
- Using external scripts or plugins to achieve this functionality, which adds unnecessary complexity.
Additional context
Here is a video demonstrating the current behavior, where Backspace deletes selected cells:
The proposed feature would allow users to insert a value into multiple selected cells in a similarly intuitive manner.
At present, we support batch editing by copying a cell -> selecting an area -> pasting. Have any products ever implemented the interaction you proposed?
@tea-artist Yea, I use this feature quite frequently in JetBrains Datagrip
https://www.jetbrains.com/help/datagrip/cells.html#modifying_multiple_cells
https://github.com/user-attachments/assets/7715e847-6deb-4d4e-aa2b-d9136bf235a1
We plan to implement it in this way: A small handle that can be dragged can be filled vertically upward or downward.