Feature Request: Edit Column for all rows in data

[TeeLusk]

Problem

When pulling a result set or browsing data in the TablePro data grid, I frequently need to set a specific column's value across all rows to the same value. Currently, there's no way to do this from within the data grid interface itself, which makes even simple bulk operations tedious and error-prone.

Proposed solution

Extend the data grid to support a "Fill Column" or "Edit Column" action that allows setting all visible cells in a selected column to a specific value. Some potential implementation approaches:

1. Right-click context menu - Add a "Fill Column" option to the column header context menu that opens a dialog to enter the value.

2. Column header button - Add a small action button/icon in the column header (near the sort or filter controls) that triggers a fill dialog.

3. Keyboard shortcut - Support a shortcut (e.g., select a cell in the column, then Ctrl+Shift+F) to open the fill dialog.

The fill dialog should:

• Let the user enter the desired value
• Show a preview of what will change (e.g., "This will update 150 rows")
• Include a confirmation step before executing

This would be similar to Excel's "Fill" functionality but scoped to the current result set or view in TablePro.

Alternatives considered

• Multi-Cell Paste (v0.37.0): You can copy a value and paste it to multiple selected cells. This works but requires manually selecting every cell first, which is tedious for large result sets.
• SQL UPDATE Query: Writing an UPDATE statement in the SQL editor works fine, but requires switching context from the data grid to the SQL editor, typing the query, and running it. Not as intuitive for quick inline edits.
• Third-party tools: Exporting to CSV, editing in Excel (using fill-down), and re-importing is cumbersome and error-prone for simple value updates.

Related database type

N/A / General