Package org.zkoss.poi.ss.formula.functions

Interface Summary
FreeRefFunction For most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed.
Function Common interface for all implementations of Excel built-in functions.
Function0Arg Implemented by all functions that can be called with zero arguments
Function1Arg Implemented by all functions that can be called with one argument
Function2Arg Implemented by all functions that can be called with two arguments
Function3Arg Implemented by all functions that can be called with three arguments
Function4Arg Implemented by all functions that can be called with four arguments
Operator Marker interface for function accept one argument or two arguments.
XYNumericFunction.Accumulator  
 

Class Summary
Address Creates a text reference as text, given specified row and column numbers.
AggregateFunction  
BooleanFunction Here are the general rules concerning Boolean functions: Blanks are ignored (not either true or false) Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false' Numbers: 0 is false.
BooleanFunction.OneArg  
CalendarFieldFunction Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
Choose  
Column  
Columns Implementation for Excel COLUMNS function.
Complex  
ComplexFormat  
Count Counts the number of cells that contain numeric data within the list of arguments.
Counta Counts the number of cells that contain data within the list of arguments.
Countblank Implementation for the function COUNTBLANK Syntax: COUNTBLANK ( range ) range   is the range of cells to count blanks
Countif Implementation for the function COUNTIF Syntax: COUNTIF ( range, criteria ) range   is the range of cells to be counted based on the criteria criteriais used to determine which cells to count
DateFunc Implementation for the Excel function DATE
Days360 Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations.
Errortype Implementation for the ERROR.TYPE() Excel function.
Even  
FinanceFunction  
FinanceLib  
Fixed0ArgFunction Convenience base class for functions that only take zero arguments.
Fixed1ArgFunction Convenience base class for functions that must take exactly one argument.
Fixed2ArgFunction Convenience base class for functions that must take exactly two arguments.
Fixed3ArgFunction Convenience base class for functions that must take exactly three arguments.
Fixed4ArgFunction Convenience base class for functions that must take exactly four arguments.
Hlookup Implementation of the HLOOKUP() function.
Hyperlink Implementation of Excel HYPERLINK function.
IfFunc Implementation for the Excel function IF
Index Implementation for the Excel function INDEX Syntax :
INDEX ( reference, row_num[, column_num [, area_num]])
INDEX ( array, row_num[, column_num]) referencetypically an area reference, possibly a union of areas arraya literal array value (currently not supported) row_numselects the row within the array or area reference column_numselects column within the array or area reference. default is 1 area_numused when reference is a union of areas
Indirect Implementation for Excel function INDIRECT

INDIRECT() returns the cell or area reference denoted by the text argument.

Irr Calculates the internal rate of return.
LogicalFunction  
Lookup Implementation of Excel function LOOKUP.
Match Implementation for the MATCH() Excel function.
MinaMaxa  
Mode  
MultiOperandNumericFunction  
Na Implementation of Excel function NA()
NotImplementedFunction  
Now Implementation of Excel NOW() Function
Npv Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).
NumericFunction  
NumericFunction.OneArg  
NumericFunction.TwoArg  
NumericFunctionHelper  
Odd  
Offset Implementation for Excel function OFFSET()

OFFSET returns an area reference that is a specified number of rows and columns from a reference cell or area.

OverridableFunction A Overridable function to provide the chance of override poi's basic functions
Rank Returns the rank of a number in a list of numbers.
Rate Implements the Excel Rate function
Replace An implementation of the Excel REPLACE() function:

Replaces part of a text string based on the number of characters you specify, with another text string.

RowFunc Implementation for the Excel function ROW
Rows Implementation for Excel ROWS function.
Substitute An implementation of the SUBSTITUTE function:

Substitutes text in a text string with new text, some number of times.

Subtotal Implementation for the Excel function SUBTOTAL Syntax :
SUBTOTAL ( functionCode, ref1, ref2 ... )
functionCode(1-11) Selects the underlying aggregate function to be used (see table below) ref1, ref2 ...
Sumif Implementation for the Excel function SUMIF Syntax :
SUMIF ( range, criteria, sum_range )
rangeThe range over which criteria is applied.
Sumifs Implementation for the Excel function SUMIFS Syntax :
SUMIFS ( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Sumproduct Implementation for the Excel function SUMPRODUCT Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])
Sumx2my2 Implementation of Excel function SUMX2MY2()

Calculates the sum of differences of squares in two arrays of the same size.

Sumx2py2 Implementation of Excel function SUMX2PY2()

Calculates the sum of squares in two arrays of the same size.

Sumxmy2 Implementation of Excel function SUMXMY2()

Calculates the sum of squares of differences between two arrays of the same size.

T Implementation of Excel T() function

If the argument is a text or error value it is returned unmodified.

TextFunction  
TextFunctionHelper  
TimeFunc Implementation for the Excel function TIME
Today Implementation of Excel TODAY() Function
UtilFns  
Value Implementation for Excel VALUE() function.
Vlookup Implementation of the VLOOKUP() function.
WeekdayFunc Implementation for the Excel function WEEKDAY
XYNumericFunction  
 



Copyright © 2005-2010 Potix Corporation. All Rights Reserved.