|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | ENUM CONSTANTS | FIELD | METHOD | DETAIL: ENUM CONSTANTS | FIELD | METHOD | |||||||||
java.lang.Objectjava.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 ints (possibly stored in the Excel file) to FormulaTypes. |
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)
ints (possibly stored in the Excel file) to FormulaTypes.
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 | |||||||||