Determines whether this cell range is valid in the specified sheet and whether to treat as a span.

Syntax

Visual Basic (Declaration)
Public Overloads Function IsValidRange( _ ByVal sheetView As SheetView, _ ByVal isSpan As Boolean _ ) As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As CellRange Dim sheetView As SheetView Dim isSpan As Boolean Dim value As Boolean value = instance.IsValidRange(sheetView, isSpan)

C#
public bool IsValidRange( SheetView sheetView, bool isSpan )

Parameters

sheetView: SheetView object with the sheet
isSpan: Whether to treat the cell range as span (or else selection)

Return Value

Boolean: true if range is valid; false otherwise

Remarks

If the isSpan parameter is true, the component treats this cell range as a span (entire rows or columns or entire sheet not allowed). If it is false, the component treats this cell range as a selection (entire rows or columns or entire sheet allowed).

Example

This example colors the cells if the range is valid.

C#	Copy Code
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, true); if (b) { fpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Red; }

Copy Code

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, true); 
if (b) { 
     fpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Red; 
}

Visual Basic	Copy Code
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, True) If b Then FpSpread1.ActiveSheet.Cells(cr.Row, cr.Column, cr.RowCount - 1, cr.ColumnCount - 1).BackColor = Color.Red End If

Visual Basic

Copy Code

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, True)
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2