Spread Windows Forms 7.0 Product Documentation
TryParse Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > CellRange Class : TryParse Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

s: String to be parsed

result: Cell range represented by the string. If the return value is false then result is set to null.

Converts a string to a cell range.

Syntax

Visual Basic (Declaration)
Public Shared Function TryParse( _ ByVal s As String, _ ByRef result As CellRange _ ) As Boolean

Visual Basic (Usage)	Copy Code
Dim s As String Dim result As CellRange Dim value As Boolean value = CellRange.TryParse(s, result)

C#
public static bool TryParse( string s, out CellRange result )

Parameters

s: String to be parsed
result: Cell range represented by the string. If the return value is false then result is set to null.

Return Value

true if the string is converted successfully; false otherwise

The result parameter returns the result of parsing the string.

Remarks

The text passed to the TryParse method must contain the cell name(s) as a column name (as one or more letters) following by the row number (as one or more digits). The row number is 1-based.

Example

This example returns the result.

C#	Copy Code
bool result; FarPoint.Win.Spread.Model.CellRange range; result = FarPoint.Win.Spread.Model.CellRange.TryParse("B3", out range); textBox1.Text = result.ToString();

Visual Basic	Copy Code
Dim trange As FarPoint.Win.Spread.Model.CellRange Dim result As Boolean result = FarPoint.Win.Spread.Model.CellRange.TryParse("B1", trange) TextBox1.Text = result

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