Package org.apache.poi.hssf.record.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  
XYNumericFunction.Accumulator  
 

Class Summary
Absref  
Activecell  
Address  
AggregateFunction  
And  
Areas  
Argument  
Asc  
Averagea  
Betadist  
Betainv  
Binomdist  
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.
CalendarFieldFunction Implementation of Excel functions DAY, MONTH and YEAR
Call  
Caller  
Cell  
Char  
Chidist  
Chiinv  
Chitest  
Choose  
Clean  
Code  
Column  
Columns Implementation for Excel COLUMNS function.
Confidence  
Correl  
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  
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

Covar  
Critbinom  
Customrepeat  
Datedif  
DateFunc  
Datestring  
Datevalue  
Daverage  
Days360  
Db  
Dbcs  
Dcount  
Dcounta  
Ddb  
Deref  
Dget  
Dmax  
Dmin  
Dproduct  
Dstdev  
Dstdevp  
Dsum  
Dvar  
Dvarp  
Echo  
Error  
Errortype Implementation for the ERROR.TYPE() Excel function.

Syntax:
ERROR.TYPE(errorValue)

Returns a number corresponding to the error type of the supplied argument.

errorValueReturn Value #NULL!1 #DIV/0!2 #VALUE!3 #REF!4 #NAME?5 #NUM!6 #N/A!7 everything else#N/A! Note - the results of ERROR.TYPE() are different to the constants defined in HSSFErrorConstants.
Evaluate  
Even  
Exec  
Expondist  
False  
Fdist  
Files  
FinanceFunction  
FinanceLib  
Find  
Findb  
Finv  
Fisher  
Fisherinv  
Fixed  
Forecast  
Formulaconvert  
Fpos  
Frequency  
Ftest  
Gammadist  
Gammainv  
Gammaln  
Geomean  
Goto  
Group  
Growth  
Halt  
Harmean  
Help  
Hlookup Implementation of the HLOOKUP() function.

HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.
Syntax:
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)

lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data.

Hour  
Hyperlink  
Hypgeomdist  
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.
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.

Info  
Initiate  
Input  
Intercept  
Ipmt  
Irr  
Isblank  
Iserr  
IsError  
Islogical  
IsNa  
Isnontext  
Isnumber  
Ispmt  
Isref  
Istext  
Kurt  
Lasterror  
Leftb  
Lenb  
Linest  
Links  
Logest  
LogicalFunction  
Loginv  
Lognormdist  
Lookup Implementation of Excel function LOOKUP.

LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.

Match Implementation for the MATCH() Excel function.

Syntax:
MATCH(lookup_value, lookup_array, match_type)

Returns a 1-based index specifying at what position in the lookup_array the specified lookup_value is found.

Specific matching behaviour can be modified with the optional match_type parameter.

MathX  
Mdeterm  
Midb  
MinaMaxa  
Minute  
Minverse  
Mirr  
Mmult  
Mode  
MultiOperandNumericFunction  
N  
Na Implementation of Excel function NA()
Names  
Negbinomdist  
Normdist  
Norminv  
Normsdist  
Normsinv  
Not  
Note  
NotImplementedFunction  
Now Implementation of Excel NOW() Function
Npv  
Numberstring  
NumericFunction  
NumericFunction.MultiArg  
NumericFunction.OneArg  
NumericFunction.TwoArg  
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.

Syntax:
OFFSET(reference, rows, cols, height, width)

reference is the base reference.
rows is the number of rows up or down from the base reference.
cols is the number of columns left or right from the base reference.
height (default same height as base reference) is the row count for the returned area reference.
width (default same width as base reference) is the column count for the returned area reference.

Or  
Pearson  
Percentile  
Percentrank  
Permut  
Pi  
Poisson  
Ppmt  
Prob  
Proper  
Quartile  
Rand  
Rank  
Rate  
Reftext  
Relref  
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.
Syntax:
REPLACE(oldText, startNum, numChars, newText)

oldText The text string containing characters to replace
startNum The position of the first character to replace (1-based)
numChars The number of characters to replace
newText The new text value to replace the removed section

Replaceb  
Rept  
Request  
Result  
Rightb  
Roman  
Row  
Rows Implementation for Excel ROWS function.
Rsq  
Search  
Searchb  
Second  
Series  
Setname  
Setvalue  
Skew  
Sln  
Slope  
Standardize  
StatsLib  
Stdeva  
Stdevp  
Stdevpa  
Step  
Steyx  
Substitute An implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times.
Subtotal  
Sumif  
Sumproduct Implementation for the Excel function SUMPRODUCT

Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]])

array1, ...
Sumx2my2 Implementation of Excel function SUMX2MY2()

Calculates the sum of differences of squares in two arrays of the same size.
Syntax:
SUMX2MY2(arrayX, arrayY)

result = Σi: 0..n(xi2-yi2)

Sumx2py2 Implementation of Excel function SUMX2PY2()

Calculates the sum of squares in two arrays of the same size.
Syntax:
SUMX2PY2(arrayX, arrayY)

result = Σi: 0..n(xi2+yi2)

Sumxmy2 Implementation of Excel function SUMXMY2()

Calculates the sum of squares of differences between two arrays of the same size.
Syntax:
SUMXMY2(arrayX, arrayY)

result = Σi: 0..n(xi-yi)2

Syd  
T  
Tdist  
Text  
TextFunction  
Textref  
Time  
Timevalue  
Tinv  
Today Implementation of Excel TODAY() Function
Transpose  
Trend  
Trimmean  
True  
Trunc  
Ttest  
Type  
Usdollar  
Value  
Var  
Vara  
Varp  
Varpa  
Vdb  
Vlookup Implementation of the VLOOKUP() function.

VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.
Syntax:
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data.

Volatile  
Weekday  
Weibull  
XYNumericFunction  
Ztest  
 



Copyright 2008 The Apache Software Foundation or its licensors, as applicable.