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

TdxSpreadSheetCellReferenceOption Enum

Enumerates attributes that can be applied to a cell reference used in formula expressions.

#Declaration

Delphi
TdxSpreadSheetCellReferenceOption = (
    croAbsoluteColumn,
    croAbsoluteRow,
    croSheetName
);

#Members

Name
croAbsoluteColumn
croAbsoluteRow
croSheetName

#Remarks

Options include:

Value

Description

A1 Reference Example

R1C1 Reference Example

croAbsoluteColumn

The reference contains the absolute column position. The column number in the reference does not change when an expression is copied to another cell.

$A

C1

croAbsoluteRow

The reference contains the absolute row position. The row number in the reference does not change when an expression is copied to another cell.

$2

R2

croSheetName

The reference contains the worksheet name in which the referred cell is located. You can use this attribute in order to address a cell located in another worksheet.

Sheet1!

Sheet1!

The TdxSpreadSheetCellReferenceOption type is referenced by the TdxSpreadSheetCellReferenceOptions type.

See Also