public final class CFRuleRecord extends CFRuleBase
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(CFRuleRecord other) |
CFRuleRecord(RecordInputStream in) |
Modifier and Type | Method and Description |
---|---|
CFRuleRecord |
clone()
Deprecated.
|
CFRuleRecord |
copy() |
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, 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, setTopLeftBottomRightBorderModified
getRecordSize, serialize
cloneViaReserialise, serialize
public static final short sid
public CFRuleRecord(CFRuleRecord other)
public CFRuleRecord(RecordInputStream in)
public static CFRuleRecord create(HSSFSheet sheet, java.lang.String formulaText)
sheet
- the sheetformulaText
- the formula textpublic static CFRuleRecord create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)
sheet
- the sheetcomparisonOperation
- the comparison operationformulaText1
- the first formula textformulaText2
- the second formula textpublic short getSid()
Record
public void serialize(LittleEndianOutput out)
serialize
in class StandardRecord
out
- the stream to write toprotected int getDataSize()
getDataSize
in class StandardRecord
public java.lang.String toString()
Record
@Deprecated @Removal(version="5.0.0") public CFRuleRecord clone()
clone
in class CFRuleBase
public CFRuleRecord copy()
copy
in interface Duplicatable
copy
in class CFRuleBase
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.