When clicking on the row will get all the value?

When clicking on the row will get all the value?

Posted by: nguyentuyen1322 on 22 March 2022, 5:27 am EST

• 

  nguyentuyen1322

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 March 2022, 5:27 am EST

  Hi Teams,

  i have a problem that when i click on any row i want to get all the value of that row, Is there a solution to this problem?

  How can i do it ?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 23 March 2022, 3:31 am EST

  Hi James,

  You can use the CellClick event to get the clicked row and use the getArray method to get all the values of the clicked row.

  Please refer to the following sample that I have created for you: https://jscodemine.grapecity.com/share/P-QoqbmDSk60H6nR18Vdlg/

  CellClick Event: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Events~CellClick_EV.html

  getArray method: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~getArray.html

  Please let us know if you face any further problem.

  Regards
  
  Ankit

• 

  nguyentuyen1322

  • Post Options:
  • Link
    Copy

  Posted 23 March 2022, 4:10 am EST

  Hi Teams,

  • When I click on another row, I want to save the previously selected rows, what should I do? Is there a solution?

  Thanks

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 24 March 2022, 3:47 am EST

  Hi James,

  You can use the SelectionChangedEvent to get the previously selected rows.

  Please refer to the following sample that I have created for you: https://jscodemine.grapecity.com/share/phfDCraUuEGALMAFi0icdg/

  SelectionChanged Event: https://www.grapecity.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Events~SelectionChanged_EV.html

  Please let us know if you face any further issues.

  Regards
  
  Ankit