Search and scroll.

Posted by: hpadmasola1 on 8 September 2017, 2:18 pm EST

  • Posted 8 September 2017, 2:18 pm EST

    I am doing a search in the Spread control and making the row I searched for as activerow through code. This works fine. If I searched for example row 50, that row is currently not visible. I would have to scroll down to that row to see it. How do I make it scroll to that row automatically ? Iam able to select it using activerowIndex but I also need to scroll to it automatically. Any help is appreciated.


     Harish

  • Replied 8 September 2017, 2:18 pm EST

    Hello Harish,

    You may use Spread's ShowActiveCell( ) method after making the searched cell active. In order to make a cell active you may use SetActiveCell( ) method.

    e.g.

                fpSpread1.ActiveSheet.SetActiveCell(0, 18);
                fpSpread1.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center); 

     

    I hope it will help you.

    Thanks,

     

Need extra support?

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

Learn More

Forum Channels