sqlitebrowser
[Feature]: Cursor key handling of selected row
Describe the new feature
If a complete row is selected then the keys down/up/page down/page up/Home/End should set the selection to the appropriate row. Together with Shift the number of selected rows should be increased. In the moment the selection is set to a single cell.
Does this feature exist in another product or project? Please provide a link
No response
Do you have a screenshot? Please add screenshots to help explain your idea.
No response
That behaviour doesn't seem very standard. I'd suggest you to get used to these shortcuts, inspired by spreadsheets:
- Ctrl + Space selects the entire columns of the currently selected cells.
- Shift + Space selects the entire rows of the currently selected cells.
I've added them to the wiki, because they were missing.
For the sake of completeness:
I agree that the behavior described in the first sentence of the original post is not standard. However, the behavior described by the second sentence is more common than what is implemented in DB4S: i.e. if an entire row (or column) is already selected, in many other apps, Shift+{Arrow} extends the entire row (or column) in the direction of the arrow key (see the screencast below).
Of course, the availability of Ctrl+{Space} and Shift+{Space} shortcuts in DB4S is a life-saver: with a single extra keystroke, the desired selection is achieved.
https://github.com/sqlitebrowser/sqlitebrowser/assets/1661549/ce7326f9-54e4-4399-99ff-014335e1d422
Notice that dBeaver works similar to DB4S (maybe this is a Qt artifact), without the mitigating row/column selection shortcut!
Ctrl+Space or Shift+Space has no effect if a single cell is select (Windows 10, Swiss German keyboard). I always have to use 'Select column' in the column title menu.
Notice that dBeaver works similar to DB4S (maybe this is a Qt artifact), without the mitigating row/column selection shortcut!
Only the keyboard shortcuts for select row and colum are ours, everything else is standard Qt behaviour.
There's a workaround for rows using that Qt behaviour: Home Shift+ End Shift+Down or Up. For columns, I didn't find a similar way.
Ctrl+Space or Shift+Space has no effect if a single cell is select (Windows 10, Swiss German keyboard). I always have to use 'Select column' in the column title menu.
Strange... What version is that? Does it say Control+Space next to "Select column"?
Strange... What version is that? Does it say Control+Space next to "Select column"? Yes.
DB Browser for SQLite Version 3.13.99 (Mar 6 2024) Last commit hash when built: 80e6f28
Built for x86_64-little_endian-llp64, running on x86_64 Qt Version 5.15.2 SQLite Version 3.45.1.