[GH #497] Deselection of few cells after selection of a range is not working

Getting help Questions
,
1

Hi, After selecting a range of cells, If we try to unselect few of them (by pressing ctrl and selecting the cells we want to unselect), it is still considering them in the selection. I need to unselect this value.

For example,

  1. Select a range of cells via keypad/mouse (let’s say A1: B5)
  2. Unselect one cell (say B1), by pressing ctrl and selecting B1
  3. Call the hot.getSelected() method and print in console
  4. It returns [[0, 0, 4, 1],
    [0, 1, 0, 1]]
    It considers B1 to be selected twice.

Here is my code;

image
image879×365 43.3 KB

2

Hi @ayse.tptn

Thank you for contacting us. This issue is known to us, and it’s already reported internally. I’ll update you once we start working on it.

3

Thank you for the return. Is there a solution you can suggest for now? How can I deselect the cel?l

4

@ayse.tptn

At the moment there is no workaround for this.

5

Did this feature get delivered

6

Hi @marcelmrottmann,

Thanks for checking back in. I appreciate you following up on this.

At the moment, this feature hasn’t been delivered yet. Unfortunately, there’s still no official API support for deselecting individual cells. The only available option remains deselecting a full range at once.

I know this isn’t the answer you were hoping for, and I understand how limiting this can be depending on your use case. The feedback is noted, though, and requests like yours help us prioritize future improvements.

If you’re open to it, I’d be happy to better understand how you’re trying to use this functionality. That context can be really helpful when discussing potential enhancements internally.

Thanks again for reaching out, and please let me know if there’s anything else I can help with in the meantime.