Skip to main content

XlFunc.Subtotal(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(
    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.

The following code snippets (auto-collected from DevExpress Examples) contain references to the Subtotal(XlCellRange, XlSummary, Boolean) method.

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.

See Also