Get last "row" on screen

Get last "row" on screen

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

• 

  craigreilly

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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?

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 15 August 2018, 5:03 pm EST

  Hello,

  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:-

  http://help.grapecity.com/spread/SpreadNet11/WF/webframe.html#FarPoint.Win.Spread~FarPoint.Win.Spread.FpSpread~GetViewportBottomRow.html

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

  Hope it helps.

  Thanks,
  
  Reeva