public void CanClearMergedRanges(XLClearOptions options, int expectedCount) { using (var wb = new XLWorkbook()) { var ws = wb.AddWorksheet("Test"); ws.Range("A1:C3").Merge(); ws.Range("A4:B6").Merge(); ws.Range("D1:F3").Merge(); ws.Range("E4:F6").Merge(); ws.Range("C1:D6").Clear(options); Assert.AreEqual(expectedCount, ws.MergedRanges.Count); } }
public new IXLRangeColumn Clear(XLClearOptions clearOptions = XLClearOptions.All) { base.Clear(clearOptions); return(this); }
public IXLTables Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _tables.Values.ForEach(t => t.Clear(clearOptions)); return this; }
public IXLTables Clear(XLClearOptions clearOptions = XLClearOptions.All) { _tables.Values.ForEach(t => t.Clear(clearOptions)); return(this); }
public IXLRangeColumns Clear(XLClearOptions clearOptions = XLClearOptions.All) { _ranges.ForEach(c => c.Clear(clearOptions)); return(this); }
public IXLColumns Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _columns.ForEach(c=>c.Clear(clearOptions)); return this; }
public new IXLRow Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { base.Clear(clearOptions); return this; }
public IXLTableRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _ranges.ForEach(r => r.Clear(clearOptions)); return(this); }
public IXLTableRows Clear(XLClearOptions clearOptions = XLClearOptions.All) { _ranges.ForEach(r => r.Clear(clearOptions)); return(this); }
public IXLRangeRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _ranges.ForEach(c => c.Clear(clearOptions)); return this; }
public IXLRangeColumns Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _ranges.ForEach(c => c.Clear(clearOptions)); return(this); }
public IXLCells Clear(XLClearOptions clearOptions = XLClearOptions.All) { this.ForEach <XLCell>(c => c.Clear(clearOptions)); return(this); }
public static XLCellsUsedOptions ToCellsUsedOptions(this XLClearOptions options) { return((XLCellsUsedOptions)options); }
public IXLCells Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { this.ForEach <XLCell>(c => c.Clear(clearOptions)); return(this); }
public new IXLRangeRow Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { base.Clear(clearOptions); return(this); }
public IXLTables Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _tables.Values.ForEach(t => t.Clear(clearOptions)); return(this); }
public IXLRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _rows.ForEach(c => c.Clear(clearOptions)); return(this); }
public new IXLRow Clear(XLClearOptions clearOptions = XLClearOptions.All) { base.Clear(clearOptions); return(this); }
public IXLRows Clear(XLClearOptions clearOptions = XLClearOptions.All) { _rows.ForEach(c => c.Clear(clearOptions)); return(this); }
public IXLTableRows Clear(XLClearOptions clearOptions = XLClearOptions.ContentsAndFormats) { _ranges.ForEach(r => r.Clear(clearOptions)); return this; }