TCellAddress.TrySetCellRef Method
Overloads
- TCellAddress.TrySetCellRef(String)
- TCellAddress.TrySetCellRef(String, TReferenceStyle, Int32, Int32)
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.