Spread Windows Forms 9.0 Product Documentation
IsCellInView Method
Example 


Index of viewport row
Index of viewport column
Index of row in that viewport
Index of column in that viewport
Returns whether the cell at the specified location is visible in the specified view.
Syntax
'Declaration
 
Public Function IsCellInView( _
   ByVal rowViewportIndex As Integer, _
   ByVal columnViewportIndex As Integer, _
   ByVal cellRowIndex As Integer, _
   ByVal cellColumnIndex As Integer _
) As Boolean
'Usage
 
Dim instance As FpSpread
Dim rowViewportIndex As Integer
Dim columnViewportIndex As Integer
Dim cellRowIndex As Integer
Dim cellColumnIndex As Integer
Dim value As Boolean
 
value = instance.IsCellInView(rowViewportIndex, columnViewportIndex, cellRowIndex, cellColumnIndex)
public bool IsCellInView( 
   int rowViewportIndex,
   int columnViewportIndex,
   int cellRowIndex,
   int cellColumnIndex
)

Parameters

rowViewportIndex
Index of viewport row
columnViewportIndex
Index of viewport column
cellRowIndex
Index of row in that viewport
cellColumnIndex
Index of column in that viewport

Return Value

true if the cell with specified indexes is visible; false otherwise
Example
This example brings into view the specified cell.
bool b;
b = fpSpread1.IsCellInView(0, 0, 20, 4);
if (!b) 
{
      fpSpread1.ShowCell(0, 0, 20, 4, FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center);
}
Dim b As Boolean
b = fpSpread1.IsCellInView(0, 0, 20, 4)
If Not b Then
    fpSpread1.ShowCell(0, 0, 20, 4, FarPoint.Win.Spread.VerticalPosition.Center, FarPoint.Win.Spread.HorizontalPosition.Center)
End If
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FpSpread Class
FpSpread Members

 

 


Copyright © GrapeCity, inc. All rights reserved.