Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetCellReferenceOptions Type

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

#Declaration

Delphi
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.

See Also