public IConditionalFormattingRule CreateConditionalFormattingRule(ComparisonOperator comparisonOperation, string formula1, string formula2)
{
XSSFConditionalFormattingRule conditionalFormattingRule = new XSSFConditionalFormattingRule(this._sheet);
CT_CfRule ctCfRule = conditionalFormattingRule.GetCTCfRule();
ctCfRule.AddFormula(formula1);
if (formula2 != null)
{
ctCfRule.AddFormula(formula2);
}
ctCfRule.type = ST_CfType.cellIs;
ST_ConditionalFormattingOperator formattingOperator;
switch (comparisonOperation)
{
case ComparisonOperator.BETWEEN:
formattingOperator = ST_ConditionalFormattingOperator.between;
break;
case ComparisonOperator.NOT_BETWEEN:
formattingOperator = ST_ConditionalFormattingOperator.notBetween;
break;
case ComparisonOperator.EQUAL:
formattingOperator = ST_ConditionalFormattingOperator.equal;
break;
case ComparisonOperator.NOT_EQUAL:
formattingOperator = ST_ConditionalFormattingOperator.notEqual;
break;
case ComparisonOperator.GT:
formattingOperator = ST_ConditionalFormattingOperator.greaterThan;
break;
case ComparisonOperator.LT:
formattingOperator = ST_ConditionalFormattingOperator.lessThan;
break;
case ComparisonOperator.GE:
formattingOperator = ST_ConditionalFormattingOperator.greaterThanOrEqual;
break;
case ComparisonOperator.LE:
formattingOperator = ST_ConditionalFormattingOperator.lessThanOrEqual;
break;
default:
throw new ArgumentException("Unknown comparison operator: " + (object)comparisonOperation);
}
ctCfRule.@operator = formattingOperator;
return((IConditionalFormattingRule)conditionalFormattingRule);
}
/**
* A factory method allowing to create a conditional formatting rule
* with a cell comparison operator<p/>
* TODO - formulas Containing cell references are currently not Parsed properly
*
* @param comparisonOperation - a constant value from
* <tt>{@link NPOI.hssf.record.CFRuleRecord.ComparisonOperator}</tt>: <p>
* <ul>
* <li>BETWEEN</li>
* <li>NOT_BETWEEN</li>
* <li>EQUAL</li>
* <li>NOT_EQUAL</li>
* <li>GT</li>
* <li>LT</li>
* <li>GE</li>
* <li>LE</li>
* </ul>
* </p>
* @param formula1 - formula for the valued, Compared with the cell
* @param formula2 - second formula (only used with
* {@link NPOI.ss.usermodel.ComparisonOperator#BETWEEN}) and
* {@link NPOI.ss.usermodel.ComparisonOperator#NOT_BETWEEN} operations)
*/
public IConditionalFormattingRule CreateConditionalFormattingRule(
ComparisonOperator comparisonOperation,
String formula1,
String formula2)
{
XSSFConditionalFormattingRule rule = new XSSFConditionalFormattingRule(_sheet);
CT_CfRule cfRule = rule.GetCTCfRule();
cfRule.AddFormula(formula1);
if (formula2 != null)
{
cfRule.AddFormula(formula2);
}
cfRule.type = (ST_CfType.cellIs);
ST_ConditionalFormattingOperator operator1;
switch (comparisonOperation)
{
case ComparisonOperator.Between:
operator1 = ST_ConditionalFormattingOperator.between; break;
case ComparisonOperator.NotBetween:
operator1 = ST_ConditionalFormattingOperator.notBetween; break;
case ComparisonOperator.LessThan:
operator1 = ST_ConditionalFormattingOperator.lessThan; break;
case ComparisonOperator.LessThanOrEqual:
operator1 = ST_ConditionalFormattingOperator.lessThanOrEqual; break;
case ComparisonOperator.GreaterThan:
operator1 = ST_ConditionalFormattingOperator.greaterThan; break;
case ComparisonOperator.GreaterThanOrEqual:
operator1 = ST_ConditionalFormattingOperator.greaterThanOrEqual; break;
case ComparisonOperator.Equal:
operator1 = ST_ConditionalFormattingOperator.equal; break;
case ComparisonOperator.NotEqual:
operator1 = ST_ConditionalFormattingOperator.notEqual; break;
default:
throw new ArgumentException("Unknown comparison operator: " + comparisonOperation);
}
cfRule.@operator = (operator1);
return(rule);
}
/**
* A factory method allowing to create a conditional formatting rule with a formula.<br>
*
* @param formula - formula for the valued, Compared with the cell
*/
public IConditionalFormattingRule CreateConditionalFormattingRule(String formula)
{
XSSFConditionalFormattingRule rule = new XSSFConditionalFormattingRule(_sheet);
CT_CfRule cfRule = rule.GetCTCfRule();
cfRule.AddFormula(formula);
cfRule.type = ST_CfType.expression;
return(rule);
}
public IConditionalFormattingRule CreateConditionalFormattingRule(string formula)
{
XSSFConditionalFormattingRule conditionalFormattingRule = new XSSFConditionalFormattingRule(this._sheet);
CT_CfRule ctCfRule = conditionalFormattingRule.GetCTCfRule();
ctCfRule.AddFormula(formula);
ctCfRule.type = ST_CfType.expression;
return((IConditionalFormattingRule)conditionalFormattingRule);
}
