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 |
Indirect.instance |
static FreeRefFunction |
Sumifs.instance |
Modifier and Type | Method and Description |
---|---|
FreeRefFunction |
DefaultUDFFinder.findFunction(java.lang.String name) |
FreeRefFunction |
AggregatingUDFFinder.findFunction(java.lang.String name)
Returns executor by specified name.
|
FreeRefFunction |
UDFFinder.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.