|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | ENUM CONSTANTS | FIELD | METHOD | DETAIL: ENUM CONSTANTS | FIELD | METHOD |
java.lang.Object java.lang.Enum<FormulaType> org.apache.poi.ss.formula.FormulaType
@Internal public enum FormulaType
Enumeration of various formula types. See Sections 3 and 4.8 of https://www.openoffice.org/sc/excelfileformat.pdf
Enum Constant Summary | |
---|---|
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. |
Method Summary | |
---|---|
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. |
Methods inherited from class java.lang.Enum |
---|
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf |
Methods inherited from class java.lang.Object |
---|
getClass, notify, notifyAll, wait, wait, wait |
Enum Constant Detail |
---|
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
Method Detail |
---|
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 name
java.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 range
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | ENUM CONSTANTS | FIELD | METHOD | DETAIL: ENUM CONSTANTS | FIELD | METHOD |