Row Selection and Cell Selection

[jameskerr]

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.

[philrz]

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

[philrz]

I spotted a small problem with highlighting that I've reproduced below with Zui commit 0539d61. Rather than open a separate issue, I'm grafting it on here as part of our "selection wishlist".

In most tools users are accustomed to, when they click-&-drag to start highlighting and pull downward such that it starts scrolling to extend what's highlighted, the "off-screen" portion starting from where they first click-&-dragged is presumed to still be part of what's highlighted and hence should make it into their paste buffer if they select Copy. However, the attached video shows that when I scroll back up before hitting Copy, the highlighted portion has been reduced to only what was visible within the editor panel.

Repro.mp4