Execute select all programmatically

Execute select all programmatically

Posted by: jerome on 2 June 2020, 3:34 pm EST

• 

  jerome

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 June 2020, 3:34 pm EST - Updated 3 October 2022, 10:20 am EST

  Hello , how can i trigger the selectAll command illustrated on the screenshot ?

  

  i try to use this script but no luck on my end

  
  selectAllSheet = () => {
  	let commandManager = this.spreadInstance.commandManager();
  	commandManager.execute({
  		cmd: "selectAllCommand",
  		sheetName: this.spreadInstance.getActiveSheet().name()
  	});
  }
  
  

  thanks!

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 3 June 2020, 8:58 am EST

  Hi,

  SJS does not have any specific any Command for this functionality but you could create your own customCommand that perform this functionality.
  
  You may use addSelection method to select some or all cells. Please refer to the following code snippet and sample which demonstrates the same:

  sheet.clearSelection();
  sheet.addSelection(0, 0, sheet.getRowCount(), sheet.getColumnCount());
  

  Sample: https://codesandbox.io/s/nice-hertz-2p3bc?file=/src/index.js

  Custom Commands demo: https://www.grapecity.com/spreadjs/demos/features/worksheet/actions/custom-action#

  API Reference:
  
  • clearSelection: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~clearSelection.html
  
  • addSelection: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~addSelection.html

  Regards

• 

  jerome

  • Post Options:
  • Link
    Copy

  Posted 3 June 2020, 9:38 am EST

  Thanks! it works