| Package | Description |
|---|---|
| org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
| org.apache.poi.ss.formula.atp | |
| org.apache.poi.ss.formula.functions | |
| org.apache.poi.ss.formula.udf | |
| org.apache.poi.xssf.model |
| Modifier and Type | Field and Description |
|---|---|
static FreeRefFunction |
OperationEvaluationContext.UDF |
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
OperationEvaluationContext.findUserDefinedFunction(java.lang.String functionName) |
FreeRefFunction |
WorkbookEvaluator.findUserDefinedFunction(java.lang.String functionName) |
| Modifier and Type | Method and Description |
|---|---|
static void |
WorkbookEvaluator.registerFunction(java.lang.String name,
FreeRefFunction func)
Register a ATP function in runtime.
|
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
AnalysisToolPak.findFunction(java.lang.String name) |
| Modifier and Type | Method and Description |
|---|---|
static void |
AnalysisToolPak.registerFunction(java.lang.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 |
DefaultUDFFinder.findFunction(java.lang.String name) |
FreeRefFunction |
UDFFinder.findFunction(java.lang.String name)
Returns executor by specified name.
|
FreeRefFunction |
AggregatingUDFFinder.findFunction(java.lang.String name)
Returns executor by specified name.
|
| Constructor and Description |
|---|
DefaultUDFFinder(java.lang.String[] functionNames,
FreeRefFunction[] functionImpls) |
| Modifier and Type | Method and Description |
|---|---|
FreeRefFunction |
IndexedUDFFinder.findFunction(java.lang.String name) |
Copyright 2013 The Apache Software Foundation or its licensors, as applicable.