Table of Contents

TCellAddress.TrySetCellRef Method

Overloads

TCellAddress.TrySetCellRef(String)

Tries to set a cell reference, and returns true if the cell is a correct A1 reference. This is similar to setting CellRef to a string, but it will not raise an exception.

Syntax

Namespace: FlexCel.Core

public Boolean TrySetCellRef(String value)

Parameters

<-> Parameter Type Description
value String String with the cell reference, in A1 format. To use R1C1 notation, see TrySetCellRef(String, TReferenceStyle, Int32, Int32)

Returns

True if value was a correct cell reference, false otherwise.

See also

TCellAddress.TrySetCellRef(String, TReferenceStyle, Int32, Int32)

Tries to set a cell reference, and returns true if the cell is a correct A1 or R1C1 reference.

Syntax

Namespace: FlexCel.Core

public Boolean TrySetCellRef(String value, TReferenceStyle referenceStyle, Int32 cellRow, Int32 cellCol)

Parameters

<-> Parameter Type Description
value String String with the cell reference, in A1 or R1C1 format.
referenceStyle TReferenceStyle Style the reference is in (A1 or R1C1).
cellRow Int32 Row where the cell is. This is only used for R1C1 relative references, to know where the cell is. For example, the reference R[1]C[1] when cellRow is 5 will reference row 6. A1 references or absolute R1C1 references ignore this parameter.
cellCol Int32 Column where the cell is. This is only used for R1C1 relative references, to know where the cell is. For example, the reference R[1]C[1] when cellCol is 5 will reference column 6. A1 references or absolute R1C1 references ignore this parameter.

Returns

True if value was a correct cell reference, false otherwise.

See also