Package org.boris.expr.function

Examples of org.boris.expr.function.AbstractFunction

369
370
371
372
373
374
375
376
377
378
379
    public void testSUM() throws Exception {
        assertResult("sum(34,45)", 79.);
    }

    public void testSUMIF() throws Exception {
        AbstractFunction s = new SUMIF();
        assertEquals(eval(s, toArray(1, 2, 3), ">2"), 3.);
        assertEquals(eval(s, toArray(1.658, 1.656, 1.657), "<1.657"), 1.656);
        assertEquals(eval(s, toArray(1, 2, 3), "<=2"), 3.);
        assertEquals(eval(s, toArray(1, 2, 3), ">=2"), 5.);
        assertEquals(eval(s, toArray("apples", 2, 3), "apples", toArray(4.5)),
View Full Code Here
171
172
173
174
175
176
177
178
179
180
181
        assertResult(c, "COUNTIF(A1:A5,\"apples\")", 2.);
        assertResult(c, "COUNTIF(B2:B5,\">55\")", 2.);
    }

    public void testCOVAR() throws Exception {
        AbstractFunction c = new COVAR();
        assertEquals(
                eval(c, toArray(3, 2, 4, 5, 6), toArray(9, 7, 12, 15, 17)), 5.2);
        assertEquals(eval(c, toArray(3, ExprMissing.MISSING, 4, 5, 6), toArray(
                9, 7, 12, 15, 17)), 3.375);
    }
View Full Code Here
TOP

Related Classes of org.boris.expr.function.AbstractFunction

  • org.boris.expr.ExcelMathAndTrigFunctionsTest
  • org.boris.expr.ExcelStatisticalFunctionsTest
  • org.boris.expr.Expr
  • org.boris.expr.ExprArray
  • org.boris.expr.ExprException
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.