| Modifier and Type | Class and Description |
|---|---|
| private static class | FunctionEval.
Some function IDs that require special treatment |
| Modifier and Type | Field and Description |
|---|---|
| protected static final Function[] | functions
Array elements corresponding to unimplemented functions are |
| Access | Constructor and Description |
|---|---|
| private |
| Modifier and Type | Method and Description |
|---|---|
| public static Function | Returns: null if the specified functionIndex is for INDIRECT() or any external (add-in) function.
|
| public static Collection | Returns: an array of not supported functionsReturns an array of function names NOT implemented by POI. |
| public static Collection | Returns: an array of supported functionsReturns a collection of function names implemented by POI. |
| private static Function[] | |
| public static void | registerFunction(String
the function name name, Function the function to register func)Register a new function in runtime. |
| functions | back to summary |
|---|---|
| protected static final Function[] functions Array elements corresponding to unimplemented functions are | |
| FunctionEval | back to summary |
|---|---|
| private FunctionEval() | |
| getBasicFunction | back to summary |
|---|---|
public static Function getBasicFunction(int functionIndex)
| |
| getNotSupportedFunctionNames | back to summary |
|---|---|
| public static Collection Returns an array of function names NOT implemented by POI.
| |
| getSupportedFunctionNames | back to summary |
|---|---|
| public static Collection Returns a collection of function names implemented by POI.
| |
| produceFunctions | back to summary |
|---|---|
| private static Function[] produceFunctions() See Apache Open Office Excel File Format, Section 3.11 Built-In Sheet Functions | |
| registerFunction | back to summary |
|---|---|
| public static void registerFunction(String name, Function func) Register a new function in runtime.
| |
| Modifier and Type | Field and Description |
|---|---|
| public static final int | CHOOSE
100 |
| public static final int | |
| public static final int | IF
1 |
| public static final int | INDIRECT
148 |
| public static final int | OFFSET
78 |
| public static final int | SUM
4 |
| Access | Constructor and Description |
|---|---|
| private |
| CHOOSE | back to summary |
|---|---|
| public static final int CHOOSE 100 | |
| EXTERNAL_FUNC | back to summary |
|---|---|
| public static final int EXTERNAL_FUNC 255 | |
| IF | back to summary |
|---|---|
| public static final int IF 1 | |
| INDIRECT | back to summary |
|---|---|
| public static final int INDIRECT 148 | |
| OFFSET | back to summary |
|---|---|
| public static final int OFFSET 78 | |
| SUM | back to summary |
|---|---|
| public static final int SUM 4 | |
| FunctionID | back to summary |
|---|---|
| private FunctionID() | |