org.zkoss.poi.ss.formula.function

Class FunctionMetadataRegistry

java.lang.Object

org.zkoss.poi.ss.formula.function.FunctionMetadataRegistry

public final class FunctionMetadataRegistry
extends Object

Allows clients to get FunctionMetadata instances for any built-in function of Excel.

Author:

Josh Micich

Field Summary

Fields

Modifier and Type	Field and Description
static int	FUNCTION_INDEX_CHOOSE
static short	FUNCTION_INDEX_EXTERNAL
static int	FUNCTION_INDEX_IF
static short	FUNCTION_INDEX_INDIRECT
static short	FUNCTION_INDEX_SUM
static short	FUNCTION_INDEX_SUMPRODUCT
static String	FUNCTION_NAME_IF The name of the IF function (i.e.

Method Summary

Modifier and Type	Method and Description
static FunctionMetadata	getFunctionByIndex(int index)
static FunctionMetadata	getFunctionByName(String name)
static short	lookupIndexByName(String name) Resolves a built-in function index.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

FUNCTION_NAME_IF

public static final String FUNCTION_NAME_IF

The name of the IF function (i.e. "IF"). Extracted as a constant for clarity.

See Also:

Constant Field Values

FUNCTION_INDEX_IF

public static final int FUNCTION_INDEX_IF

See Also:

Constant Field Values

FUNCTION_INDEX_SUM

public static final short FUNCTION_INDEX_SUM

See Also:

Constant Field Values

FUNCTION_INDEX_CHOOSE

public static final int FUNCTION_INDEX_CHOOSE

See Also:

Constant Field Values

FUNCTION_INDEX_INDIRECT

public static final short FUNCTION_INDEX_INDIRECT

See Also:

Constant Field Values

FUNCTION_INDEX_EXTERNAL

public static final short FUNCTION_INDEX_EXTERNAL

See Also:

Constant Field Values

FUNCTION_INDEX_SUMPRODUCT

public static final short FUNCTION_INDEX_SUMPRODUCT

See Also:

Constant Field Values

Method Detail

getFunctionByIndex

public static FunctionMetadata getFunctionByIndex(int index)

lookupIndexByName

public static short lookupIndexByName(String name)

Resolves a built-in function index.

Parameters:

name - uppercase function name

Returns:

a negative value if the function name is not found. This typically occurs for external functions.

getFunctionByName

public static FunctionMetadata getFunctionByName(String name)