Skip to main content

dxSpreadSheetUtils Unit

Classes

Name Description
TdxSpreadSheetColumnHelper Implements spreadsheet column identification methods.

Enums

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

Methods

Name Description
dxIsCurrency(Double) Identifies if the specified Double value represents a monetary value.
dxIsDateTime(Variant) Identifies if the specified Variant value has the TDateTime type.
dxIsLogical(Variant) Identifies if the specified Variant value has a Boolean type.
dxIsNumberOrDateTime(Variant) Identifies if the specified Variant value is a number or date/time.
dxIsNumericOrDateTime(Variant) Identifies if the specified Variant value has a numeric or TDateTime type.
dxIsText(Variant) Identifies if the specified Variant value stores a text string.
dxReferenceToString(Integer,Integer,TdxSpreadSheetReference,TdxSpreadSheetReference)
dxReferenceToString(Integer,Integer,Boolean,TdxSpreadSheetCellReferenceOptions,string)
dxReferenceToString(TStringBuilder,Integer,Integer,TdxSpreadSheetReference,TdxSpreadSheetReference)
dxReferenceToString(TStringBuilder,TRect,Boolean,Integer,Integer)
dxReferenceToString(TRect,Boolean,TdxSpreadSheetCellReferenceOptions,string) Creates the cell reference string from the specified parameters.
dxReferenceToString(TRect,Boolean,Integer,Integer)
dxSpreadSheetArea(TPoint,TSize) Returns the rectangle bounding the area which is determined by its origin and dimensions.
dxSpreadSheetAreaHeight(TRect) Returns the number of rows covered by the specified cell range (area) within a worksheet.
dxSpreadSheetAreaSize(TRect) Returns the dimensions of the specified cell range.
dxSpreadSheetAreaWidth(TRect) Returns the number of columns covered by the specified cell range (area) within a worksheet.
dxSpreadSheetCellsUnion(TRect,TRect) Unites two cell ranges into one.
dxSpreadSheetCompareText(Pointer,Pointer,Integer,Integer)
dxSpreadSheetCompareText(string,Pointer,Integer)
dxSpreadSheetCompareText(string,string) Compares the lexical value of two specified text strings.
dxSpreadSheetContains(TRect,Integer,Integer)
dxSpreadSheetContains(TRect,TRect) Returns a value indicating whether the table items or a cell range are included in the specified area.
dxSpreadSheetContainsColumn(TRect,Integer) Returns a value indicating whether a column passes through the specified cell range area.
dxSpreadSheetContainsRow(TRect,Integer) Returns a value indicating whether a row passes through the specified cell range area.
dxSpreadSheetEntireSheetArea Returns boundaries of the worksheet Table View‘s content area.
dxSpreadSheetErrorCodeToString(TdxSpreadSheetFormulaErrorCode) Converts the specified spreadsheet formula error code into a Unicode string.
dxSpreadSheetExtractConditionParams(string,TdxSpreadSheetFormatSettings,Variant,TdxSpreadSheetFormulaOperation) Extracts condition parameters from the specified formula token.
dxSpreadSheetGetRealArea(TRect) Returns the validated area bounds.
dxSpreadSheetIntersects(TRect,TRect,TRect) Returns a value indicating whether the specified cell ranges intersect.
dxSpreadSheetIntersects(TRect,TRect)
dxSpreadSheetIsEntireColumn(TRect) Returns a value indicating whether the specified area contains one or more full columns in Table View‘s content area.
dxSpreadSheetIsEntireRow(TRect) Returns a value indicating whether the specified area contains one or more full rows in the Table View‘s content area.
dxSpreadSheetIsEntireRowOrColumn(TRect) Returns a value indicating whether the specified area contains one or more full rows or columns in Table View‘s content area.
dxSpreadSheetIsErrorString(string,TdxSpreadSheetFormulaErrorCode) Returns a value indicating whether the specified string corresponds to a spreadsheet formula error code.
dxSpreadSheetIsSingleCellArea(TRect) Returns a value indicating whether the specified area corresponds to a single cell.
dxSpreadSheetIsValidArea(TRect) Returns a value indicating whether the specified area is valid.
dxSpreadSheetLowerCase(string) Converts uppercase characters to lowercase characters.
dxSpreadSheetTextIsEqual(string,string) Returns a value indicating whether the two specified text strings are identical.
dxSpreadSheetUpperCase(string) Converts lowercase characters to uppercase characters.
dxStringToReference(string,Integer,Integer) Obtains a cell position from the specified cell reference.
dxStringToReferenceArea(string) Returns the rectangle corresponding to the specified reference to a cell or cell range.

Types

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