public final class CFRuleRecord extends CFRuleBase implements 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 |
CONDITION_TYPE_CELL_VALUE_IS, CONDITION_TYPE_COLOR_SCALE, CONDITION_TYPE_DATA_BAR, CONDITION_TYPE_FILTER, CONDITION_TYPE_FORMULA, CONDITION_TYPE_ICON_SET, 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,
String formulaText1,
String formulaText2)
Creates a new comparison operation rule
|
static CFRuleRecord |
create(HSSFSheet sheet,
String formulaText)
Creates a new comparison operation rule
|
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.
|
String |
toString()
get a string representation of the record (for biffview/debugging)
|
containsAlignFormattingBlock, containsBorderFormattingBlock, containsFontFormattingBlock, containsPatternFormattingBlock, containsProtectionFormattingBlock, getBorderFormatting, getComparisonOperation, getConditionType, getFontFormatting, getOptions, getParsedExpression1, getParsedExpression2, getPatternFormatting, isBottomBorderModified, isBottomLeftTopRightBorderModified, isLeftBorderModified, isPatternBackgroundColorModified, isPatternColorModified, isPatternStyleModified, isRightBorderModified, isTopBorderModified, isTopLeftBottomRightBorderModified, parseFormula, setAlignFormattingUnchanged, setBorderFormatting, setBottomBorderModified, setBottomLeftTopRightBorderModified, setComparisonOperation, setFontFormatting, setLeftBorderModified, setParsedExpression1, setParsedExpression2, setPatternBackgroundColorModified, setPatternColorModified, setPatternFormatting, setPatternStyleModified, setProtectionFormattingUnchanged, setRightBorderModified, setTopBorderModified, setTopLeftBottomRightBorderModified
getRecordSize, serialize
cloneViaReserialise, serialize
public static final short sid
public CFRuleRecord(RecordInputStream in)
public static CFRuleRecord create(HSSFSheet sheet, String formulaText)
sheet
- the sheetformulaText
- the formula textpublic static CFRuleRecord create(HSSFSheet sheet, byte comparisonOperation, String formulaText1, String formulaText2)
sheet
- the sheetcomparisonOperation
- the comparison operationformulaText1
- the first formula textformulaText2
- the second formula textpublic short getSid()
Record
public void serialize(LittleEndianOutput out)
out
- the stream to write topublic String toString()
Record
public CFRuleRecord clone()
clone
in class CFRuleBase
Copyright © 2010 - 2020 Adobe. All Rights Reserved