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(); }
public void Unsubtotal() { var rows = Sheet.Rows(_range.FirstRow().RowNumber(), _range.LastRow().RowNumber()); rows.Ungroup(true); IXLRangeRow row = _range.FirstRow(); while (!row.IsEmpty()) { if (row.IsSummary()) { var rowNumber = row.RowNumber(); row = row.RowAbove(); Sheet.Row(rowNumber).Delete(); } row = row.RowBelow(); } }