To Set the Focus to Particular cell in Spread and Customize Tab Order

To Set the Focus to Particular cell in Spread and Customize Tab Order

Posted by: gopi1987 on 8 September 2017, 2:54 pm EST

• 

  gopi1987

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:54 pm EST

   Hi,

   

  I am new to Developing Winodws Application in vb.net, we use Farpoint Spread tool in our application.    

   

  Now the Problem is

  1.     When I press tab Key the focus goes on each cell in a row at last cell the focus goes to the first cell of next row But I need the focus goes to each cell in column wise

   

  2.   To set the focus to a Particular Cell in spread when I Click/press a button in windows forms that means set activecell to that particular cell.  (I  write the code to set focus to spread only  but I cant set focus to a particular cell)

  If Anyone Know plz reply

  Thanks and Regards

• 

  manpreetkaur

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:54 pm EST

  Hello,

  1. I would like you to know that you can change the input maps to customize the keyboard processing on Spread, even the help file contains a topic "Managing Keyboard Interaction" that explains the details of the same. Please refer to the following link for further details:

                  http://www.clubfarpoint.com/FarPointSupportSite/Modules/Docs/SpreadWin5Help/spwin-maps-defaultnew.html

  And here is the code to customize the tab key to move the focus column wise:

              FarPoint.Win.Spread.InputMap inputmap1;
  
              inputmap1 = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused);
  
              // Map the Enter key.
  
              inputmap1.Put(new FarPoint.Win.Spread.Keystroke(Keys.Tab, Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextRowWrap);

  2. You can use the SetActiveCell method to set focus to a particular cell in Spread. Please refer to the following link for further clarification about the method:

                 http://www.clubfarpoint.com/FarPointSupportSite/Modules/Docs/SpreadWin5Help/FarPOint.Win.Spread~FarPoint.Win.Spread.SheetView~SetActiveCell%28Int32,Int32%29.html

  Hope it will help you. Please let me know if you have any queries further.

  Thanks,

  Manpreet Kaur

   

• 

  rganderson

  • Post Options:
  • Link
    Copy

  Posted 26 July 2018, 1:51 pm EST

  This link doesn’t work. It sends me to another web page outside of this .
  
  http://www.clubfarpoint.com/FarPointSupportSite/Modules/Docs/SpreadWin5Help/FarPOint.Win.Spread~FarPoint.Win.Spread.SheetView~SetActiveCell(Int32,Int32).html