public final class CFRule12Record extends CFRuleBase implements FutureRecord
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
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 |
---|
CFRule12Record(CFRule12Record other) |
CFRule12Record(RecordInputStream in) |
Modifier and Type | Method and Description |
---|---|
boolean |
containsColorGradientBlock() |
boolean |
containsDataBarBlock() |
boolean |
containsMultiStateBlock() |
CFRule12Record |
copy() |
static CFRule12Record |
create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2)
Creates a new comparison operation rule
(创建新的比较运算规则)
|
static CFRule12Record |
create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2, java.lang.String formulaTextScale)
Creates a new comparison operation rule
(创建新的比较运算规则)
|
static CFRule12Record |
create(HSSFSheet sheet, ExtendedColor color)
Creates a new Data Bar formatting
(创建新的数据栏格式)
|
static CFRule12Record |
create(HSSFSheet sheet, IconMultiStateFormatting.IconSet iconSet)
Creates a new Icon Set / Multi-State formatting
(创建一个新的图标集/多状态格式)
|
static CFRule12Record |
create(HSSFSheet sheet, java.lang.String formulaText)
Creates a new comparison operation rule
(创建新的比较运算规则)
|
ColorGradientFormatting |
createColorGradientFormatting() |
static CFRule12Record |
createColorScale(HSSFSheet sheet)
Creates a new Color Scale / Color Gradient formatting
(创建新的色阶/颜色渐变格式)
|
DataBarFormatting |
createDataBarFormatting() |
IconMultiStateFormatting |
createMultiStateFormatting() |
CellRangeAddress |
getAssociatedRange() |
ColorGradientFormatting |
getColorGradientFormatting() |
DataBarFormatting |
getDataBarFormatting() |
protected int |
getDataSize() |
FtrHeader |
getFutureHeader() |
short |
getFutureRecordType() |
java.util.Map<java.lang.String,java.util.function.Supplier<?>> |
getGenericProperties() |
HSSFRecordTypes |
getGenericRecordType() |
IconMultiStateFormatting |
getMultiStateFormatting() |
Ptg[] |
getParsedExpressionScale()
get the stack of the scale expression as a list
(以列表形式获取比例表达式的堆栈)
|
int |
getPriority() |
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.
(由负责编写此傻瓜的类调用。)
|
void |
setParsedExpressionScale(Ptg[] ptgs) |
void |
setPriority(int priority) |
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, toString
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
getGenericChildren
public static final short sid
public CFRule12Record(CFRule12Record other)
public CFRule12Record(RecordInputStream in)
public static CFRule12Record create(HSSFSheet sheet, java.lang.String formulaText)
sheet
- the sheet
(表 - 表)
formulaText
- the first formula text
(formulaText - 第一个公式文本)
public static CFRule12Record 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 static CFRule12Record create(HSSFSheet sheet, byte comparisonOperation, java.lang.String formulaText1, java.lang.String formulaText2, java.lang.String formulaTextScale)
sheet
- the sheet
(表 - 表)
comparisonOperation
- the comparison operation
(compareOperation - 比较操作)
formulaText1
- the first formula text
(formulaText1 - 第一个公式文本)
formulaText2
- the second formula text
(formulaText2 - 第二个公式文本)
formulaTextScale
- the scale to apply for the comparison
(formulaTextScale - 应用比较的比例)
public static CFRule12Record create(HSSFSheet sheet, ExtendedColor color)
sheet
- the sheet
(表 - 表)
color
- the data bar color
(color - 数据栏颜色)
public static CFRule12Record create(HSSFSheet sheet, IconMultiStateFormatting.IconSet iconSet)
sheet
- the sheet
(表 - 表)
iconSet
- the icon set
(iconSet - 图标集)
public static CFRule12Record createColorScale(HSSFSheet sheet)
sheet
- the sheet
(表 - 表)
public boolean containsDataBarBlock()
public DataBarFormatting getDataBarFormatting()
public DataBarFormatting createDataBarFormatting()
public boolean containsMultiStateBlock()
public IconMultiStateFormatting getMultiStateFormatting()
public IconMultiStateFormatting createMultiStateFormatting()
public boolean containsColorGradientBlock()
public ColorGradientFormatting getColorGradientFormatting()
public ColorGradientFormatting createColorGradientFormatting()
public Ptg[] getParsedExpressionScale()
public void setParsedExpressionScale(Ptg[] ptgs)
public int getPriority()
public void setPriority(int priority)
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 CFRule12Record copy()
copy
in interface
Duplicatable
(复制到界面 Duplicatable)
copy
in class
CFRuleBase
(在 CFRuleBase 类中复制)
public short getFutureRecordType()
getFutureRecordType
in interface
FutureRecord
(接口 FutureRecord 中的 getFutureRecordType)
public FtrHeader getFutureHeader()
getFutureHeader
in interface
FutureRecord
(接口 FutureRecord 中的 getFutureHeader)
public CellRangeAddress getAssociatedRange()
getAssociatedRange
in interface
FutureRecord
(接口 FutureRecord 中的 getAssociatedRange)
public HSSFRecordTypes getGenericRecordType()
getGenericRecordType
in interface
GenericRecord
(接口 GenericRecord 中的 getGenericRecordType)
getGenericRecordType
in class
Record
(类 Record 中的 getGenericRecordType)
public java.util.Map<java.lang.String,java.util.function.Supplier<?>> getGenericProperties()
getGenericProperties
in interface
GenericRecord
(接口 GenericRecord 中的 getGenericProperties)
getGenericProperties
in class
CFRuleBase
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.