azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

Cannot select multiple cells by holding Shift key

Open peflorencio opened this issue 6 years ago • 9 comments

  • Azure Data Studio Version: 1.0.0

Steps to Reproduce:

  1. Run any query that returns multiple columns or rows.
  2. Click on a cell of the Query Results
  3. Hold Shift and click on another cell

Expected Behavior: The cells in the range of the first and the last cell clicked should be selected

Actual Behavior: Only the last cell clicked is selected

peflorencio avatar Oct 01 '18 10:10 peflorencio

I was just getting ready to log a duplicate of this bug.

kburtram avatar Jun 05 '19 00:06 kburtram

I was just about to file an issue for this - ctrl+click also doesn't seem to allow multi select - in this case obviously without taking the range between.

I'm not sure how that nicely this would play with the behaviour of opening json strings etc in a new tab when the cell is clicked (as documented in #6295) - although you could probably have shift/ctrl+click override the open in new tab behaviour and simply select the cell which would maybe solve both issues?

Kirlac avatar Jul 10 '19 04:07 Kirlac

This appears to be working on current builds. Please let us know if you're still impacted by this issue.

kburtram avatar Aug 17 '21 19:08 kburtram

I just tried this on 1.36.1 and this definitely not working. I thought it was working before...

jchandracoupa avatar May 16 '22 00:05 jchandracoupa

@jchandracoupa holding down the Ctrl key while clicking on different regions in the grid should allow selecting multiple regions. I just checked and this is working for me on 1.36.1. Is that not working for you?

kburtram avatar May 16 '22 02:05 kburtram

Ah, my bad. I used the Shift key which I thought should work by clicking the first cell and clicking the last cell that I want and I feel that it should select all in between. But you are correct, Ctrl and dragging or Ctrl and clicking a bunch of things will work. Ctrl + Shift + arrow key to select a region of rows and columns doesn't seem to work tho. A bit of an accessibility issue?

jchandracoupa avatar May 16 '22 02:05 jchandracoupa

@jchandracoupa you should be able to click on a cell, then hold down Shift + arrow key to select a region of cells. Please let us know if that isn't working. I'll chat with @alanrenmsft to review the various cell selection options to ensure they are consistent/intuitive.

kburtram avatar May 16 '22 05:05 kburtram

I can confirm that this is still an issue in ADS Version 1.37.0. Shift clicking a range continues to not work. Using the method of clicking a cell, then shift+arrow keys is a bit of a workaround though annoying. I believe this used to work in the past as well, curious what type of change would regress this behavior. With regards to consistency, the notion of clicking then shift-clicking to select multiple entities within the range is a UX that's as old as my computing experience with Windows.

kchungmsft avatar Jul 06 '22 00:07 kchungmsft

I am using ADS 1.38.0: Holding shift and using the arrow keys correctly selects multiple cells Ctrl+Click correctly adds each clicked item to the selection Shift+Click to multi select is still not working.

nicksoan avatar Sep 08 '22 11:09 nicksoan

The fix will be in the November release.

I've added support for SHIFT key, here is a summary of the selection behaviors NOTE: The multi-selection key is CTRL for Windows/Linux, CMD key for macOS.

Scenarios

  1. Select all - click the header of row number column select-all

  2. Select a single column - click the column header select-single-column

  3. Select columns individually - click the header of the columns with CTRL/CMD key pressed select-multiple-columns-ctrl

  4. Select columns in a range - select the start column (a cell or entire column), then select the end column header with SHIFT key pressed select-multiple-columns-shift

  5. Select a row - click the row number cell single-row-selection

  6. Select muliple rows individually - click the row number cells with CTRL/CMD key pressed multi-row-selection-ctrl

  7. Select rows in a range - select the start row (a cell or the row header), then select the end row header with SHIFT key pressed multi-row-selection-shift

  8. Select cells in a range with mouse - press and hold the select button in the start cell, then move the cursor to the end cell and release the button cell-range-selection-mouse

  9. Select cells in a range with keyboard only - select the start cell, press and hold SHIFT key, then use the arrow keys to select the range cell-range-selection-keyboard-only

  10. Select cells in a range with mouse and SHIFT key - select the start cell, press and hold SHIFT key, then click the end cell cell-range-selection-mouse-shift

  11. Select multiple ranges - Select a range with the options listed above and then with CTRL/CMD pressed and keep adding new selections. select-multiple-ranges

alanrenmsft avatar Oct 15 '22 02:10 alanrenmsft