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 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;
}
