public interface ConditionalFormatting
ConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);
Sheet.getSheetConditionalFormatting()
to get access to an instance of this class.
To create a new Conditional Formatting set use the following approach:
// Define a Conditional Formatting rule, which triggers formatting // when cell's value is greater or equal than 100.0 and // applies patternFormatting defined below. ConditionalFormattingRule rule = sheet.createConditionalFormattingRule( ComparisonOperator.GE, "100.0", // 1st formula null // 2nd formula is not used for comparison operator GE ); // Create pattern with red background PatternFormatting patternFmt = rule.cretePatternFormatting(); patternFormatting.setFillBackgroundColor(IndexedColor.RED.getIndex()); // Define a region containing first column Region [] regions = { new Region(1,(short)1,-1,(short)1) }; // Apply Conditional Formatting rule defined above to the regions sheet.addConditionalFormatting(regions, rule);
Modifier and Type | Method and Description |
---|---|
void |
addRule(ConditionalFormattingRule cfRule)
Add a Conditional Formatting rule.
|
CellRangeAddress[] |
getFormattingRanges() |
int |
getNumberOfRules() |
ConditionalFormattingRule |
getRule(int idx) |
void |
setRule(int idx,
ConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx.
|
CellRangeAddress[] getFormattingRanges()
null
void setRule(int idx, ConditionalFormattingRule cfRule)
idx
- position of the rule. Should be between 0 and 2.cfRule
- - Conditional Formatting rulevoid addRule(ConditionalFormattingRule cfRule)
cfRule
- - Conditional Formatting ruleConditionalFormattingRule getRule(int idx)
int getNumberOfRules()
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.