Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.Model Namespace / CellRange Class / IsValidRange Method / IsValidRange(SheetView) Method
SheetView object with the sheet
Example


In This Topic
    IsValidRange(SheetView) Method
    In This Topic
    Determines whether this cell range is valid in the specified sheet.
    Syntax
    'Declaration
     
    Public Overloads Function IsValidRange( _
       ByVal sheetView As SheetView _
    ) As Boolean
    'Usage
     
    Dim instance As CellRange
    Dim sheetView As SheetView
    Dim value As Boolean
     
    value = instance.IsValidRange(sheetView)
    public bool IsValidRange( 
       SheetView sheetView
    )

    Parameters

    sheetView
    SheetView object with the sheet

    Return Value

    Boolean: true if range is valid; false otherwise
    Example
    This example colors the cells if the range is valid.
    FarPoint.Win.Spread.Model.CellRange cr = new FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3); 
    fpSpread1.ActiveSheet.Models.Span.Add(cr.Row, cr.Column, cr.RowCount, cr.ColumnCount); 
    bool b = cr.IsValidRange(fpSpread1.ActiveSheet); 
    if (b) { 
         fpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Red; 
    }
    
    Dim cr As New FarPoint.Win.Spread.Model.CellRange(0, 0, 3, 3)
    FpSpread1.ActiveSheet.Models.Span.Add(cr.Row, cr.Column, cr.RowCount, cr.ColumnCount)
    Dim b As Boolean = cr.IsValidRange(FpSpread1.ActiveSheet)
    If b Then
         FpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Red
    End If
    See Also