How to set viewPort top row and left column manually

How to set viewPort top row and left column manually

Posted by: barweprashant91 on 11 October 2018, 8:42 am EST

• 

  barweprashant91

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 October 2018, 8:42 am EST

  . How to set viewPort top row and left column manually I want to do same like as Alt+Page Up and Alt+Page Down Function in Excel sheet

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 12 October 2018, 4:36 am EST

  Hello,

  You can customize the keys behavior with cammandmanager in SpreadJS. You can use setShortcutKey() method to handle navigation in your own way for Alt+PageUp or Alt+PageDown. Here is the code to do that:

  //for page up
  
  spread.commandManager().setShortcutKey(“navigationPageUp”, GC.Spread.Commands.Key.pup, false, false, true, false);

  //for page down
  
  spread.commandManager().setShortcutKey(“navigationPageDown”, GC.Spread.Commands.Key.pdn, false, false, true, false);

  Thanks,
  
  Deepak Sharma