Skip to main content

XlFunc.Subtotal(IList<XlCellRange>, XlSummary, Boolean) Method

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

public static IXlFormulaParameter Subtotal(
    IList<XlCellRange> ranges,
    XlSummary summary,
    bool ignoreHidden
)

Parameters

Name Type Description
ranges IList<XlCellRange>

A list of XlCellRange objects which are the references to 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