예제 #1
0
        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();
        }
예제 #2
0
        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();
            }
        }