org.apache.poi.ss.usermodel

Class ConditionType

java.lang.Object

org.apache.poi.ss.usermodel.ConditionType

public class ConditionType
extends java.lang.Object

Represents a type of a conditional formatting rule (表示一种条件格式规则)

Field Summary

Fields

Modifier and Type	Field and Description
static ConditionType	CELL_VALUE_IS This conditional formatting rule compares a cell value to a formula calculated result, using an operator (此条件格式规则使用运算符将单元格值与公式计算结果进行比较)
static ConditionType	COLOR_SCALE This conditional formatting rule contains a color scale, with the cell background set according to a gradient. (此条件格式规则包含一个色标，单元格背景根据渐变设置。)
static ConditionType	DATA_BAR This conditional formatting rule sets a data bar, with the cell populated with bars based on their values (此条件格式规则设置数据栏，单元格根据其值填充栏)
static ConditionType	FILTER This conditional formatting rule that files the values (归档值的条件格式规则)
static ConditionType	FORMULA This conditional formatting rule contains a formula to evaluate. (此条件格式规则包含要评估的公式。)
static ConditionType	ICON_SET This conditional formatting rule sets a data bar, with the cell populated with bars based on their values (此条件格式规则设置数据栏，单元格根据其值填充栏)
byte	id
java.lang.String	type

Method Summary

Modifier and Type	Method and Description
static ConditionType	forId(byte id)
static ConditionType	forId(int id)
java.lang.String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

CELL_VALUE_IS

public static final ConditionType CELL_VALUE_IS

This conditional formatting rule compares a cell value to a formula calculated result, using an operator (此条件格式规则使用运算符将单元格值与公式计算结果进行比较)

FORMULA

public static final ConditionType FORMULA

This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted. (此条件格式规则包含要评估的公式。当公式结果为真时，单元格将突出显示。)

COLOR_SCALE

public static final ConditionType COLOR_SCALE

This conditional formatting rule contains a color scale, with the cell background set according to a gradient. (此条件格式规则包含一个色标，单元格背景根据渐变设置。)

DATA_BAR

public static final ConditionType DATA_BAR

This conditional formatting rule sets a data bar, with the cell populated with bars based on their values (此条件格式规则设置数据栏，单元格根据其值填充栏)

FILTER

public static final ConditionType FILTER

This conditional formatting rule that files the values (归档值的条件格式规则)

ICON_SET

public static final ConditionType ICON_SET

This conditional formatting rule sets a data bar, with the cell populated with bars based on their values (此条件格式规则设置数据栏，单元格根据其值填充栏)

id

public final byte id

type

public final java.lang.String type

Method Detail

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

forId

public static ConditionType forId(byte id)

forId

public static ConditionType forId(int id)