TCellAddress.TrySetCellRef Method
Overloads
- TCellAddress.TrySetCellRef(string)
- TCellAddress.TrySetCellRef(string, TReferenceStyle, Integer, Integer)
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
Unit: FlexCel.Core
function TCellAddress.TrySetCellRef(const value: string): Boolean; overload;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | value | string | String with the cell reference, in A1 format. To use R1C1 notation, see TrySetCellRef(string, TReferenceStyle, Integer, Integer) |
Returns
True if value was a correct cell reference, false otherwise.
See also
TCellAddress.TrySetCellRef(string, TReferenceStyle, Integer, Integer)
Tries to set a cell reference, and returns true if the cell is a correct A1 or R1C1 reference.
Syntax
Unit: FlexCel.Core
function TCellAddress.TrySetCellRef(const value: string; const referenceStyle: TReferenceStyle; const cellRow: Integer; const cellCol: Integer): Boolean; overload;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | value | string | String with the cell reference, in A1 or R1C1 format. |
const | referenceStyle | TReferenceStyle | Style the reference is in (A1 or R1C1). |
const | cellRow | Integer | 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. |
const | cellCol | Integer | 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.