Set default focus cell for spread?

Posted by: tr4788 on 8 September 2017, 2:06 pm EST

  • Posted 8 September 2017, 2:06 pm EST

    Hello everyone, i'm newbie.


     When load spread, my spread alway focus in first cell of first row. I want to set focus to the second cell of first row but i don't want to use SetActiveCell after spread load.


    Please help me? thank you very much and sorry about my bad english :D

  • Replied 8 September 2017, 2:06 pm EST

    Hello,

    You may use the ActiveColumnIndex & ActiveRowIndex properties to set the focus on desired cell. As per your requirement, you may set the mentioned properties as follows:

     FpSpread1.ActiveSheet.ActiveColumnIndex = 0
     FpSpread1.ActiveSheet.ActiveRowIndex = 1

    Thanks

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels