|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use Function2Arg | |
---|---|
org.apache.poi.ss.formula.eval | |
org.apache.poi.ss.formula.functions |
Uses of Function2Arg in org.apache.poi.ss.formula.eval |
---|
Classes in org.apache.poi.ss.formula.eval that implement Function2Arg | |
---|---|
class |
ConcatEval
|
class |
IntersectionEval
|
class |
RangeEval
|
class |
RelationalOperationEval
Base class for all comparison operator evaluators |
class |
TwoOperandNumericOperation
|
Uses of Function2Arg in org.apache.poi.ss.formula.functions |
---|
Classes in org.apache.poi.ss.formula.functions that implement Function2Arg | |
---|---|
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
|
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |