TTMSFNCCustomDataGrid.ColumnDistinct Method
Returns the number of distinct text values in a column.
API unit family: TMSFNCDataGrid
Declaring type: TTMSFNCCustomDataGrid
Syntax
function ColumnDistinct(AColumn: Integer; AFromRow: Integer = -1; AToRow: Integer = -1): Double;
double __fastcall ColumnDistinct(int AColumn, int AFromRow = 0xffffffff, int AToRow = 0xffffffff);
Remarks
Values are compared as strings, case-insensitively. The same row selection as ColumnSum applies (base cells of default rows, hidden rows only with Options.Calculations.IncludeHiddenRows).
Parameters
| Name | Description |
|---|---|
AColumn |
Zero-based column index. |
AFromRow |
First row to include, or -1 for the whole data range. |
AToRow |
Last row to include, or -1 for the whole data range. |
Returns
Number of distinct values.