Package org.apache.poi.hssf.record
Class CFRule12Record
java.lang.Object
org.apache.poi.hssf.record.RecordBase
org.apache.poi.hssf.record.Record
org.apache.poi.hssf.record.StandardRecord
org.apache.poi.hssf.record.CFRuleBase
org.apache.poi.hssf.record.CFRule12Record
- All Implemented Interfaces:
Cloneable,FutureRecord
Conditional Formatting v12 Rule Record (0x087A).
This is for newer-style Excel conditional formattings, from Excel 2007 onwards.
CFRuleRecord is used where the condition type is
CFRuleBase.CONDITION_TYPE_CELL_VALUE_IS or CFRuleBase.CONDITION_TYPE_FORMULA,
this is only used for the other types
-
Nested Class Summary
Nested classes/interfaces inherited from class org.apache.poi.hssf.record.CFRuleBase
CFRuleBase.ComparisonOperator -
Field Summary
FieldsFields inherited from class org.apache.poi.hssf.record.CFRuleBase
_borderFormatting, _fontFormatting, _patternFormatting, CONDITION_TYPE_CELL_VALUE_IS, CONDITION_TYPE_COLOR_SCALE, CONDITION_TYPE_DATA_BAR, CONDITION_TYPE_FILTER, CONDITION_TYPE_FORMULA, CONDITION_TYPE_ICON_SET, formatting_not_used, formatting_options, logger, TEMPLATE_ABOVE_AVERAGE, TEMPLATE_ABOVE_OR_EQUAL_TO_AVERAGE, TEMPLATE_BELOW_AVERAGE, TEMPLATE_BELOW_OR_EQUAL_TO_AVERAGE, TEMPLATE_CELL_VALUE, TEMPLATE_COLOR_SCALE_FORMATTING, TEMPLATE_CONTAINS_BLANKS, TEMPLATE_CONTAINS_ERRORS, TEMPLATE_CONTAINS_NO_BLANKS, TEMPLATE_CONTAINS_NO_ERRORS, TEMPLATE_CONTAINS_TEXT, TEMPLATE_DATA_BAR_FORMATTING, TEMPLATE_DUPLICATE_VALUES, TEMPLATE_FILTER, TEMPLATE_FORMULA, TEMPLATE_ICON_SET_FORMATTING, TEMPLATE_LAST_7_DAYS, TEMPLATE_LAST_MONTH, TEMPLATE_LAST_WEEK, TEMPLATE_NEXT_MONTH, TEMPLATE_NEXT_WEEK, TEMPLATE_THIS_MONTH, TEMPLATE_THIS_WEEK, TEMPLATE_TODAY, TEMPLATE_TOMORROW, TEMPLATE_UNIQUE_VALUES, TEMPLATE_YESTERDAY -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionclone()booleanbooleanbooleanstatic CFRule12RecordCreates a new comparison operation rulestatic CFRule12Recordcreate(HSSFSheet sheet, byte comparisonOperation, String formulaText1, String formulaText2, String formulaTextScale) Creates a new comparison operation rulestatic CFRule12RecordCreates a new comparison operation rulestatic CFRule12Recordcreate(HSSFSheet sheet, ExtendedColor color) Creates a new Data Bar formattingstatic CFRule12Recordcreate(HSSFSheet sheet, IconMultiStateFormatting.IconSet iconSet) Creates a new Icon Set / Multi-State formattingstatic CFRule12RecordcreateColorScale(HSSFSheet sheet) Creates a new Color Scale / Color Gradient formattingprotected intshortPtg[]get the stack of the scale expression as a listintshortgetSid()return the non static version of the id for this record.voidcalled by the class that is responsible for writing this sucker.voidsetParsedExpressionScale(Ptg[] ptgs) voidsetPriority(int priority) toString()get a string representation of the record (for biffview/debugging)Methods inherited from class org.apache.poi.hssf.record.CFRuleBase
containsAlignFormattingBlock, containsBorderFormattingBlock, containsFontFormattingBlock, containsPatternFormattingBlock, containsProtectionFormattingBlock, copyTo, getBorderFormatting, getComparisonOperation, getConditionType, getFontFormatting, getFormattingBlockSize, getFormula1, getFormula2, getFormulaSize, getOptions, getParsedExpression1, getParsedExpression2, getPatternFormatting, isBottomBorderModified, isBottomLeftTopRightBorderModified, isLeftBorderModified, isPatternBackgroundColorModified, isPatternColorModified, isPatternStyleModified, isRightBorderModified, isTopBorderModified, isTopLeftBottomRightBorderModified, parseFormula, readFormatOptions, serializeFormattingBlock, setAlignFormattingUnchanged, setBorderFormatting, setBottomBorderModified, setBottomLeftTopRightBorderModified, setComparisonOperation, setConditionType, setFontFormatting, setFormula1, setFormula2, setLeftBorderModified, setParsedExpression1, setParsedExpression2, setPatternBackgroundColorModified, setPatternColorModified, setPatternFormatting, setPatternStyleModified, setProtectionFormattingUnchanged, setRightBorderModified, setTopBorderModified, setTopLeftBottomRightBorderModifiedMethods inherited from class org.apache.poi.hssf.record.StandardRecord
getRecordSize, serializeMethods inherited from class org.apache.poi.hssf.record.Record
cloneViaReserialise, serialize
-
Field Details
-
sid
public static final short sid- See Also:
-
-
Constructor Details
-
CFRule12Record
-
-
Method Details
-
create
Creates a new comparison operation rule- Parameters:
sheet- the sheetformulaText- the first formula text- Returns:
- a new comparison operation rule
-
create
public static CFRule12Record create(HSSFSheet sheet, byte comparisonOperation, String formulaText1, String formulaText2) Creates a new comparison operation rule- Parameters:
sheet- the sheetcomparisonOperation- the comparison operationformulaText1- the first formula textformulaText2- the second formula text- Returns:
- a new comparison operation rule
-
create
public static CFRule12Record create(HSSFSheet sheet, byte comparisonOperation, String formulaText1, String formulaText2, String formulaTextScale) Creates a new comparison operation rule- Parameters:
sheet- the sheetcomparisonOperation- the comparison operationformulaText1- the first formula textformulaText2- the second formula textformulaTextScale- the scale to apply for the comparison- Returns:
- a new comparison operation rule
-
create
Creates a new Data Bar formatting- Parameters:
sheet- the sheetcolor- the data bar color- Returns:
- a new Data Bar formatting
-
create
Creates a new Icon Set / Multi-State formatting- Parameters:
sheet- the sheeticonSet- the icon set- Returns:
- a new Icon Set / Multi-State formatting
-
createColorScale
Creates a new Color Scale / Color Gradient formatting- Parameters:
sheet- the sheet- Returns:
- a new Color Scale / Color Gradient formatting
-
containsDataBarBlock
public boolean containsDataBarBlock() -
getDataBarFormatting
-
createDataBarFormatting
-
containsMultiStateBlock
public boolean containsMultiStateBlock() -
getMultiStateFormatting
-
createMultiStateFormatting
-
containsColorGradientBlock
public boolean containsColorGradientBlock() -
getColorGradientFormatting
-
createColorGradientFormatting
-
getParsedExpressionScale
get the stack of the scale expression as a list- Returns:
- list of tokens (casts stack to a list and returns it!) this method can return null is we are unable to create Ptgs from existing excel file callers should check for null!
-
setParsedExpressionScale
-
getPriority
public int getPriority() -
setPriority
public void setPriority(int priority) -
getSid
public short getSid()Description copied from class:Recordreturn the non static version of the id for this record. -
serialize
called by the class that is responsible for writing this sucker. Subclasses should implement this so that their data is passed back in a byte array.- Specified by:
serializein classStandardRecord- Parameters:
out- the stream to write to
-
getDataSize
protected int getDataSize()- Specified by:
getDataSizein classStandardRecord
-
toString
Description copied from class:Recordget a string representation of the record (for biffview/debugging) -
clone
- Specified by:
clonein classCFRuleBase
-
getFutureRecordType
public short getFutureRecordType()- Specified by:
getFutureRecordTypein interfaceFutureRecord
-
getFutureHeader
- Specified by:
getFutureHeaderin interfaceFutureRecord
-
getAssociatedRange
- Specified by:
getAssociatedRangein interfaceFutureRecord
-