Ctrl-clicking a cell unselects all previously-selected cells
started a topic
over 6 years ago
[This topic is migrated from our old forums. The original author name has been removed]
- A table with at least 1 column exists
- Table contains at least 3 records
- Go to Table > Data tab
- Under 1 column, control-click 3 different cells
- Control-click one of the selected cells
- Control-clicked cell is unselected
- All cells are unselected
NOTE: This is applicable for cells in a single column only
over 6 years ago
[This reply is migrated from our old forums.]
Re: Ctrl-clicking a cell unselects all previously-selected cells
This behavior is due to a limitation in the Java UI framework DbVisualizer use. Here is the response from Oracle on this subject:
"When the set of cells are first CTRL-clicked on, the table marks them as selected by storing that the row and column for the clicked cells are selected. When CTRL-clicking again on the selected cell, this marks the row and column of that cell as being unselected. As a result, this unselects any other rows in the unselected column and any other columns in the unselected row."
So basically, when there are a set of selected cells and you ctrl+click one of them, all cells in that row and column are de-selected. If you now ctrl+click another unselected cell in the same column all previously selected cells now reappear selected.
To even better show how it works, select a block of cells spanning lets say 4 rows x 3 columns. Now ctrl-click the 3:rd column in the 4:row and you will see how the selection strategy works as it then deselects all cells that are in the intersection of the cell being clicked.