/** @return array of <tt>CellRangeAddress</tt>s. never <code>null</code> */
public CellRangeAddress[] getFormattingRanges() {
return cfAggregate.getHeader().getCellRanges();
}
public String toString() {
return cfAggregate.toString();
}
/** @return number of Conditional Formatting rules. */
public int getNumberOfRules() {
return cfAggregate.getNumberOfRules();
}
/** @return the Conditional Formatting rule at position idx. */
public HSSFConditionalFormattingRule getRule(int idx) {
CFRuleRecord ruleRecord = cfAggregate.getRule(idx);
return new HSSFConditionalFormattingRule(_workbook, ruleRecord);
}
/**
* add a Conditional Formatting rule. Excel allows to create up to 3 Conditional Formatting rules.
*
* @param cfRule - Conditional Formatting rule
*/
public void addRule(HSSFConditionalFormattingRule cfRule) {
cfAggregate.addRule(cfRule.getCfRuleRecord());
}
/**
* Replaces an existing Conditional Formatting rule at position idx. Excel allows to create up to
* 3 Conditional Formatting rules. This method can be useful to modify existing Conditional
* Formatting rules.
*
* @param idx position of the rule. Should be between 0 and 2.
* @param cfRule - Conditional Formatting rule
*/
public void setRule(int idx, HSSFConditionalFormattingRule cfRule) {
cfAggregate.setRule(idx, cfRule.getCfRuleRecord());
}