Uses of Interface
org.apache.poi.ss.formula.eval.ValueEval
-
Packages that use ValueEval Package Description io.keikai.model.impl Keikai Spreadsheet Internal Book Model Implementation classes.io.keikai.model.impl.sys.formula Keikai Spreadsheet Internal Book Model Implementation classes.io.keikai.model.sys.formula Keikai Spreadsheet Internal Book Model Engines classes.io.keikaiex.formula Classes bridging Keikai Spreadsheet formula functions to ZK EL functions.io.keikaiex.formula.fn ZK EL functions implementation that realize Keikai Spreadsheet formula functions.org.apache.poi.ss.formula This package contains common internal POI code for manipulating formulas.org.apache.poi.ss.formula.atp org.apache.poi.ss.formula.eval org.apache.poi.ss.formula.eval.forked org.apache.poi.ss.formula.functions -
-
Uses of ValueEval in io.keikai.model.impl
Methods in io.keikai.model.impl that return ValueEval Modifier and Type Method Description abstract ValueEvalAbstractDataValidationAdv. getValueEval1()ValueEvalDataValidationImpl. getValueEval1()abstract ValueEvalAbstractDataValidationAdv. getValueEval2()ValueEvalDataValidationImpl. getValueEval2()Methods in io.keikai.model.impl with parameters of type ValueEval Modifier and Type Method Description abstract voidAbstractCellAdv. setFormulaResultValue(ValueEval value)voidCellImpl. setFormulaResultValue(ValueEval value) -
Uses of ValueEval in io.keikai.model.impl.sys.formula
Methods in io.keikai.model.impl.sys.formula that return ValueEval Modifier and Type Method Description ValueEvalFormulaEngineImpl.EvaluationResultImpl. getValueEval()ValueEvalDependencyTrackerImpl. postProcessValueEval(OperationEvaluationContext ec, ValueEval opResult, boolean eval)Methods in io.keikai.model.impl.sys.formula with parameters of type ValueEval Modifier and Type Method Description static EvaluationResultFormulaEngineImpl. convertToEvaluationResult(ValueEval value)protected static io.keikai.model.impl.sys.formula.FormulaEngineImpl.ResultValueEvalFormulaEngineImpl. getResolvedValue(ValueEval value)ValueEvalDependencyTrackerImpl. postProcessValueEval(OperationEvaluationContext ec, ValueEval opResult, boolean eval)voidDependencyTrackerImpl. setIndirectRefPrecedent(OperationEvaluationContext ec, ValueEval preRef)voidDependencyTrackerImpl. setOffsetRefPrecedent(OperationEvaluationContext ec, ValueEval preRef)Constructors in io.keikai.model.impl.sys.formula with parameters of type ValueEval Constructor Description EvaluationResultImpl(EvaluationResult.ResultType type, Object value, ValueEval valueEval) -
Uses of ValueEval in io.keikai.model.sys.formula
Methods in io.keikai.model.sys.formula that return ValueEval Modifier and Type Method Description ValueEvalEvaluationResult. getValueEval() -
Uses of ValueEval in io.keikaiex.formula
Methods in io.keikaiex.formula that return ValueEval Modifier and Type Method Description ValueEvalELEval. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalELEvalFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalELEvalFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDependencyTrackerEx. postProcessValueEval(OperationEvaluationContext ec, ValueEval opResult, boolean eval)Methods in io.keikaiex.formula with parameters of type ValueEval Modifier and Type Method Description ValueEvalELEval. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalELEvalFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalELEvalFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDependencyTrackerEx. postProcessValueEval(OperationEvaluationContext ec, ValueEval opResult, boolean eval) -
Uses of ValueEval in io.keikaiex.formula.fn
Methods in io.keikaiex.formula.fn that return ValueEval Modifier and Type Method Description static ValueEvalFinancialFns. accrint(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. accrintm(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. amordegrc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. amorlinc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. averagea(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. besseli(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. besselj(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. besselk(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bessely(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. beta$dist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. betadist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. betainv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bin2dec(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bin2hex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bin2oct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. binomdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. binominv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalInfoFns. cell(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chidist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chiinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chisqdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chisqinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. code(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. complex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. correl(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupdaybs(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupdays(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupdaysnc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupncd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupnum(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. couppcd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. cumipmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. cumprinc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. datedIf(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. dateValue(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. db(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. ddb(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. dec2bin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. dec2hex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. dec2oct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. delta(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. disc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. dollarde(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. dollarfr(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. duration(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. effect(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. eomonth(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. erf(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. erfc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLookupAndReferenceFunctionImpl.Unique. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLookupAndReferenceFunctionImpl.Unique. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. expondist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. factdouble(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. fdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. finv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. fixed(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. fvschedule(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. gammadist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. gammainv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. gammaln(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. gcd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. geomean(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. gestep(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. harmean(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. hex2bin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. hex2dec(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. hex2oct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. hour(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. hypgeomdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalLogicalFns. iferror(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imabs(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imaginary(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imargument(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imconjugate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imcos(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imdiv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imexp(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imln(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imlog10(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imlog2(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. impower(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. improduct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imreal(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsqrt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsub(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsum(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. intercept(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. intrate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. ipmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalInfoFns. iserr(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. kurt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. lcm(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. leftB(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. linest(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. lognormdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. lognorminv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. mdeterm(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. minute(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. minverse(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. mmult(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. modesngl(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. mround(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. multinomial(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalInfoFns. n(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. negbinomdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. nominal(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. normdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. norminv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. normsdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. normsinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. npv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. oct2bin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. oct2dec(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. oct2hex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. poisson(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. poissoninv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. ppmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. price(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. pricedisc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. pricemat(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. proper(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. quotient(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. randbetween(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. rankeq(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. received(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. replace(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. replaceB(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. rept(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. roman(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. second(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. skew(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. sln(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. slope(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. sqrtpi(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. stdev(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. stdevp(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. substitute(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. syd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. tbilleq(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. tbillprice(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. tbillyield(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tdist2t(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tdistrt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. textChar(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalInfoFns. type(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalLookupAndReferenceFns. unique(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. value(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. var(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. varp(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. weekDay(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. weibull(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. xnpv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. yield(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. yielddisc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. yieldmat(ValueEval[] args, int srcRowIndex, int srcColumnIndex)Methods in io.keikaiex.formula.fn with parameters of type ValueEval Modifier and Type Method Description static ValueEvalFinancialFns. accrint(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. accrintm(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. amordegrc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. amorlinc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. averagea(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. besseli(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. besselj(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. besselk(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bessely(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. beta$dist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. betadist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. betainv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bin2dec(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bin2hex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. bin2oct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. binomdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. binominv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalInfoFns. cell(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chidist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chiinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chisqdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. chisqinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. code(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. complex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. correl(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupdaybs(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupdays(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupdaysnc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupncd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. coupnum(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. couppcd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. cumipmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. cumprinc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. datedIf(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. dateValue(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. db(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. ddb(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. dec2bin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. dec2hex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. dec2oct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. delta(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. disc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. dollarde(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. dollarfr(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. duration(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. effect(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. eomonth(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. erf(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. erfc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLookupAndReferenceFunctionImpl.Unique. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLookupAndReferenceFunctionImpl.Unique. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. expondist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. factdouble(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. fdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. finv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. fixed(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. fvschedule(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. gammadist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. gammainv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. gammaln(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. gcd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. geomean(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. gestep(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. harmean(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. hex2bin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. hex2dec(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. hex2oct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. hour(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. hypgeomdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalLogicalFns. iferror(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imabs(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imaginary(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imargument(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imconjugate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imcos(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imdiv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imexp(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imln(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imlog10(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imlog2(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. impower(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. improduct(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imreal(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsqrt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsub(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. imsum(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. intercept(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. intrate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. ipmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalInfoFns. iserr(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. kurt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. lcm(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. leftB(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. linest(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. lognormdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. lognorminv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. mdeterm(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. minute(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. minverse(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. mmult(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. modesngl(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. mround(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. multinomial(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalInfoFns. n(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. negbinomdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. nominal(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. normdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. norminv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. normsdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. normsinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. npv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. oct2bin(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. oct2dec(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalEngineeringFns. oct2hex(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. poisson(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. poissoninv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. ppmt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. price(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. pricedisc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. pricemat(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. proper(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. quotient(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. randbetween(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. rankeq(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. received(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. replace(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. replaceB(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. rept(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. roman(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. second(ValueEval[] args, int srcRowIndex, int srcColumnIndex)protected static booleanStatFunctionImpl. singleOperandEvaluateToBoolean(ValueEval arg, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. skew(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. sln(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. slope(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalMathFns. sqrtpi(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. stdev(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. stdevp(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. substitute(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. syd(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. tbilleq(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. tbillprice(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. tbillyield(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tdist(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tdist2t(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tdistrt(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. textChar(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. tinv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ComplexEx[]EngineeringFunctionImpl. toComplexArray(ValueEval[] args, int srcCellRow, int srcCellCol)Convert an object array to a complex arraystatic ValueEvalInfoFns. type(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalLookupAndReferenceFns. unique(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalTextFns. value(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. var(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. varp(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalDateTimeFns. weekDay(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalStatFns. weibull(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. xnpv(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. yield(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. yielddisc(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalFinancialFns. yieldmat(ValueEval[] args, int srcRowIndex, int srcColumnIndex) -
Uses of ValueEval in org.apache.poi.ss.formula
Subinterfaces of ValueEval in org.apache.poi.ss.formula Modifier and Type Interface Description interfaceThreeDEvalOptional Extension to the likes ofAreaEvalandAreaEvalBase, which allows for looking up 3D (sheet+row+column) evaluationsinterfaceTwoDEvalCommon interface ofAreaEvalandAreaEvalBase, for 2D (row+column) evaluationsClasses in org.apache.poi.ss.formula that implement ValueEval Modifier and Type Class Description classCacheAreaEvalProvides holding structure for temporary values in arrays during the evaluation process.classLazyAreaEvalProvides Lazy Evaluation to 3D RangesclassLazyRefEvalProvides Lazy Evaluation to a 3D ReferenceclassNameRangeEvalMethods in org.apache.poi.ss.formula that return ValueEval Modifier and Type Method Description static ValueEvalWorkbookEvaluator. dereferenceResult(ValueEval evaluationResult, int srcRowNum, int srcColNum)Dereferences a single value from any AreaEval or RefEval evaluation result.ValueEvalUserDefinedFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalWorkbookEvaluator. evaluate(String formula, CellReference ref, int[] offset)Evaluate a formula outside a cell value, e.g.ValueEvalWorkbookEvaluator. evaluate(String formula, CellReference target, CellRangeAddressBase region)Some expressions need to be evaluated in terms of an offset from the top left corner of a region, such as some data validation and conditional format expressions, when those constraints apply to contiguous cells.ValueEvalWorkbookEvaluator. evaluate(EvaluationCell srcCell)ValueEvalWorkbookEvaluator. evaluate(EvaluationCell srcCell, Object ref)ValueEvalWorkbookEvaluator. evaluate(EvaluationCell srcCell, Object ref, int[] offset)ValueEvalWorkbookEvaluator. evaluateList(String formula, CellReference target, CellRangeAddressBase region)Some expressions need to be evaluated in terms of an offset from the top left corner of a region, such as some data validation and conditional format expressions, when those constraints apply to contiguous cells.ValueEvalOperationEvaluationContext. getArea3DEval(Area3DPtg aptg)ValueEvalOperationEvaluationContext. getArea3DEval(Area3DPxg aptg)ValueEvalOperationEvaluationContext. getAreaEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, boolean row1Rel, boolean col1Rel, boolean row2Rel, boolean col2Rel)ValueEvalOperationEvaluationContext. getAreaValueEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, Object[][] tokens)ValueEvalOperationEvaluationContext. getDynamicReference(String workbookName, String sheetName, String refStrPart1, String refStrPart2, boolean isA1Style)Resolves a cell or area reference dynamically.ValueEvalSheetRangeEvaluator. getEvalForCell(int sheetIndex, int rowIndex, int columnIndex)ValueEvalLazyRefEval. getInnerValueEval(int sheetIndex)ValueEvalOperationEvaluationContext. getNameXEval(NameXPtg nameXPtg)ValueEvalOperationEvaluationContext. getNameXEval(NameXPxg nameXPxg)ValueEvalOperationEvaluationContext. getRef3DEval(Ref3DPtg rptg)ValueEvalOperationEvaluationContext. getRef3DEval(Ref3DPxg rptg)ValueEvalOperationEvaluationContext. getRefEval(int rowIndex, int columnIndex, boolean rowRel, boolean colRel)static ValueEvalAreaEvalHelper. getRelativeValue(ValueEval valueEval, int relativeRowIndex, int relativeColumnIndex)ValueEvalCacheAreaEval. getRelativeValue(int relativeRowIndex, int relativeColumnIndex)ValueEvalCacheAreaEval. getRelativeValue(int sheetIndex, int relativeRowIndex, int relativeColumnIndex)ValueEvalLazyAreaEval. getRelativeValue(int relativeRowIndex, int relativeColumnIndex)ValueEvalLazyAreaEval. getRelativeValue(int sheetIndex, int relativeRowIndex, int relativeColumnIndex)ValueEvalThreeDEval. getValue(int sheetIndex, int rowIndex, int columnIndex)ValueEvalTwoDEval. getValue(int rowIndex, int columnIndex)ValueEvalDependencyTracker. postProcessValueEval(OperationEvaluationContext ec, ValueEval opResult, boolean eval)Callback when evaluating a formula cell.Methods in org.apache.poi.ss.formula that return types with arguments of type ValueEval Modifier and Type Method Description List<ValueEval>DataValidationEvaluator. getValidationValuesForCell(CellReference cell)IfDataValidationEvaluator.getValidationForCell(CellReference)returns an instance, and theDataValidationConstraint.ValidationTypeisDataValidationConstraint.ValidationType.LIST, return the valid values, whether they are from a static list or cell range.protected static List<ValueEval>DataValidationEvaluator. getValidationValuesForConstraint(DataValidationEvaluator.DataValidationContext context)static so enums can reference it without creating a whole instanceMethods in org.apache.poi.ss.formula with parameters of type ValueEval Modifier and Type Method Description voidOperationEvaluationContext. createOffsetRefPrecedent(ValueEval precedent)static ValueEvalWorkbookEvaluator. dereferenceResult(ValueEval evaluationResult, int srcRowNum, int srcColNum)Dereferences a single value from any AreaEval or RefEval evaluation result.ValueEvalUserDefinedFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)static ValueEvalAreaEvalHelper. getRelativeValue(ValueEval valueEval, int relativeRowIndex, int relativeColumnIndex)voidWorkbookEvaluator.CacheManager. onUpdateCacheResult(EvaluationCell srcCell, ValueEval result)ValueEvalDependencyTracker. postProcessValueEval(OperationEvaluationContext ec, ValueEval opResult, boolean eval)Callback when evaluating a formula cell.voidDependencyTracker. setIndirectRefPrecedent(OperationEvaluationContext ec, ValueEval precedent)Sets precedent for anio.keikai.model.sys.dependency.IndirectRefvoidDependencyTracker. setOffsetRefPrecedent(OperationEvaluationContext ec, ValueEval precedent)Sets precedent for anio.keikai.model.sys.dependency.OffsetRefstatic List<Double>AreaEvalHelper. toDoubleList(ValueEval valueEval, int srcRowIndex, int srcColumnIndex)static double[][]AreaEvalHelper. toDoubleMatrix(ValueEval valueEval, int relativeRowIndex, int relativeColumnIndex)Constructors in org.apache.poi.ss.formula with parameters of type ValueEval Constructor Description CacheAreaEval(int firstRow, int firstColumn, int lastRow, int lastColumn, ValueEval[] values)CacheAreaEval(AreaI ptg, ValueEval[] values) -
Uses of ValueEval in org.apache.poi.ss.formula.atp
Methods in org.apache.poi.ss.formula.atp that return ValueEval Modifier and Type Method Description ValueEvalIfNa. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalStdevp. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalStdevs. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalSwitch. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalVarp. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalVars. evaluate(ValueEval[] args, OperationEvaluationContext ec)Methods in org.apache.poi.ss.formula.atp with parameters of type ValueEval Modifier and Type Method Description ValueEvalIfNa. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalStdevp. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalStdevs. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalSwitch. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalVarp. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalVars. evaluate(ValueEval[] args, OperationEvaluationContext ec) -
Uses of ValueEval in org.apache.poi.ss.formula.eval
Subinterfaces of ValueEval in org.apache.poi.ss.formula.eval Modifier and Type Interface Description interfaceAreaEvalEvaluation of 2D (Row+Column) and 3D (Sheet+Row+Column) areasinterfaceNumericValueEvalinterfaceRefEvalRefEval is the super interface for Ref2D and Ref3DEval.interfaceStringValueEvalClasses in org.apache.poi.ss.formula.eval that implement ValueEval Modifier and Type Class Description classAreaEvalBaseclassArrayEvalConstant value array eval.classBlankEvalThis class is a marker class.classBoolEvalclassErrorEvalEvaluations for formula errorsclassExternalNameEvalEvaluation of a Name defined in a Sheet or Workbook scopeclassFunctionNameEvalclassMissingArgEvalRepresents the (intermediate) evaluated result of a missing function argument.classNumberEvalclassRefEvalBaseCommon base class for implementors ofRefEvalclassRefListEvalHandling of a list of values, e.g.classStringEvalclassUnionEvalRepresent manyValueEvals unioned by Union operator(comma operator).Methods in org.apache.poi.ss.formula.eval that return ValueEval Modifier and Type Method Description static ValueEvalOperandResolver. 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.ValueEvalConcatEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIntersectionEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalPercentEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalRangeEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalRelationalOperationEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)This is a description of how the relational operators apply in MS Excel.ValueEvalTwoOperandNumericOperation. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalUnaryMinusEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalUnaryPlusEval. evaluate(int srcCellRow, int srcCellCol, ValueEval arg0)ValueEvalRelationalOperationEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalTwoOperandNumericOperation. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalUnaryMinusEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalUnaryPlusEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalAreaEval. getAbsoluteValue(int row, int col)ValueEvalAreaEvalBase. getAbsoluteValue(int row, int col)ValueEvalArrayEval. getAbsoluteValue(int row, int col)static ValueEvalOperandResolver. getElementFromArray(AreaEval ae, EvaluationCell cell)Retrieves a single value from an area evaluation utilizing the 2D indices of the cell within its own area reference to index the value in the area evaluation.ValueEvalRefEval. getInnerValueEval(int sheetIndex)ValueEvalArrayEval. getNonEmptyCellValues()ValueEvalAreaEval. getRelativeValue(int relativeRowIndex, int relativeColumnIndex)abstract ValueEvalAreaEvalBase. getRelativeValue(int relativeRowIndex, int relativeColumnIndex)abstract ValueEvalAreaEvalBase. getRelativeValue(int sheetIndex, int relativeRowIndex, int relativeColumnIndex)ValueEvalArrayEval. getRelativeValue(int r, int c)static ValueEvalOperandResolver. getSingleValue(ValueEval arg, int srcCellRow, int srcCellCol)Retrieves a single value from a variety of different argument types according to standard Excel rules.static ValueEvalOperandResolver. getSingleValueInNameFormula(ValueEval arg, int srcCellRow, int srcCellCol)ValueEvalAreaEvalBase. getValue(int row, int col)ValueEvalAreaEvalBase. getValue(int sheetIndex, int row, int col)ValueEvalArrayEval. getValue(int rowIndex, int columnIndex)ValueEvalArrayEval. getValue(int sheetIndex, int rowIndex, int columnIndex)Methods in org.apache.poi.ss.formula.eval that return types with arguments of type ValueEval Modifier and Type Method Description List<ValueEval>RefListEval. getList()Methods in org.apache.poi.ss.formula.eval with parameters of type ValueEval Modifier and Type Method Description static BooleanOperandResolver. coerceValueToBoolean(ValueEval ve, boolean stringsAreBlanks)static doubleOperandResolver. coerceValueToDouble(ValueEval ev)Applies some conversion rules if the supplied value is not already a number.static intOperandResolver. coerceValueToInt(ValueEval ev)Applies some conversion rules if the supplied value is not already an integer.
Value is first coerced to adouble( SeecoerceValueToDouble()).static StringOperandResolver. coerceValueToString(ValueEval ve)ValueEvalConcatEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIntersectionEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalPercentEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalRangeEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalRelationalOperationEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)This is a description of how the relational operators apply in MS Excel.ValueEvalTwoOperandNumericOperation. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalUnaryMinusEval. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalUnaryPlusEval. evaluate(int srcCellRow, int srcCellCol, ValueEval arg0)ValueEvalRelationalOperationEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalTwoOperandNumericOperation. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalUnaryMinusEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalUnaryPlusEval. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalOperandResolver. getSingleValue(ValueEval arg, int srcCellRow, int srcCellCol)Retrieves a single value from a variety of different argument types according to standard Excel rules.static ValueEvalOperandResolver. getSingleValueInNameFormula(ValueEval arg, int srcCellRow, int srcCellCol)protected doubleTwoOperandNumericOperation. singleOperandEvaluate(ValueEval arg, int srcCellRow, int srcCellCol)Constructors in org.apache.poi.ss.formula.eval with parameters of type ValueEval Constructor Description ArrayEval(ValueEval[][] srcvalues, int firstRow, int firstColumn, int lastRow, int lastColumn, SheetRangeEvaluator evaluator)RefListEval(ValueEval v1, ValueEval v2)UnionEval(ValueEval[] evals) -
Uses of ValueEval in org.apache.poi.ss.formula.eval.forked
Methods in org.apache.poi.ss.formula.eval.forked that return ValueEval Modifier and Type Method Description ValueEvalForkedEvaluator. evaluate(String sheetName, int rowIndex, int columnIndex)If cell contains a formula, the formula is evaluated and returned, else the CellValue simply copies the appropriate cell value from the cell and also its cell type.Methods in org.apache.poi.ss.formula.eval.forked with parameters of type ValueEval Modifier and Type Method Description voidForkedEvaluator. updateCell(String sheetName, int rowIndex, int columnIndex, ValueEval value)Sets the specified cell to the suppliedvalue -
Uses of ValueEval in org.apache.poi.ss.formula.functions
Methods in org.apache.poi.ss.formula.functions that return ValueEval Modifier and Type Method Description static ValueEvalArrayFunction. _evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)static ValueEvalArrayFunction. _evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)protected ValueEvalAverageIf. aggregateMatchingCells(org.apache.poi.ss.formula.functions.Baseifs.Aggregator aggregator, AreaEval sumRange, AreaEval testRange, org.apache.poi.ss.formula.functions.CountUtils.I_MatchPredicate mp)ValueEvalAddress. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalAreas. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalAverageIf. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalBesselJ. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalBesselJ. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalBin2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalBin2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalBooleanFunction. evaluate(ValueEval[] args, int srcRow, int srcCol)ValueEvalCalendarFieldFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalCeilingMath. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalCeilingPrecise. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalChoose. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalCode. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval textArg)static ValueEvalColumn. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalColumns. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalComplex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num)ValueEvalComplex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix)ValueEvalComplex. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalCorrel. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalCount. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalCounta. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalCountblank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalCountif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalCovar. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalCovar. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDateFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalDateValue. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTextArg)ValueEvalDays. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDays360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalDays360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalDec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalDec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval placesVE)ValueEvalDec2Bin. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalDec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval number, ValueEval places)ValueEvalDec2Hex. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDelta. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalDelta. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDollarDe. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalDollarDe. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDollarFr. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalDollarFr. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDStarRunner. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval database, ValueEval filterColumn, ValueEval conditionDatabase)ValueEvalDStarRunner. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalEDate. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalEOMonth. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalErrortype. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalFactDouble. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalFactDouble. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalFinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalFinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4)ValueEvalFinanceFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalFixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalFixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalFixed. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed0ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)Deprecated.ValueEvalFixed1ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed1ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex, boolean isArrayValue)ValueEvalFixed2ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed2ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex, boolean isArrayValue)ValueEvalFixed3ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed4ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFloorMath. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFloorPrecise. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalForecast. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalForecast. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFreeRefFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFrequency. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFunction0Arg. evaluate(int srcRowIndex, int srcColumnIndex)Deprecated.ValueEvalFunction1Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalFunction2Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalFunction3Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalFunction4Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalGcd. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalHex2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalHex2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalHlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalHlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalHyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalHyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalImaginary. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)ValueEvalImaginary. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalImReal. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)ValueEvalImReal. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalIndex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIndex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalIndex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalIndex. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalIndirect. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalIntercept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIrr. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLcm. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalLinearRegressionFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)static ValueEvalLog. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLogicalFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalLookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalLookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalMatch. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalMatch. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalMatrixFunction.OneArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalMatrixFunction.TwoArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalMode. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalMultiOperandNumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)static ValueEvalNa. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalNormDist. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4)ValueEvalNormDist. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNormInv. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalNormInv. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNormSDist. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1)ValueEvalNormSDist. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNormSInv. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1)ValueEvalNormSInv. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNotImplementedFunction. evaluate(ValueEval[] operands, int srcRow, int srcCol)static ValueEvalNow. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalNpv. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalNumberValueFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalOct2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalOct2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalOffset. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalOverridableFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalOverridableFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex, boolean isArrayValue)ValueEvalPercentRank. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalPoisson. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalPoisson. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalQuotient. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval venumerator, ValueEval vedenominator)ValueEvalQuotient. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalRank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalRank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalRate. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalReplace. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalRept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval text, ValueEval number_times)ValueEvalRoman. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval formVE)static ValueEvalRowFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalRows. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalSingle. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalSlope. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalSqrtpi. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalStandardize. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalStandardize. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalSubstitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalSubstitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalSubtotal. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalSumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalSumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalSumproduct. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalT. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalTDist. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalTDist. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTDist2t. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalTDist2t. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTDistLt. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalTDistLt. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTDistRt. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalTDistRt. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTextFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalTimeFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalTimeValue. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTimeTextArg)static ValueEvalToday. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalTrend. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalValue. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalVlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalVlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval lookup_value, ValueEval table_array, ValueEval col_index, ValueEval range_lookup)ValueEvalWeekdayFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)Perform WEEKDAY(date, returnOption) function.ValueEvalWeekNum. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE)ValueEvalWeekNum. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalXYNumericFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalArrayFunction. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalBooleanFunction. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalChoose. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)protected ValueEvalFixed2ArgFunction. evaluateArray(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIfFunc. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLogicalFunction. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalValue. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)protected abstract ValueEvalTextFunction. evaluateFunc(ValueEval[] args, int srcCellRow, int srcCellCol)default ValueEvalArrayFunction. evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)default ValueEvalArrayFunction. evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)Evaluate an array function with two arguments.ValueEvalLookupUtils.ValueVector. getItem(int index)ValueEvalDAverage. getResult()ValueEvalDCount. getResult()ValueEvalDCountA. getResult()ValueEvalDGet. getResult()ValueEvalDMax. getResult()ValueEvalDMin. getResult()ValueEvalDProduct. getResult()ValueEvalDStdev. getResult()ValueEvalDStdevp. getResult()ValueEvalDSum. getResult()ValueEvalDVar. getResult()ValueEvalDVarp. getResult()ValueEvalIDStarAlgorithm. getResult()Return a result ValueEval that will be the result of the calculation.Methods in org.apache.poi.ss.formula.functions that return types with arguments of type ValueEval Modifier and Type Method Description static List<ValueEval>PercentRank. getValues(ValueEval eval, int srcRowIndex, int srcColumnIndex)Methods in org.apache.poi.ss.formula.functions with parameters of type ValueEval Modifier and Type Method Description static ValueEvalArrayFunction. _evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)static ValueEvalArrayFunction. _evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)double[]MatrixFunction.MutableValueCollector. collectValues(ValueEval... operands)protected abstract double[]MatrixFunction.OneArrayArg. collectValues(ValueEval arg)protected abstract double[]MatrixFunction.TwoArrayArg. collectValues(ValueEval arg)LookupUtils.CompareResultLookupUtils.LookupValueComparer. compareTo(ValueEval other)doubleIPMT. eval(ValueEval[] args, int srcCellRow, int srcCellCol)protected abstract doubleNumericFunction. eval(ValueEval[] args, int srcCellRow, int srcCellCol)doublePPMT. eval(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalAddress. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalAreas. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalAverageIf. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalBesselJ. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalBesselJ. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalBin2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalBin2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalBooleanFunction. evaluate(ValueEval[] args, int srcRow, int srcCol)ValueEvalCalendarFieldFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalCeilingMath. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalCeilingPrecise. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalChoose. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalCode. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval textArg)static ValueEvalColumn. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalColumns. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalComplex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num)ValueEvalComplex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix)ValueEvalComplex. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalCorrel. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalCount. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalCounta. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalCountblank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalCountif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalCovar. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalCovar. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDateFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalDateValue. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTextArg)ValueEvalDays. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDays360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalDays360. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalDec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalDec2Bin. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval placesVE)ValueEvalDec2Bin. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalDec2Hex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval number, ValueEval places)ValueEvalDec2Hex. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDelta. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalDelta. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDollarDe. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalDollarDe. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDollarFr. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalDollarFr. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalDStarRunner. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval database, ValueEval filterColumn, ValueEval conditionDatabase)ValueEvalDStarRunner. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalEDate. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalEOMonth. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalErrortype. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalFactDouble. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalFactDouble. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalFinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalFinanceFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4)ValueEvalFinanceFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalFixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalFixed. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalFixed. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed0ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)Deprecated.ValueEvalFixed1ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed1ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex, boolean isArrayValue)ValueEvalFixed2ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed2ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex, boolean isArrayValue)ValueEvalFixed3ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFixed4ArgFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFloorMath. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFloorPrecise. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalForecast. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalForecast. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFreeRefFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalFrequency. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalFunction1Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalFunction2Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalFunction3Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalFunction4Arg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalGcd. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalHex2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalHex2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalHlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalHlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalHyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalHyperlink. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIfFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalImaginary. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)ValueEvalImaginary. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalImReal. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval inumberVE)ValueEvalImReal. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalIndex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIndex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalIndex. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalIndex. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalIndirect. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalIntercept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIrr. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLcm. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalLinearRegressionFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)static ValueEvalLog. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLogicalFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)protected abstract booleanLogicalFunction. evaluate(ValueEval arg)ValueEvalLookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalLookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalMatch. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalMatch. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalMatrixFunction.OneArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalMatrixFunction.TwoArrayArg. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalMode. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalMultiOperandNumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)static ValueEvalNa. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalNormDist. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3, ValueEval arg4)ValueEvalNormDist. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNormInv. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalNormInv. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNormSDist. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1)ValueEvalNormSDist. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNormSInv. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1)ValueEvalNormSInv. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNotImplementedFunction. evaluate(ValueEval[] operands, int srcRow, int srcCol)static ValueEvalNow. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalNpv. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalNumberValueFunction. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalNumericFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalOct2Dec. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)ValueEvalOct2Dec. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalOffset. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalOverridableFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalOverridableFunction. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex, boolean isArrayValue)ValueEvalPercentRank. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static ValueEvalPoisson. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalPoisson. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalQuotient. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval venumerator, ValueEval vedenominator)ValueEvalQuotient. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalRank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalRank. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalRate. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalReplace. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalRept. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval text, ValueEval number_times)ValueEvalRoman. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE, ValueEval formVE)static ValueEvalRowFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalRows. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalSingle. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalSlope. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalSqrtpi. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalStandardize. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalStandardize. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalSubstitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalSubstitute. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalSubtotal. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalSumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalSumif. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalSumproduct. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalT. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalTDist. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalTDist. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTDist2t. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalTDist2t. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTDistLt. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2, ValueEval arg3)ValueEvalTDistLt. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTDistRt. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg1, ValueEval arg2)ValueEvalTDistRt. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalTextFunction. evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)ValueEvalTimeFunc. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalTimeValue. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTimeTextArg)static ValueEvalToday. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalTrend. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalValue. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)ValueEvalVlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)ValueEvalVlookup. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval lookup_value, ValueEval table_array, ValueEval col_index, ValueEval range_lookup)ValueEvalWeekdayFunc. evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)Perform WEEKDAY(date, returnOption) function.ValueEvalWeekNum. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE)ValueEvalWeekNum. evaluate(ValueEval[] args, OperationEvaluationContext ec)ValueEvalXYNumericFunction. evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalArrayFunction. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalBooleanFunction. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalChoose. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)protected ValueEvalFixed2ArgFunction. evaluateArray(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)ValueEvalIfFunc. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalLogicalFunction. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)ValueEvalValue. evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)protected static doubleTextFunction. evaluateDoubleArg(ValueEval arg, int srcCellRow, int srcCellCol)static doubleTextFunctionHelper. evaluateDoubleArg(ValueEval eval, int srcCellRow, int srcCellCol)static intChoose. evaluateFirstArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex)static booleanIfFunc. evaluateFirstArg(ValueEval arg, int srcCellRow, int srcCellCol)protected abstract ValueEvalTextFunction. evaluateFunc(ValueEval[] args, int srcCellRow, int srcCellCol)protected static intTextFunction. evaluateIntArg(ValueEval arg, int srcCellRow, int srcCellCol)static intTextFunctionHelper. evaluateIntArg(ValueEval eval, int srcCellRow, int srcCellCol)default ValueEvalArrayFunction. evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)protected static StringTextFunction. evaluateStringArg(ValueEval eval, int srcRow, int srcCol)static StringTextFunctionHelper. evaluateStringArg(ValueEval eval, int srcCellRow, int srcCellCol)default ValueEvalArrayFunction. evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)Evaluate an array function with two arguments.protected double[]MultiOperandNumericFunction. getNumberArray(ValueEval[] operands)Returns a double array that contains values for the numeric cells from among the list of operands.static List<ValueEval>PercentRank. getValues(ValueEval eval, int srcRowIndex, int srcColumnIndex)static intLookupUtils. lookupFirstIndexOfValue(ValueEval lookupValue, LookupUtils.ValueVector vector, boolean isRangeLookup)static intLookupUtils. lookupIndexOfExactValue(ValueEval lookupValue, TwoDEval tableArray, int columnIndex)booleanCountif.ErrorMatcher. matches(ValueEval x)booleanCountif.StringMatcher. matches(ValueEval x)booleanDAverage. processMatch(ValueEval eval)booleanDCount. processMatch(ValueEval eval)booleanDCountA. processMatch(ValueEval eval)booleanDGet. processMatch(ValueEval eval)booleanDMax. processMatch(ValueEval eval)booleanDMin. processMatch(ValueEval eval)booleanDProduct. processMatch(ValueEval eval)booleanDStdev. processMatch(ValueEval eval)booleanDStdevp. processMatch(ValueEval eval)booleanDSum. processMatch(ValueEval eval)booleanDVar. processMatch(ValueEval eval)booleanDVarp. processMatch(ValueEval eval)booleanIDStarAlgorithm. processMatch(ValueEval eval)Process a match that is found during a run through a database.static booleanLookupUtils. resolveRangeLookupArg(ValueEval rangeLookupArg, int srcCellRow, int srcCellCol)Resolves the last (optional) parameter (range_lookup) to the VLOOKUP and HLOOKUP functions.static intLookupUtils. resolveRowOrColIndexArg(ValueEval rowColIndexArg, int srcCellRow, int srcCellCol)Processes the third argument to VLOOKUP, or HLOOKUP (col_index_num or row_index_num respectively).
Sample behaviour: Sample behaviour Input ReturnValue Thrown Error 54 2.92 "5"4 "2.18e1"21 "-$2"-3* FALSE-1* TRUE0 "TRUE" #REF! "abc" #REF! "" #REF! <blank> #VALUE!
Note - out of range errors (result index too high) are handled by the caller.static TwoDEvalLookupUtils. resolveTableArrayArg(ValueEval eval)The second argument (table_array) should be an area ref, but can actually be a cell ref, in which case it is interpreted as a 1x1 area ref.protected doubleMatrixFunction. singleOperandEvaluate(ValueEval arg, int srcCellRow, int srcCellCol)protected static doubleNumericFunction. singleOperandEvaluate(ValueEval arg, int srcRowIndex, int srcColumnIndex)static booleanUtilFns. stringToBoolean(ValueEval arg)static DateUtilFns. stringToDate(ValueEval arg)Convert a String to Datestatic double[][]UtilFns. toDoubleMatrix(ValueEval arg, int srcRowIndex, int srcColumnIndex)static ListUtilFns. toList(ValueEval[] args, int srcRowIndex, int srcColumnIndex)static intLookupUtils. xlookupIndexOfValue(ValueEval lookupValue, LookupUtils.ValueVector vector, LookupUtils.MatchMode matchMode, LookupUtils.SearchMode searchMode)Method parameters in org.apache.poi.ss.formula.functions with type arguments of type ValueEval Modifier and Type Method Description static ValueEvalArrayFunction. _evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)static ValueEvalArrayFunction. _evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)static ValueEvalArrayFunction. _evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)static ValueEvalArrayFunction. _evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)static ValueEvalArrayFunction. _evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)default ValueEvalArrayFunction. evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)default ValueEvalArrayFunction. evaluateOneArrayArg(ValueEval arg0, int srcRowIndex, int srcColumnIndex, Function<ValueEval,ValueEval> evalFunc)default ValueEvalArrayFunction. evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)Evaluate an array function with two arguments.default ValueEvalArrayFunction. evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)Evaluate an array function with two arguments.default ValueEvalArrayFunction. evaluateTwoArrayArgs(ValueEval arg0, ValueEval arg1, int srcRowIndex, int srcColumnIndex, BiFunction<ValueEval,ValueEval,ValueEval> evalFunc)Evaluate an array function with two arguments.
-