Package | Description |
---|---|
io.keikai.model.impl.sys.formula |
Keikai Spreadsheet Internal Book Model Implementation classes.
|
io.keikaiex.formula.fn |
ZK EL functions implementation that realize Keikai Spreadsheet formula functions.
|
org.zkoss.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.zkoss.poi.ss.formula.atp | |
org.zkoss.poi.ss.formula.eval | |
org.zkoss.poi.ss.formula.functions |
Modifier and Type | Method and Description |
---|---|
static EvaluationResult |
FormulaEngineImpl.convertToEvaluationResult(ValueEval value) |
protected static io.keikai.model.impl.sys.formula.FormulaEngineImpl.ResultValueEval |
FormulaEngineImpl.getResolvedValue(ValueEval value) |
Modifier and Type | Method and Description |
---|---|
static double |
EngineeringFunctionImpl.engineeringBesseli(double x,
int n) |
static int |
MathFunctionImpl.gcd(int m,
int n)
Returns the greatest common divisor
|
static Complex[] |
EngineeringFunctionImpl.toComplexArray(ValueEval[] args,
int srcCellRow,
int srcCellCol)
Convert an object array to a complex array
|
Modifier and Type | Method and Description |
---|---|
static List<Double> |
AreaEvalHelper.toDoubleList(ValueEval valueEval,
int srcRowIndex,
int srcColumnIndex) |
static double[][] |
AreaEvalHelper.toDoubleMatrix(ValueEval valueEval,
int relativeRowIndex,
int relativeColumnIndex) |
Modifier and Type | Method and Description |
---|---|
static Calendar |
DateParser.parseDate(String strVal)
Parses a date from a string.
|
Modifier and Type | Method and Description |
---|---|
static EvaluationException |
EvaluationException.invalidRef()
#REF! - Illegal or deleted cell reference
|
static EvaluationException |
EvaluationException.invalidValue()
#VALUE! - Wrong type of operand
|
static EvaluationException |
EvaluationException.numberError()
#NUM! - Value range overflow
|
Modifier and Type | Method and Description |
---|---|
static ValueEval |
OperandResolver.chooseMultipleElementsFromArea(AreaEval ae,
int srcCellRow,
int srcCellCol) |
static ValueEval |
OperandResolver.chooseSingleElementFromArea(AreaEval ae,
int srcCellRow,
int srcCellCol)
Implements (some perhaps not well known) Excel functionality to select a single cell from an
area depending on the coordinates of the calling cell.
|
static Boolean |
OperandResolver.coerceValueToBoolean(ValueEval ve,
boolean stringsAreBlanks) |
static double |
OperandResolver.coerceValueToDouble(ValueEval ev)
Applies some conversion rules if the supplied value is not already a number.
|
static int |
OperandResolver.coerceValueToInt(ValueEval ev)
Applies some conversion rules if the supplied value is not already an integer.
Value is first coerced to a double ( See coerceValueToDouble() ). |
static long |
OperandResolver.coerceValueToLong(ValueEval ev)
Applies some conversion rules if the supplied value is not already a long integer.
Value is first coerced to a double ( See coerceValueToDouble() ). |
protected abstract double |
TwoOperandNumericOperation.evaluate(double d0,
double d1) |
static ValueEval |
OperandResolver.getMultipleValue(ValueEval arg,
int srcCellRow,
int srcCellCol) |
static ValueEval |
OperandResolver.getSingleValue(ValueEval arg,
int srcCellRow,
int srcCellCol)
Retrieves a single value from a variety of different argument types according to standard
Excel rules.
|
protected double |
TwoOperandNumericOperation.singleOperandEvaluate(ValueEval arg,
int srcCellRow,
int srcCellCol) |
Modifier and Type | Method and Description |
---|---|
static double |
NumericFunctionHelper.checkValue(double result) |
static void |
NumericFunction.checkValue(double result) |
static int |
UtilFns.dsm(Date settle,
Date maturi,
int basis) |
protected abstract double |
NumericFunction.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
protected double |
NumericFunction.OneArg.eval(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
protected abstract double |
NumericFunction.OneArg.evaluate(double d) |
protected abstract double |
MultiOperandNumericFunction.evaluate(double[] values) |
static double |
Mode.evaluate(double[] v)
if v is zero length or contains no duplicates, return value is
Double.NaN.
|
protected double |
FinanceFunction.evaluate(double[] ds) |
protected abstract double |
NumericFunction.TwoArg.evaluate(double d0,
double d1) |
protected abstract double |
FinanceFunction.evaluate(double rate,
double arg1,
double arg2,
double arg3,
boolean type) |
static double |
TextFunctionHelper.evaluateDoubleArg(ValueEval eval,
int srcCellRow,
int srcCellCol) |
protected static double |
TextFunction.evaluateDoubleArg(ValueEval arg,
int srcCellRow,
int srcCellCol) |
static boolean |
IfFunc.evaluateFirstArg(ValueEval arg,
int srcCellRow,
int srcCellCol) |
static int |
Choose.evaluateFirstArg(ValueEval arg0,
int srcRowIndex,
int srcColumnIndex) |
protected abstract ValueEval |
TextFunction.evaluateFunc(ValueEval[] args,
int srcCellRow,
int srcCellCol) |
static int |
TextFunctionHelper.evaluateIntArg(ValueEval eval,
int srcCellRow,
int srcCellCol) |
protected static int |
TextFunction.evaluateIntArg(ValueEval arg,
int srcCellRow,
int srcCellCol) |
static String |
TextFunctionHelper.evaluateStringArg(ValueEval eval,
int srcCellRow,
int srcCellCol) |
protected static String |
TextFunction.evaluateStringArg(ValueEval eval,
int srcRow,
int srcCol) |
protected double[] |
MultiOperandNumericFunction.getNumberArray(ValueEval[] operands)
Returns a double array that contains values for the numeric cells
from among the list of operands.
|
static org.apache.commons.math.stat.regression.SimpleRegression |
UtilFns.getRegre(double[] xs,
double[] ys)
Return a commons math Regression class
|
static String |
UtilFns.padZero(String num,
int places) |
protected static double |
NumericFunction.singleOperandEvaluate(ValueEval arg,
int srcRowIndex,
int srcColumnIndex) |
protected static boolean |
NumericFunction.singleOperandEvaluateToBoolean(ValueEval arg,
int srcRowIndex,
int srcColumnIndex) |
static boolean |
UtilFns.stringToBoolean(ValueEval arg) |
static Date |
UtilFns.stringToDate(ValueEval arg)
Convert a String to Date
|
static Double |
UtilFns.stringToDouble(String str,
boolean nullable)
Convert a string to double
|
static double[] |
UtilFns.toDoubleArray(List ls)
Convert a list to a double array
|
static double[] |
UtilFns.toDoubleArray(Object[] objs)
Convert an object array to a double array
|
static double[][] |
UtilFns.toDoubleMatrix(ValueEval arg,
int srcRowIndex,
int srcColumnIndex) |
static int[] |
UtilFns.toIntArray(Object[] objs)
Convert an object array to an int array
|
static List |
UtilFns.toList(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
static Complex |
UtilFns.validateComplex(String complex)
Validate given String value, return associated complex.
|
Copyright © 2020. All rights reserved.