XlFunc.Subtotal(XlCellRange, XlSummary, Boolean) Method

A SUBTOTAL mathematical function.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

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 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.

C#

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L350

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

excel-export-library-generate-sales-analysis-report/CS/XLExportExample/Form1.cs#L299

using (IXlCell cell = row.CreateCell()) {
    cell.SetFormula(XlFunc.Subtotal(XlCellRange.FromLTRB(1, firstDataRowIndex, 1, row.RowIndex - 1), XlSummary.Average, false));
    cell.ApplyFormatting(totalRowFormatting);

VB.NET

excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L363

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

excel-export-library-generate-sales-analysis-report/VB/XLExportExample/Form1.vb#L283

Using cell As IXlCell = row.CreateCell()
    cell.SetFormula(XlFunc.Subtotal(XlCellRange.FromLTRB(1, firstDataRowIndex, 1, row.RowIndex - 1), XlSummary.Average, False))
    cell.ApplyFormatting(totalRowFormatting)