XlFunc.Subtotal(XlCellRange, XlSummary, Boolean) Method

A SUBTOTAL mathematical function.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

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

VB.NET

Public Shared Function Subtotal(
    range As XlCellRange,
    summary As XlSummary,
    ignoreHidden As Boolean
) As IXlFormulaParameter

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.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference 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.

C#

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/CS/XLExportExampleSalesReport/Form1.cs#L380

using (IXlCell cell = row.CreateCell()) {
    cell.SetFormula(XlFunc.Subtotal(XlCellRange.FromLTRB(j + 2, 3, j + 2, row.RowIndex - 1), XlSummary.Sum, false));
    cell.ApplyFormatting(grandTotalRowFormatting);

VB.NET

how-to-use-the-excel-export-api-to-generate-a-sales-report-t251810/VB/XLExportExampleSalesReport/Form1.vb#L393

Using cell As IXlCell = row.CreateCell()
    cell.SetFormula(XlFunc.Subtotal(XlCellRange.FromLTRB(j + 2, 3, j + 2, row.RowIndex - 1), XlSummary.Sum, False))
    cell.ApplyFormatting(grandTotalRowFormatting)