How to copy entire row after selecting Shift+spacebar

How to copy entire row after selecting Shift+spacebar

Posted by: varad9525 on 1 December 2017, 2:33 am EST

• 

  varad9525

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 December 2017, 2:33 am EST

  i am Unable to copy entire row using ctrl+c after selecting entire row using shift+space action in data grid.i am doing this in javascript.

  
   if (e.shiftKey && $scope.keyCode == 32){
  	    	
  	    	e.preventDefault();
  	    		filterButtonClicked("selectRow");
  
  
        case "selectRow":
          	selectSingleRow(sheet)
  
  
      function selectSingleRow(sheet) {
  	var tagSheet = spread.getActiveSheet();
  	var rowCount = sheet.getRowCount();
  	var colCount = sheet.getColumnCount();
  	var activeRow = tagSheet.getActiveRowIndex();
  	var activeColumn = tagSheet.getActiveColumnIndex();
  	tagSheet.setSelection(parseInt(activeRow),0,1,parseInt(colCount));
          tagSheet.isPaintSuspended(false);
  	tagSheet.repaint();
  
  	
  	}
  
  
  
  

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 4 December 2017, 8:44 am EST

  Hello,

  You can use the code as follows to select the whole row using shift+space:

  
   spread.commandManager().register('myCmd',
                  function select() { 
    		   
                      var colCount = worksheet.getColumnCount();
                      var activeRow = worksheet.getActiveRowIndex();                
                      worksheet.setSelection(activeRow, 0, 1, colCount);                  
                  }
              );
              spread.commandManager().setShortcutKey('myCmd', GC.Spread.Commands.Key.space, false, true, false, false);
  
  
  

  You can handle the event to cancel the edit mode.

  Thanks,
  
  Deepak Sharma