Skip to main content

XlTotalRowFunction Enum

Lists functions to calculate the totals of table columns.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

public enum XlTotalRowFunction

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.

See Also