Back to Devexpress

Worksheet.RemoveSubtotal(CellRange) Method

officefileapi-devexpress-dot-spreadsheet-dot-worksheet-dot-removesubtotal-x28-devexpress-dot-spreadsheet-dot-cellrange-x29.md

latest1.7 KB
Original Source

Worksheet.RemoveSubtotal(CellRange) Method

Removes subtotals for the specified cell range.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
void RemoveSubtotal(
    CellRange range
)
vb
Sub RemoveSubtotal(
    range As CellRange
)

Parameters

NameTypeDescription
rangeCellRange

A CellRange object that is the range of cells for which the subtotals should be removed.

|

Remarks

Use the RemoveSubtotal method to clear an outline and remove the calculated subtotal rows for the specified range. You can also use the RowCollection.ClearOutline or RangeExtensions.ClearOutline method to ungroup data but retain the subtotal rows.

See Also

Worksheet Interface

Worksheet Members

DevExpress.Spreadsheet Namespace