philrz
commented
1 year ago A community user made the following feature request in a Slack thread, and it touches on behaviors related to Google Sheets & Excel. We could look to address this at the same time we're taking up this issue, or spawn it into its own issue. In their own words:
The new table view is AWESOME - but just to be a nuisance - is there a way to change the copy+paste behavior? For eg it would be neat if a copy /paste to CSV was possible - right now it just seems to copy all row data into a single column specifically I'm finding I do alot of copy/ pasting into excel - so in my ideal world if I copy out of a grid someplace those should just fall into corresponding rows/ columns in excel - I think dbeaver had an explicit copy results to CSV button which was handy right now I just export then re-import - works great, but one-shot copy would save some clicks lol
The table view and the inspector lack the ability to select rows and columns.
Add this feature back. With the ability to select certain cells.
There should also be a menu shown when right-clicking on selected cells to allow operations on all highlighted cells.
And we'll want to adjust the context menu depending on the selection.
The behavior in Google Workspace tools (Sheets, Docs, etc.) has been cited as a model for ideal selection behavior since it should be familiar to most users.