Package | Description |
---|---|
org.apache.poi.ss.formula.eval | |
org.apache.poi.ss.formula.functions |
Modifier and Type | Class and Description |
---|---|
class |
ConcatEval |
class |
IntersectionEval |
class |
RangeEval |
class |
RelationalOperationEval
Base class for all comparison operator evaluators
|
class |
TwoOperandNumericOperation |
Modifier and Type | Class and Description |
---|---|
class |
Complex
Implementation for Excel COMPLEX () function.
Syntax:
COMPLEX (real_num,i_num,suffix ) Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. |
class |
Countif
Implementation for the function COUNTIF
|
class |
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.
|
class |
Dec2Bin
Implementation for Excel Bin2Dec() function.
Syntax:
Bin2Dec (number,[places] ) Converts a decimal number to binary. |
class |
Dec2Hex
Implementation for Excel DELTA() function.
Syntax:
DEC2HEX (number,places ) Converts a decimal number to hexadecimal. |
class |
Delta
Implementation for Excel DELTA() function.
Syntax:
DELTA (number1,number2 ) Tests whether two values are equal. |
class |
Fixed |
class |
Fixed2ArgFunction
Convenience base class for functions that must take exactly two arguments.
|
class |
Hyperlink
Implementation of Excel HYPERLINK function.
In Excel this function has special behaviour - it causes the displayed cell value to behave like
a hyperlink in the GUI.
|
class |
IfFunc
Implementation for the Excel function IF
|
class |
Index
Implementation for the Excel function INDEX
|
class |
Intercept
Implementation of Excel function INTERCEPT()
Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values
(http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html) Syntax: INTERCEPT(arrayX, arrayY) |
class |
LinearRegressionFunction
Base class for linear regression functions.
|
class |
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.
|
class |
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. |
static class |
NumericFunction.TwoArg |
class |
Quotient
Implementation for Excel QUOTIENT () function.
|
class |
Rank
Returns the rank of a number in a list of numbers.
|
class |
Rept
Implementation for Excel REPT () function.
Syntax:
REPT (text,number_times ) Repeats text a given number of times. |
class |
Roman
Implementation for Excel WeekNum() function.
Syntax:
WeekNum (Serial_num,Return_type) Returns a number that indicates where the week falls numerically within a year. |
class |
Slope
Implementation of Excel function SLOPE()
Calculates the SLOPE of the linear regression line that is used to predict y values from x values
(http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html) Syntax: SLOPE(arrayX, arrayY) |
class |
Sumif
Implementation for the Excel function SUMIF
|
class |
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) |
class |
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) |
class |
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 |
class |
WeekNum
Implementation for Excel WeekNum() function.
Syntax:
WeekNum (Serial_num,Return_type) Returns a number that indicates where the week falls numerically within a year. |
class |
XYNumericFunction |
Copyright 2016 The Apache Software Foundation or its licensors, as applicable.