XlTotalRowFunction Enum
Lists functions to calculate the totals of table columns.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v18.1.Core.dll
Declaration
Members
Name | Description |
---|---|
None
|
Indicates that the total for the table column is not calculated. |
Average
|
Returns the average (arithmetic mean) of the numbers contained in the table column. |
Count
|
Returns the number of cells with non-empty values contained in the table column. |
CountNums
|
Returns the number of cells with numeric values contained in the table column. |
Max
|
Returns the largest number contained in the table column. |
Min
|
Returns the smallest number contained in the table column. |
StdDev
|
Calculates the standard deviation based on the sample contained in the table column. |
Sum
|
Returns the sum of the numbers contained in the table column. |
Var
|
Calculates the variance of the sample contained in the table column. |
Related API Members
The following properties accept/return XlTotalRowFunction values:
Remarks
The XlTotalRowFunction enumeration members are used by the IXlTableColumn.TotalRowFunction property.
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlTotalRowFunction enum.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.