Flexsheet Multiselect nonconsecutive cells

Flexsheet Multiselect nonconsecutive cells

Posted by: razninuk on 2 May 2019, 5:24 pm EST

• 

  razninuk

  • Post Options:
  • Link
    Copy

  Posted 2 May 2019, 5:24 pm EST

  Hi,

  The multi-selection using Ctr key to select nonconsecutive cells does`nt seem to work in Flexsheet as is in Microsoft excel.

  Thanks,
  
  Raznin

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 6 May 2019, 3:07 am EST

  Hello,

  The selectionMode property of Flexsheet can be used to select multiple cells using the Ctrl key by setting its value to ‘CellRange’. Please refer to the sample below:

  https://jsfiddle.net/6fawxLsc/

  API Reference:

  SelectionMode:
  
  https://www.grapecity.com/wijmo/api/classes/wijmo_grid_sheet.flexsheet.html#selectionmode

• 

  razninuk

  • Post Options:
  • Link
    Copy

  Posted 6 May 2019, 4:59 pm EST

  Hi Abhishek,

  Setting selectionMode to cellRange does not seem to work.
  
  I have the sum,avg,count shown on the bottom bar as in excel based on the user selection.So the user should be able to Ctrl+click and multi-select non-contiguous cells and see the correct calculation.Right now Flexsheet is allowing only the most recent selection.Let me know if I am missing something.

  Thanks,
  
  Raznin

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 7 May 2019, 4:26 am EST

  Hello,

  In order to get all of the selected cells, you could use the selectionRanges property of Sheet class. Please refer to the sample below which shows how to show sum and avg of the selected cells:

  https://jsfiddle.net/4exq9bcg/