internal override void SetFilterValue(ExcelWorksheet worksheet, ExcelAddressBase address)
{
if (Type == eDynamicFilterType.AboveAverage ||
Type == eDynamicFilterType.BelowAverage)
{
Value = GetAvg(worksheet, address);
MaxValue = null;
}
else
{
DynamicDateFilterMatcher.SetMatchDates(this);
}
}
internal override bool Match(object value, string valueText)
{
if (Type == eDynamicFilterType.AboveAverage)
{
return(ConvertUtil.GetValueDouble(value) > Value);
}
else if (Type == eDynamicFilterType.BelowAverage)
{
return(ConvertUtil.GetValueDouble(value) < Value);
}
else
{
var date = ConvertUtil.GetValueDate(value);
if (date.HasValue == false)
{
return(false);
}
return(DynamicDateFilterMatcher.Match(this, date));
}
}
internal ExcelDynamicFilterColumn(XmlNamespaceManager namespaceManager, XmlNode topNode) : base(namespaceManager, topNode)
{
DynamicDateFilterMatcher.SetMatchDates(this);
}