TdxSpreadSheetCellReferenceOption Enum

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

Declaration

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.