public final class CFRuleRecord extends CFRuleBase implements java.lang.Cloneable
This is for the older-style Excel conditional formattings,
new-style (Excel 2007+) also make use of CFRule12Record
for their rules.
CFRuleBase.ComparisonOperator| Modifier and Type | Field and Description |
|---|---|
static short |
sid |
_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 and Description |
|---|
CFRuleRecord(RecordInputStream in) |
| Modifier and Type | Method and Description |
|---|---|
CFRuleRecord |
clone() |
static CFRuleRecord |
create(HSSFSheet sheet,
byte comparisonOperation,
java.lang.String formulaText1,
java.lang.String formulaText2)
Creates a new comparison operation rule
|
static CFRuleRecord |
create(HSSFSheet sheet,
java.lang.String formulaText)
Creates a new comparison operation rule
|
protected int |
getDataSize() |
short |
getSid()
return the non static version of the id for this record.
|
void |
serialize(LittleEndianOutput out)
called by the class that is responsible for writing this sucker.
|
java.lang.String |
toString()
get a string representation of the record (for biffview/debugging)
|
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, setTopLeftBottomRightBorderModifiedgetRecordSize, serializecloneViaReserialise, serializepublic static final short sid
public CFRuleRecord(RecordInputStream in)
public static CFRuleRecord create(HSSFSheet sheet, java.lang.String formulaText)
public static CFRuleRecord create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)
public short getSid()
Recordpublic void serialize(LittleEndianOutput out)
serialize in class StandardRecordout - the stream to write toprotected int getDataSize()
getDataSize in class StandardRecordpublic java.lang.String toString()
Recordpublic CFRuleRecord clone()
clone in class CFRuleBaseCopyright 2017 The Apache Software Foundation or its licensors, as applicable.