Scroll Spread Programatically

Posted by: naranja on 8 September 2017, 12:40 pm EST

  • Posted 8 September 2017, 12:40 pm EST

    Hi Scott,


    I'm new in Spread and using Version 1.0.9. How can I scroll up and down a spread programatically.My spread does not need scroll bars. The codes must be in a button in VB.net. Please help.


     


    Orange

  • Replied 8 September 2017, 12:40 pm EST

    Orange -

    You can use the SetViewportTopRow and SetViewportLeftColumn methods.
  • Replied 8 September 2017, 12:40 pm EST

    Can you give me some example. I'm really new in Spread and can use some examples. Thank you.
  • Replied 8 September 2017, 12:40 pm EST

    Hello,


    If you want to programatically scroll to row 15, you can use code like the following.


       FpSpread1.SetViewPortTopRow(0,15)

Need extra support?

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

Learn More

Forum Channels