| 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 |
Countif
Implementation for the function COUNTIF
|
class |
Delta
Implementation for Excel DELTA() function.
Syntax:
DELTA (number1,number2 ) Tests whether two values are equal. |
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.
|
static class |
NumericFunction.TwoArg |
class |
Quotient
Implementation for Excel QUOTIENT () function.
|
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 |
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 2015 The Apache Software Foundation or its licensors, as applicable.