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(111) 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 © 20052010 Potix Corporation. All Rights Reserved.
 