Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
Modifier and Type | Method | Description |
---|---|---|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula1) |
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.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
|
HSSFConditionalFormattingRule |
HSSFSheetConditionalFormatting.createConditionalFormattingRule(java.lang.String formula) |
A factory method allowing to create a conditional formatting rule with a formula.
The formatting rules are applied by Excel when the value of the formula not equal to 0. |
HSSFConditionalFormattingRule |
HSSFConditionalFormatting.getRule(int idx) |
Modifier and Type | Method | Description |
---|---|---|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1) |
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule[] cfRules) |
Allows to add a new Conditional Formatting set to the sheet.
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(CellRangeAddress[] regions,
HSSFConditionalFormattingRule rule1,
HSSFConditionalFormattingRule rule2) |
|
int |
HSSFSheetConditionalFormatting.addConditionalFormatting(Region[] regions,
HSSFConditionalFormattingRule[] cfRules) |
Deprecated.
use CellRangeAddress instead of Region
|
void |
HSSFConditionalFormatting.addRule(HSSFConditionalFormattingRule cfRule) |
add a Conditional Formatting rule.
|
void |
HSSFConditionalFormatting.setRule(int idx,
HSSFConditionalFormattingRule cfRule) |
Replaces an existing Conditional Formatting rule at position idx.
|
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.