public CFRule(CFType type, CellStyle style, CFOperator @operator = CFOperator.LessThan,
string formula1 = "", string formula2 = "", string formula3 = "")
{
Type = type;
Style = style;
Operator = @operator;
Formula1 = formula1;
Formula2 = formula2;
Formula3 = formula3;
IsBottom = false;
Rank = 10;
IsPercent = false;
StdDev = 0;
IsAboveAverage = true;
IsEqualAverage = false;
IsStdDev = false;
Text = null;
TimePeriod = TimePeriod.Today;
}
private CFRule GetRuleForTwoValues(CFType type, string startValue, string endValue, CellStyle style, CFOperator @operator)
{
CFRule rule = new CFRule(type, style, @operator, startValue, endValue);
AddRule(rule);
return(rule);
}
public CFRule(CFType type, CellStyle style, CFOperator @operator = CFOperator.LessThan,
string formula1 = "", string formula2 = "", string formula3 = "")
{
Type = type;
Style = style;
Operator = @operator;
Formula1 = formula1;
Formula2 = formula2;
Formula3 = formula3;
IsBottom = false;
Rank = 10;
IsPercent = false;
StdDev = 0;
IsAboveAverage = true;
IsEqualAverage = false;
IsStdDev = false;
Text = null;
TimePeriod = TimePeriod.Today;
}
private CFRule GetRuleForOneValue(CFType type, string value, CellStyle style, CFOperator @operator, string text = null)
{
value = CFRule.CreateFormula(value, type, GetFirstCellStringValue());
CFRule rule = new CFRule(type, style, @operator, value);
rule.Text = text;
AddRule(rule);
return(rule);
}
