IsValidRange(SheetView) Method

Determines whether this cell range is valid in the specified sheet.

Syntax

Visual Basic
C#

'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; 
}

Visual Basic

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

Requirements

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

Reference

CellRange Class
CellRange Members
Overload List