org.apache.poi.ss.formula.functions

ElementMissed InstructionsCov.Missed BranchesCov.MissedCxtyMissedLinesMissedMethodsMissedClasses
Total67,572 of 68,1680%3,332 of 3,3320%3,6883,78612,36212,4931,9782,076348413
TestMathX4,6810%20%2929657657282811
TestStatsLib2,2410%20%1313198198121211
TestCountFuncs1,5620%220%3737276276262611
TestSubtotal1,5300%100%2323337337181811
TestSumifs1,3420%n/a1818141141181811
TestFinanceLib1,0000%n/a771571577711
TestMatch9870%20%1515103103141411
TestText9600%40%2525160160232311
TestIndirect8890%20%1414151151131311
TestSumif8750%20%17179999161611
LookupUtils8740%1640%105105225225222211
Trend8450%1290%75751671679911
TestIndex7990%200%2626150150161611
TestDays3607670%40%13137777111111
TestIrr7120%60%101087877711
TestRelationalOperations6940%240%181879796611
TestSumproduct6540%n/a12127070121211
TestDec2Hex6370%20%2222121121212111
TestDec2Bin6360%20%2323117117222211
DStarRunner6360%1300%8080176176121211
TestMirr5950%20%991041048811
NumericFunction5850%700%5757126126222211
TestDGet5800%20%11117171101011
MathX4920%640%59599999272711
Roman4800%280%191940405511
BaseTestFunctionsFromSpreadsheet4590%540%37371001007711
TestEOMonth4460%20%12126464111111
TestVar4310%n/a7764647711
TestStdev4310%n/a7764647711
TestOrFunction4220%n/a10106969101011
TestFrequency4120%40%5532323311
TestRate4040%20%11117575101011
TestDProduct4030%20%5534344411
Indirect3950%610%38381111117711
TestEDate3930%n/a11116060111111
TestDVar3870%n/a4431314411
TestDStdev3860%n/a4431314411
ArrayFunction3820%340%21211061064411
TestDCount3740%n/a3331313311
PercentRank3720%600%363678786611
MultiOperandNumericFunction3690%700%47478989121211
TestDCountA3640%n/a3329293311
TestIntercept3620%20%13135555121211
IfFunc3600%420%27271071076611
TestDAverage3540%n/a3325253311
Sumproduct3530%620%393990908811
TestCorrel3480%n/a9957579911
TestWeekdayFunc3450%n/a7752527711
TestSlope3300%20%12124747111111
TestNumericFunction3280%n/a9971719911
TestAverageA3260%n/a7750507711
TestMid3240%n/a8836368811
TestAverageIf3140%n/a8843438811
TestSum3130%n/a7741417711
TestXYNumericFunction3120%20%12125656111111
StatsLib3060%480%333362629911
TestGeomean3050%n/a14145050141411
Match3030%520%343474748811
TestTime3020%n/a6657576611
TestWeekNumFunc2960%n/a9946469911
TestSubstitute2940%n/a6637376611
Value2860%710%464697977711
ArrayFunctionUtils2780%440%262666664411
TestGcd2780%40%111138389911
Rate2770%260%191955556611
Baseifs2741%460%282957585601
TestCovar2740%n/a7750507711
TestFixed2730%40%8856566611
TestDateValue2710%n/a8849498811
EvalFactory.MockAreaEval2670%360%262648488811
Mode2580%400%252557575511
TestConcat2540%40%101045458811
LinearRegressionFunction2500%400%242460604411
Countif2470%490%333365658811
NumberValueFunction2461%240%141559602301
Rank2450%500%323258587711
TestMinifs2430%n/a7723237711
TestMaxifs2430%n/a7723237711
Days3602420%160%161643438811
BooleanFunction2410%380%282861619911
TestTrunc2380%n/a9931319911
TestPercentRank2310%n/a5540405511
TestLcm2310%40%111135359911
Index2220%360%282851519911
TestNormDist2210%n/a10103737101011
FinanceLib2180%220%161634345511
FinanceFunction2150%180%181843437711
TestTDist2100%n/a10104040101011
TestNormInv2090%n/a10103838101011
TestBin2Dec2050%n/a11114343111111
TestValue2020%n/a8868688811
TestTFunc1990%n/a12125555121211
TestCalendarFieldFunction1990%n/a7753537711
Complex1973%340%212346484601
TestLogicalFunction1970%n/a5542425511
TestRowCol1950%n/a7741417711
TestHex2Dec1940%n/a11114141111111
Offset1900%290%202036365511
TestTimeValue1880%n/a10104343101011
TestTDistRt1870%n/a11113939111111
TestStandardize1870%n/a10103333101011
Sumif1860%200%181844448811
MatrixFunction1840%300%212130306611
TestPoissonDist1830%n/a4429294411
Countif.StringMatcher1820%360%252554544411
TestAverage1800%n/a7721217711
TestSheet1780%60%6630303311
TestDollarDe1760%n/a11114343111111
TestTDist2t1730%n/a10103636101011
TestNpv1730%20%5542424411
TestAverageifs1720%n/a7724247711
Mirr1700%200%141429294411
TestProduct1690%n/a7731317711
MatrixFunction.TwoArrayArg1690%80%6642422211
Subtotal1690%350%313146463311
WeekNum16710538%260%161841533501
Countif.CmpOp1670%390%34344444101011
XYNumericFunction1660%340%212148484411
Bin2Dec1644%140%111343454601
Finance1640%20%13131414121211
TestRoundFuncs1630%n/a11113636111111
Substitute1600%120%111145455511
Irr1560%160%131337375511
BaseNumberUtils1550%320%191930303311
TestClean1530%40%5519193311
TextFunction1526931%100%121331487801
TestDollarFr1520%n/a11113939111111
TestSqrtpi1510%40%111131319911
TestTDistLt1510%n/a10103232101011
DStarRunner.DStarAlgorithmEnum1490%n/a3317173311
Dec2Hex1488%220%141637413501
Fixed1450%80%111130306611
FloorMath1443%260%151627282301
CeilingMath1443%260%151627282301
TestRank1430%40%4425252211
Forecast1413%120%91031323401
TestQuotient1390%n/a7728287711
TestComplex1390%n/a6625256611
Address1390%190%131336362211
Dec2Bin1375%240%151735373501
DollarDe1365%160%111335373501
TDist1360%180%161633337711
MatrixFunction.OneArrayArg1360%60%5529292211
TestPoisson1350%n/a8840408811
DollarFr1345%160%111335373501
TestForecast1330%n/a3318183311
TestPmt1330%40%9921217711
TestOffset1300%n/a4431314411
DateFunc1290%320%202031314411
Lookup1270%120%111128285511
CountUtils1260%260%161632323311
TestTrim1260%n/a8828288811
Lcm1259%160%101226292401
Gcd1249%160%101224272401
TestFloorMath1240%n/a4429294411
TestBesselJ1240%n/a9930309911
TestCeilingMath1240%n/a4429294411
LookupUtils.CompareResult1240%220%21213838101011
TestDate1230%n/a7734347711
TestAddress1230%n/a3335353311
TDistLt1226%120%121429316801
WeekdayFunc1180%220%131327272211
TestDays1180%n/a6625256611
AverageIf1156%160%121425274601
TestNormSInv1140%n/a10103333101011
TextFunction.new Fixed2ArgFunction() {...}1132%180%111235362301
TestCeiling1130%n/a5527275511
TestCeilingPrecise1120%n/a4427274411
Frequency1120%40%7716165511
TestFloor1120%n/a5527275511
NormDist1114%140%111226274501
AggregateFunction1090%n/a4428284411
Poisson1086%120%101229314601
AggregateFunction.Percentile1070%120%8827272211
TestFloorPrecise1060%n/a4426264411
Imaginary1059%180%111328322401
NormInv1044%140%111225264501
TestFind1030%n/a3324243311
TestNumberValue1000%n/a4425254411
BaseTestNumeric1000%200%141415154411
TestNper980%n/a3320203311
NumericFunctionInvoker970%120%101021214411
Standardize970%100%101024245511
EDate957%160%101227292401
TestNormSDist940%n/a8824248811
CalendarFieldFunction940%100%101027274411
Offset.BaseRef890%20%8823237711
Count880%120%121224246611
EOMonth858%60%4620221301
Counta830%100%111122226611
TestDelta830%n/a6620206611
Offset.LinearOffsetRange830%100%111115156611
TextFunction.SearchFind826%60%6720233401
Sheet818%100%6821231301
TestAbs810%n/a3320203311
TestAreas810%n/a3321213311
TestOct2Dec810%n/a6621216611
ImReal809%100%7919212401
Single805%180%101118191201
Days805%20%6721225601
MatrixFunction.Mdeterm790%60%6614143311
Replace790%100%7717172211
TestMultiOperandNumericFunction790%n/a4414144411
EvalFactory790%60%7713134411
TestLen780%n/a7720207711
TimeFunc780%100%9916164411
TDist2t769%100%81020223501
CeilingPrecise766%100%7817182301
FloorPrecise766%100%7817182301
LogicalFunction760%20%6619195511
Countif.NumberMatcher720%150%111123233311
BesselJ7010%80%7919213501
TestLeftRight700%n/a6613136611
FactDouble6914%100%81017203501
TDistRt6810%80%7918203501
Countif.BooleanMatcher670%160%121220204411
Vlookup670%20%6618185511
DoubleList660%40%8815156611
Log660%80%7714143311
AggregateFunction.LargeSmall650%60%5520202211
TestCode650%n/a6617176611
TimeValue640%40%6619194411
AverageIf.new Baseifs.Aggregator() {...}640%40%55993311
DStarRunner.operator640%n/a11771111
Averageifs.new Baseifs.Aggregator() {...}640%40%55993311
Hlookup630%20%6615155511
TestIsBlank630%n/a2218182211
PPMT620%20%3314142211
IPMT620%20%3314142211
NormSInv617%80%7814153401
Delta6023%80%7915193501
TextFunction.new Fixed3ArgFunction() {...}594%60%4517181201
LookupUtils.SearchMode590%n/a33993311
MatrixFunction.new MatrixFunction.TwoArrayArg() {...}590%40%5513133311
LookupUtils.MatchMode590%n/a33993311
Quotient5812%40%4616182401
LookupUtils.StringLookupComparer580%60%7715154411
NormSDist578%60%6714153401
DStdevp570%40%5512123311
DStdev570%40%5512123311
Rept570%40%4417172211
DVar570%40%5512123311
DVarp570%40%5512123311
DGet560%120%9918183311
MultiOperandNumericFunction.ConsumerFactory560%40%14141818111111
MatrixFunction.new MatrixFunction.OneArrayArg() {...}550%60%6610103311
LookupUtils.ColumnVector550%60%6612123311
Covar5423%20%3512172401
Sqrtpi5412%60%6812143501
LookupUtils.RowVector540%60%6612123311
Countblank540%100%9910104411
TextFunction.new TextFunction.SingleArgTextFunc() {...}535%60%45891201
TextFunction.LeftRight5218%40%4612162401
Choose510%80%7714143311
RowFunc490%80%6611112211
Column490%80%6611112211
DAverage490%40%7710105511
Errortype490%80%101015153311
TestWorkdayFunc480%n/a2212122211
TestIPMT460%n/a2211112211
TestPPMT460%n/a2211112211
Minifs.new Baseifs.Aggregator() {...}440%80%77773311
Maxifs.new Baseifs.Aggregator() {...}440%80%77773311
Npv440%20%3312122211
Hex2Dec4315%40%4611132401
LookupUtils.BinarySearchIndexes430%40%7714145511
TextFunction.new TextFunction.SingleArgTextFunc() {...}426%60%56672301
AggregateFunction.Geomean400%40%44772211
DMax0%80%7712123311
DMin0%80%7712123311
Var3or4ArgFunction0%30%44552211
LookupUtils.LookupValueComparerBase0%60%6612123311
DateValue0%40%5512123311
Correl0%n/a2210102211
LookupUtils.SheetVector0%20%44993311
T0%80%6612122211
LookupUtils.ValueVector.new Iterator() {...}0%40%55663311
DProduct0%40%55993311
Areas0%40%4411112211
LookupUtils.ValueVector.new Iterator() {...}0%40%55553311
TestErrors0%n/a22992211
MultiOperandNumericFunction.Policy0%n/a11111111
Today0%20%3310102211
EvalFactory.MockRefEval0%n/a44884411
XYNumericFunction.AreaValueArray0%n/a22772211
LookupUtils.BooleanLookupComparer0%40%5511113311
Countif.ErrorMatcher0%20%55994411
Code0%20%3310102211
LinearRegressionFunction.AreaValueArray0%n/a22772211
Oct2Dec21%20%35792401
Var2or3ArgFunction9%30%34451201
Countif.MatcherBase0%n/a55775511
Sumifs.new Baseifs.Aggregator() {...}0%20%44553311
XYNumericFunction.ValueArray0%40%55773311
MatrixFunction.new MatrixFunction.OneArrayArg() {...}0%n/a33553311
LinearRegressionFunction.ValueArray0%40%55773311
TextFunction.new Fixed1ArgFunction() {...}10%40%34781201
RefEvalImplementation0%n/a8810108811
DSum0%20%44773311
LinearRegressionFunction.RefValueArray0%n/a22662211
XYNumericFunction.RefValueArray0%n/a22662211
Columns0%40%44772211
Rows0%40%44772211
Var1or2ArgFunction11%30%34451201
LinearRegressionFunction.FUNCTION0%n/a11111111
LookupUtils.TolerantStringLookupComparer0%20%44773311
Fixed4ArgFunction11%20%23341201
DCount0%20%55664411
NotImplementedFunction0%n/a44884411
DCountA0%20%55664411
LookupUtils.NumberLookupComparer0%n/a33663311
Countifs.new Baseifs.Aggregator() {...}0%n/a33553311
Fixed3ArgFunction13%20%23341201
TextFunction.new Fixed2ArgFunction() {...}13%n/a12671201
Count.new CountUtils.I_MatchAreaPredicate() {...}0%40%55333311
Counta.new CountUtils.I_MatchAreaPredicate() {...}0%40%55333311
AggregateFunction.ValueCollector0%n/a44554411
AggregateFunction.new AggregateFunction() {...}0%n/a44444411
Now0%20%33552211
Match.SingleValueVector0%20%44773311
Fixed2ArgFunction15%20%23341201
Slope0%n/a22442211
Intercept0%n/a22442211
Sumxmy20%n/a44554411
LogicalFunction.new Fixed1ArgFunction() {...}0%60%55442211
Count.new CountUtils.I_MatchAreaPredicate() {...}0%20%44333311
Counta.new CountUtils.I_MatchAreaPredicate() {...}0%20%44333311
Sumx2my20%n/a44334411
Sumx2py20%n/a44334411
LogicalFunction.new LogicalFunction() {...}0%40%44442211
AggregateFunction.new AggregateFunction() {...}0%20%33442211
AggregateFunction.new AggregateFunction() {...}0%20%33442211
AggregateFunction.new AggregateFunction.AggregateFunctionA() {...}0%20%33442211
AggregateFunction.new AggregateFunction.AggregateFunctionA() {...}0%20%33442211
AggregateFunction.new AggregateFunction.AggregateFunctionA() {...}0%20%33442211
AggregateFunction.new AggregateFunction.AggregateFunctionA() {...}0%20%33442211
AggregateFunction.new AggregateFunction() {...}0%20%33442211
AggregateFunction.new AggregateFunction() {...}0%20%33442211
AggregateFunction.new AggregateFunction.AggregateFunctionA() {...}0%20%33442211
AggregateFunction.new AggregateFunction() {...}0%20%33442211
Fixed1ArgFunction17%20%23341201
TextFunction.SingleArgTextFunc17%n/a12571201
MatrixFunction.MutableValueCollector0%n/a33443311
MinaMaxa0%n/a22442211
BooleanFunction.new BooleanFunction() {...}0%40%55333311
BooleanFunction.new BooleanFunction() {...}0%40%55333311
Trend.TrendResults0%n/a11551111
TestMultiOperandNumericFunction.Stub0%n/a22442211
AggregateFunction.new AggregateFunction() {...}0%20%33222211
AggregateFunction.new AggregateFunction() {...}0%20%33222211
MinaMaxa.new MinaMaxa() {...}0%20%33222211
MinaMaxa.new MinaMaxa() {...}0%20%33222211
LookupUtils.ValueVector0%n/a22222211
LinearRegressionFunction.SingleCellValueArray0%n/a22442211
TestMultiOperandNumericFunction.new MultiOperandNumericFunction() {...}0%n/a22222211
LogicalFunction.new LogicalFunction() {...}0%20%33222211
Na0%20%33222211
LogicalFunction.new LogicalFunction() {...}0%20%33222211
FinanceFunction.new FinanceFunction() {...}0%n/a22222211
FinanceFunction.new FinanceFunction() {...}0%n/a22222211
FinanceFunction.new FinanceFunction() {...}0%n/a22222211
FinanceFunction.new FinanceFunction() {...}0%n/a22222211
XYNumericFunction.SingleCellValueArray0%n/a22442211
TextFunction.new TextFunction.SingleArgTextFunc() {...}25%n/a12121201
AggregateFunction.Product0%n/a22442211
Maxifs53%n/a24242401
Averageifs53%n/a24242401
Minifs53%n/a24242401
Countifs53%n/a24242401
Sumifs53%n/a24242401
TextFunction.new TextFunction.SingleArgTextFunc() {...}30%n/a12121201
TextFunction.new TextFunction.SingleArgTextFunc() {...}30%n/a12121201
TextFunction.new TextFunction.SingleArgTextFunc() {...}30%n/a12121201
TestLogicalFunctionsFromSpreadsheet0%n/a22222211
TestMatchFunctionsFromSpreadsheet0%n/a22222211
TestFixedFunctionsFromSpreadsheet0%n/a22222211
TestDeltaFunctionsFromSpreadsheet0%n/a22222211
TestIfnaFromSpreadsheet0%n/a22222211
TestWeekNumFunctionsFromSpreadsheet20130%n/a22222211
TestComplexFunctionsFromSpreadsheet0%n/a22222211
TestImaginaryFunctionsFromSpreadsheet0%n/a22222211
TestLookupFunctionsFromSpreadsheet0%n/a22222211
TestDStarFunctionsFromSpreadsheet0%n/a22222211
TestIndirectFunctionFromSpreadsheet0%n/a22222211
TestIFFunctionFromSpreadsheet0%n/a22222211
TestDateTimeToNumberFromSpreadsheet0%n/a22222211
Hyperlink0%n/a33333311
TestReptFunctionsFromSpreadsheet0%n/a22222211
TestRomanFunctionsFromSpreadsheet0%n/a22222211
TestBooleanFunctionsFromSpreadsheet0%n/a22222211
TestFactDoubleFunctionsFromSpreadsheet0%n/a22222211
TestTrendFunctionsFromSpreadsheet0%n/a22222211
TestCodeFunctionsFromSpreadsheet0%n/a22222211
TestQuotientFunctionsFromSpreadsheet0%n/a22222211
TestImRealFunctionsFromSpreadsheet0%n/a22222211
TestIndexFunctionFromSpreadsheet0%n/a22222211
TestDGetFunctionsFromSpreadsheet0%n/a22222211
TestTwoOperandNumericFunctionsFromSpreadsheet0%n/a22222211
TestWeekNumFunctionsFromSpreadsheet0%n/a22222211
LogicalFunction.new LogicalFunction() {...}0%n/a22222211
LogicalFunction.new LogicalFunction() {...}0%n/a22222211
LogicalFunction.new LogicalFunction() {...}0%n/a22222211
LogicalFunction.new LogicalFunction() {...}0%n/a22222211
LogicalFunction.new LogicalFunction() {...}0%n/a22222211
AggregateFunction.new AggregateFunction() {...}0%n/a22222211
AggregateFunction.new AggregateFunction() {...}0%n/a22222211
AggregateFunction.AggregateFunctionA0%n/a22332211
TestEDate.new ValueEval() {...}0%n/a11111111
AggregateFunction.new AggregateFunction() {...}0%n/a22222211
AggregateFunction.new AggregateFunction() {...}0%n/a22222211
AggregateFunction.new AggregateFunction() {...}0%n/a22222211
NumericFunctionInvoker.NumericEvalEx0%n/a11221111
IDStarAlgorithm0%n/a11111111