Transform SQL Tables into Spreadsheets

This update introduces powerful new features to the table functionality, including multi-cell selection, copying, pasting, deletion, and row duplication. These enhancements aim to provide a more intuitive, spreadsheet-like experience for data manipulation within Budibase.

New Features:

• Multi-cell Selection: Select multiple cells using click-and-drag, shift+click, or arrow keys with shift.
• Multi-cell Copy & Paste: Copy and paste multiple cells (max 50 rows, unlimited columns) using ctrl+c/cmd+c/v or by right-clicking “copy/paste” in the context menu.
• Multi-cell Deletion: Delete multiple cells at once (max 50 rows, unlimited columns) using delete, backspace, or by choosing the right-click menu option.
• Multi-row Duplication: If you have multiple rows selected (which you can now do by holding shift and selecting another row), then you'll get a new option in the context menu to duplicate all those rows.

Enhancements:

• Progress Indicators: Real-time bar for all multi-cell operations, offering insight into the expected duration of the process.
• Error Handling: Graceful error handling on a per-row basis, with detailed notifications on successes and failures.
• Code Refactoring: Improved performance, reduced redundant updates, and enhanced column handling logic.
• Visual Improvements: Fixed pixel inconsistencies and gaps and improved the handling of long field names and text overflow in settings popovers.

Fixes:

• Resolved issues with long field names in settings popovers.
• Addressed text overflow problems in settings popovers.