public void Unsubtotal() { using (var rows = Sheet.Rows(_range.FirstRow().RowNumber(), _range.LastRow().RowNumber())) rows.Ungroup(true); IXLRangeRow row = _range.FirstRow(); while (!row.IsEmpty()) { if (row.IsSummary()) { Sheet.Row(row.RowNumber()).Delete(); row = row.Unsubscribed().RowAbove(); } row = row.Unsubscribed().RowBelow(); } row.Dispose(); }