vcl-dxspreadsheetutils.md
| Name | Description |
|---|---|
| TdxSpreadSheetColumnHelper | Implements spreadsheet column identification methods. |
| Name | Description |
|---|---|
| TdxSpreadSheetCellReferenceOption | Enumerates attributes that can be applied to a cell reference used in formula expressions. |
| 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. |
| Name | Description |
|---|---|
| TdxSpreadSheetCellReferenceOptions | A set of reference attributes applied to a cell reference used in formula expressions. |