Package | Description |
---|---|
org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
Related Documentation
For overviews, tutorials, examples, guides, and tool documentation, please see:
Apache POI Project
|
org.zkoss.poi.ss.usermodel | |
org.zkoss.poi.xssf.usermodel |
Modifier and Type | Class and Description |
---|---|
class |
HSSFConditionalFormattingRule
High level representation of Conditional Formatting Rule.
|
Modifier and Type | Method and Description |
---|---|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1) |
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules) |
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2) |
void |
HSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule) |
void |
HSSFConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule) |
Modifier and Type | Method and Description |
---|---|
ConditionalFormattingRule |
SheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula)
Create a conditional formatting rule that compares a cell value
to a formula calculated result, using an operator *
The type of the created condition is
CONDITION_TYPE_CELL_VALUE_IS
|
ConditionalFormattingRule |
SheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula1,
java.lang.String formula2)
A factory method allowing to create a conditional formatting rule
with a cell comparison operator
The created conditional formatting rule compares a cell value
to a formula calculated result, using the specified operator.
|
ConditionalFormattingRule |
SheetConditionalFormatting.createConditionalFormattingRule(java.lang.String formula)
Create a conditional formatting rule based on a Boolean formula.
|
ConditionalFormattingRule |
ConditionalFormatting.getRule(int idx) |
Modifier and Type | Method and Description |
---|---|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule)
Add a new Conditional Formatting to the sheet.
|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules)
Add a new Conditional Formatting set to the sheet.
|
int |
SheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2)
Add a new Conditional Formatting consisting of two rules.
|
void |
ConditionalFormatting.addRule(ConditionalFormattingRule cfRule)
Add a Conditional Formatting rule.
|
void |
ConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx.
|
Modifier and Type | Class and Description |
---|---|
class |
XSSFConditionalFormattingRule |
Modifier and Type | Method and Description |
---|---|
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1) |
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule[] cfRules) |
int |
XSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
ConditionalFormattingRule rule1,
ConditionalFormattingRule rule2) |
void |
XSSFConditionalFormatting.addRule(ConditionalFormattingRule cfRule)
Add a Conditional Formatting rule.
|
void |
XSSFConditionalFormatting.setRule(int idx,
ConditionalFormattingRule cfRule)
Replaces an existing Conditional Formatting rule at position idx.
|
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.