/// <summary>
/// Create automatic column filter and display on specified headers of worksheet.
/// </summary>
/// <param name="range">Range to filter data.</param>
/// <param name="columnFilterUI">Indicates whether or not to show GUI for filter,
/// by default the drop-down button displayed on column header and a candidates list popuped up when dropdown-panel opened.
/// Set this argument as NoGUI to create filter without GUI.</param>
/// <returns>Instance of column filter.</returns>
public AutoColumnFilter CreateColumnFilter(RangePosition range,
AutoColumnFilterUI columnFilterUI = AutoColumnFilterUI.DropdownButtonAndPanel)
{
var filter = new AutoColumnFilter(this, this.FixRange(range));
filter.Attach(this, columnFilterUI);
return(filter);
}
/// <summary>
/// Do action to create column filter
/// </summary>
public override void Do()
{
if (this.autoColumnFilter == null)
{
this.autoColumnFilter = base.Worksheet.CreateColumnFilter(this.Range,
AutoColumnFilterUI.DropdownButtonAndPanel);
}
else
{
this.autoColumnFilter.Attach(base.Worksheet);
}
}
