@Internal public enum FormulaType extends java.lang.Enum<FormulaType>
Enum Constant and Description |
---|
ARRAY
An Array formula ("{=SUM(A1:E1*{1,2,3,4,5}}") https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-7D94A64E-3FF3-4686-9372-ECFD5CAA57C7
|
CELL
Regular cell formula
|
CONDFORMAT
Conditional formatting
|
DATAVALIDATION_LIST
This constant is currently very specific.
|
NAMEDRANGE
Named range
|
SHARED
A Shared Formula ("{=SUM(A1:E1*{1,2,3,4,5}}") Similar to an array formula, but stored in a SHAREDFMLA instead of ARRAY record as a file size optimization.
|
Modifier and Type | Method and Description |
---|---|
static FormulaType |
forInt(int code)
Used to transition from
int s (possibly stored in the Excel file) to
FormulaType s.
(用于从整数(可能存储在 Excel 文件中)转换为公式类型。)
|
boolean |
isSingleValue() |
static FormulaType |
valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name.
(返回具有指定名称的此类型的枚举常量。)
|
static FormulaType[] |
values()
Returns an array containing the constants of this enum type, in the order they are declared.
(按照声明的顺序返回包含此枚举类型常量的数组。)
|
public static final FormulaType CELL
public static final FormulaType SHARED
public static final FormulaType ARRAY
public static final FormulaType CONDFORMAT
public static final FormulaType NAMEDRANGE
public static final FormulaType DATAVALIDATION_LIST
public static FormulaType[] values()
for (FormulaType c : FormulaType.values()) System.out.println(c);(按照声明的顺序返回包含此枚举类型常量的数组。此方法可用于迭代常量,如下所示: for (FormulaType c : FormulaType.values()) System.out.println(c);)
public static FormulaType valueOf(java.lang.String name)
name
- the name of the enum constant to be returned.
(name - 要返回的枚举常量的名称。)
java.lang.IllegalArgumentException
- if this enum type has no constant with the specified name
(java.lang.IllegalArgumentException - 如果此枚举类型没有具有指定名称的常量)
java.lang.NullPointerException
- if the argument is null
(java.lang.NullPointerException - 如果参数为空)
public boolean isSingleValue()
public static FormulaType forInt(int code)
int
s (possibly stored in the Excel file) to
FormulaType
s.
(用于从整数(可能存储在 Excel 文件中)转换为公式类型。)
code
-
(代码 -)
java.lang.IllegalArgumentException
- if code is out of range
(java.lang.IllegalArgumentException - 如果代码超出范围)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.