XlFunc.Subtotal(XlCellRange, XlSummary, Boolean) Method

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll

Declaration

public static IXlFormulaParameter Subtotal(
    XlCellRange range,
    XlSummary summary,
    bool ignoreHidden
)

Parameters

Name Type Description
range XlCellRange

A XlCellRange object which references the cells containing values for calculation.

summary XlSummary

A XlSummary enumeration member that specifies the calculation type, i.e. the function used for calculation.

ignoreHidden Boolean

True to include hidden rows or columns in the calculation; otherwise, false.

Returns

Type Description
IXlFormulaParameter

An IXlFormulaParameter object that is the function result.

See Also