| Package | Description |
|---|---|
| io.keikaiex.formula |
Classes bridging Keikai Spreadsheet formula functions to ZK EL functions.
|
| org.zkoss.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
| org.zkoss.poi.ss.formula.atp | |
| org.zkoss.poi.ss.formula.functions | |
| org.zkoss.poi.ss.formula.udf | |
| org.zkoss.poi.xssf.model |
| Modifier and Type | Class and Description |
|---|---|
class |
ELEval
A function that do EL evaluation.
|
class |
ELEvalFunction
This the default function that delegate the POI function call to EL tld function.
|
| Modifier and Type | Field and Description |
|---|---|
static FreeRefFunction |
ELEval.instance |
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
ZKUDFFinder.findFunction(String name) |
| Modifier and Type | Class and Description |
|---|---|
class |
UserDefinedFunction
Common entry point for all user-defined (non-built-in) functions (where
AbstractFunctionPtg.field_2_fnc_index == 255)
|
| Modifier and Type | Field and Description |
|---|---|
static FreeRefFunction |
UserDefinedFunction.instance |
static FreeRefFunction |
OperationEvaluationContext.UDF |
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
WorkbookEvaluator.findUserDefinedFunction(String functionName) |
FreeRefFunction |
OperationEvaluationContext.findUserDefinedFunction(String functionName) |
| Modifier and Type | Method and Description |
|---|---|
static void |
WorkbookEvaluator.registerFunction(String name,
FreeRefFunction func)
Register a ATP function in runtime.
|
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
AnalysisToolPak.findFunction(String name) |
| Modifier and Type | Method and Description |
|---|---|
static void |
AnalysisToolPak.registerFunction(String name,
FreeRefFunction func)
Register a ATP function in runtime.
|
| Modifier and Type | Class and Description |
|---|---|
class |
Indirect
Implementation for Excel function INDIRECT
INDIRECT() returns the cell or area reference denoted by the text argument.
Syntax:
INDIRECT(ref_text,isA1Style)
ref_text a string representation of the desired reference as it would
normally be written in a cell formula.
isA1Style (default TRUE) specifies whether the ref_text should be interpreted as A1-style or R1C1-style. |
class |
Sumifs
Implementation for the Excel function SUMIFS
|
| Modifier and Type | Field and Description |
|---|---|
static FreeRefFunction |
Sumifs.instance |
static FreeRefFunction |
Indirect.instance |
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
UDFFinder.findFunction(String name)
Returns executor by specified name.
|
FreeRefFunction |
DefaultUDFFinder.findFunction(String name) |
FreeRefFunction |
AggregatingUDFFinder.findFunction(String name)
Returns executor by specified name.
|
| Constructor and Description |
|---|
DefaultUDFFinder(String[] functionNames,
FreeRefFunction[] functionImpls) |
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
IndexedUDFFinder.findFunction(String name) |
Copyright © 2020. All rights reserved.