corelibraries-devexpress-dot-export-dot-xl-ea71c0f2.md
Lists functions to calculate the totals of table columns.
Namespace : DevExpress.Export.Xl
Assembly : DevExpress.Printing.v25.2.Core.dll
NuGet Package : DevExpress.Printing.Core
public enum XlTotalRowFunction
Public Enum XlTotalRowFunction
| 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.
|
The following properties accept/return XlTotalRowFunction values:
The XlTotalRowFunction enumeration members are used by the IXlTableColumn.TotalRowFunction property.
See Also