TdxSpreadSheetCellReferenceOptions Type

A set of reference attributes applied to a cell reference used in formula expressions.

Declaration

TdxSpreadSheetCellReferenceOptions = set of TdxSpreadSheetCellReferenceOption;

Referenced Class

Type
TdxSpreadSheetCellReferenceOption

Remarks

Different combinations of cell reference attributes in a TdxSpreadSheetCellReferenceOptions set result in different cell reference variants:

Set of TdxSpreadSheetCellReferenceOption Attributes	Reference Type	Description	A1 Reference Example	R1C1 Reference Example
croAbsoluteColumn, croAbsoluteRow	Absolute Reference	The column and row numbers do not change when an expression with the reference is copied to another cell.	=$A$2	=R2C1
croAbsoluteRow	Partially Relative Reference	The row number remains the same when an expression with the reference is copied to another cell. The absolute horizontal offset between the source and destination cells is added to the column number in the reference.	=A$2	=R[2]C1
croAbsoluteColumn	Partially Relative Reference	The column number remains the same when an expression with the reference is copied to another cell. The absolute vertical offset between the source and destination cells is added to the row number in the reference.	=$A2	=R2C[1]
-	Relative Reference	Both the horizontal and vertical absolute offsets between the source and destination cells are added to the column and row numbers in the copied reference, respectively.	=A2	=R[2]C[1]

If the croSheetName value is added to a TdxSpreadSheetCellReferenceOptions set, the reference is extended with a name of the worksheet in which the referenced cell is located. Referring to a specific worksheet within the cell reference has the same syntax for both the A1 and R1C1 reference styles. The sheet name precedes the actual cell reference and is separated from it by an exclamation mark:

=Sheet!$A$2

The TdxSpreadSheetCellReferenceOptions type is referenced by the AOptions parameter of the GetReference function provided by a cell object.