|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectorg.apache.poi.xssf.usermodel.XSSFSheetConditionalFormatting
public class XSSFSheetConditionalFormatting
| Method Summary | |
|---|---|
int |
addConditionalFormatting(org.apache.poi.ss.util.CellRangeAddress[] regions,
org.apache.poi.ss.usermodel.ConditionalFormattingRule rule1)
|
int |
addConditionalFormatting(org.apache.poi.ss.util.CellRangeAddress[] regions,
org.apache.poi.ss.usermodel.ConditionalFormattingRule[] cfRules)
|
int |
addConditionalFormatting(org.apache.poi.ss.util.CellRangeAddress[] regions,
org.apache.poi.ss.usermodel.ConditionalFormattingRule rule1,
org.apache.poi.ss.usermodel.ConditionalFormattingRule rule2)
|
int |
addConditionalFormatting(org.apache.poi.ss.usermodel.ConditionalFormatting cf)
Adds a copy of HSSFConditionalFormatting object to the sheet |
org.apache.poi.ss.usermodel.ConditionalFormattingRule |
createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula)
|
org.apache.poi.ss.usermodel.ConditionalFormattingRule |
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 TODO - formulas containing cell references are currently not parsed properly |
org.apache.poi.ss.usermodel.ConditionalFormattingRule |
createConditionalFormattingRule(java.lang.String formula)
A factory method allowing to create a conditional formatting rule with a formula. |
org.apache.poi.ss.usermodel.ConditionalFormatting |
getConditionalFormattingAt(int index)
gets Conditional Formatting object at a particular index |
int |
getNumConditionalFormattings()
|
void |
removeConditionalFormatting(int index)
removes a Conditional Formatting object by index |
| Methods inherited from class java.lang.Object |
|---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Method Detail |
|---|
public org.apache.poi.ss.usermodel.ConditionalFormattingRule createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula1,
java.lang.String formula2)
createConditionalFormattingRule in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingcomparisonOperation - - a constant value from
CFRuleRecord.ComparisonOperator:
formula1 - - formula for the valued, compared with the cellformula2 - - second formula (only used with
ComparisonOperator.BETWEEN) and
ComparisonOperator.NOT_BETWEEN operations)
public org.apache.poi.ss.usermodel.ConditionalFormattingRule createConditionalFormattingRule(byte comparisonOperation,
java.lang.String formula)
createConditionalFormattingRule in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingpublic org.apache.poi.ss.usermodel.ConditionalFormattingRule createConditionalFormattingRule(java.lang.String formula)
createConditionalFormattingRule in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingformula - - formula for the valued, compared with the cell
public int addConditionalFormatting(org.apache.poi.ss.util.CellRangeAddress[] regions,
org.apache.poi.ss.usermodel.ConditionalFormattingRule[] cfRules)
addConditionalFormatting in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
public int addConditionalFormatting(org.apache.poi.ss.util.CellRangeAddress[] regions,
org.apache.poi.ss.usermodel.ConditionalFormattingRule rule1)
addConditionalFormatting in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
public int addConditionalFormatting(org.apache.poi.ss.util.CellRangeAddress[] regions,
org.apache.poi.ss.usermodel.ConditionalFormattingRule rule1,
org.apache.poi.ss.usermodel.ConditionalFormattingRule rule2)
addConditionalFormatting in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingpublic int addConditionalFormatting(org.apache.poi.ss.usermodel.ConditionalFormatting cf)
This method could be used to copy HSSFConditionalFormatting object from one sheet to another. For example:
HSSFConditionalFormatting cf = sheet.getConditionalFormattingAt(index); newSheet.addConditionalFormatting(cf);
addConditionalFormatting in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingcf - HSSFConditionalFormatting object
public org.apache.poi.ss.usermodel.ConditionalFormatting getConditionalFormattingAt(int index)
getConditionalFormattingAt in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingindex - of the Conditional Formatting object to fetch
public int getNumConditionalFormattings()
getNumConditionalFormattings in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingpublic void removeConditionalFormatting(int index)
removeConditionalFormatting in interface org.apache.poi.ss.usermodel.SheetConditionalFormattingindex - of a Conditional Formatting object to remove
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||