@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. |
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);
public static FormulaType valueOf(java.lang.String name)
name
- the name of the enum constant to be returned.java.lang.IllegalArgumentException
- if this enum type has no constant with the specified namejava.lang.NullPointerException
- if the argument is nullpublic boolean isSingleValue()
public static FormulaType forInt(int code)
int
s (possibly stored in the Excel file) to FormulaType
s.code
- java.lang.IllegalArgumentException
- if code is out of rangeCopyright 2021 The Apache Software Foundation or its licensors, as applicable.