get last "row" on screen

Posted by: craigreilly on 15 August 2018, 2:25 am EST

  • Posted 15 August 2018, 2:25 am EST

    Trying to automate a readerboard of sorts.
    The data is in FPSpread.
    There are around 100 rows.
    On the screen initially might be 20 rows... but it might be more or less, depending on how many lines are in each cell.

    I want to be able to determine the last "visible" row - the row that I can see on the screen... and then in 20 seconds, be able to change the view to start with the first non visible row.

    This making any sense?
  • Marked as Answer

    Replied 15 August 2018, 5:03 pm EST


    You can use the FpSpread.GetViewportBottomRow method to get the row index of the last visible row in a sheet as given in documentation link below:-

    Dim topRow As Integer = FpSpread1.GetViewportTopRow(0)
    Dim bottomRow As Integer = FpSpread1.GetViewportBottomRow(0)

    Hope it helps.

Need extra support?

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

Learn More

Forum Channels