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 |
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() |
HSSFRecordTypes |
getGenericRecordType() |
short |
getSid()
return the non static version of the id for this record.
(返回此记录的 id 的非静态版本。)
|
void |
serialize(LittleEndianOutput out)
called by the class that is responsible for writing this sucker.
(由负责编写此傻瓜的类调用。)
|
containsAlignFormattingBlock, containsBorderFormattingBlock, containsFontFormattingBlock, containsPatternFormattingBlock, containsProtectionFormattingBlock, getBorderFormatting, getComparisonOperation, getConditionType, getFontFormatting, getFormattingBlockSize, getFormula1, getFormula2, getFormulaSize, getGenericProperties, 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, toString
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
getGenericChildren
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 sheet
(表 - 表)
formulaText
- the formula text
(formulaText - 公式文本)
public static CFRuleRecord create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)
sheet
- the sheet
(表 - 表)
comparisonOperation
- the comparison operation
(compareOperation - 比较操作)
formulaText1
- the first formula text
(formulaText1 - 第一个公式文本)
formulaText2
- the second formula text
(formulaText2 - 第二个公式文本)
public short getSid()
Record
public void serialize(LittleEndianOutput out)
serialize
in class
StandardRecord
(在 StandardRecord 类中序列化)
out
- the stream to write to
(out - 要写入的流)
protected int getDataSize()
getDataSize
in class
StandardRecord
(类 StandardRecord 中的 getDataSize)
public CFRuleRecord copy()
copy
in interface
Duplicatable
(复制到界面 Duplicatable)
copy
in class
CFRuleBase
(在 CFRuleBase 类中复制)
public HSSFRecordTypes getGenericRecordType()
getGenericRecordType
in interface
GenericRecord
(接口 GenericRecord 中的 getGenericRecordType)
getGenericRecordType
in class
Record
(类 Record 中的 getGenericRecordType)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.