Examples of HLOOKUP


Examples of org.apache.poi.ss.formula.functions.Hlookup

        retval[97] = NumericFunction.ATAN2;
        retval[98] = NumericFunction.ASIN;
        retval[99] = NumericFunction.ACOS;
        retval[ID.CHOOSE] = new Choose();
        retval[101] = new Hlookup();
        retval[102] = new Vlookup();

        retval[105] = LogicalFunction.ISREF;

        retval[109] = NumericFunction.LOG;
View Full Code Here

Examples of org.apache.poi.ss.formula.functions.Hlookup

        retval[97] = NumericFunction.ATAN2;
        retval[98] = NumericFunction.ASIN;
        retval[99] = NumericFunction.ACOS;
        retval[ID.CHOOSE] = new Choose();
        retval[101] = new Hlookup();
        retval[102] = new Vlookup();

        retval[105] = LogicalFunction.ISREF;

        retval[109] = NumericFunction.LOG;
View Full Code Here

Examples of org.boris.expr.function.excel.HLOOKUP

        GETPIVOTDATA g = new GETPIVOTDATA();
        fail("GETPIVOTDATA not implemented");
    }

    public void testHLOOKUP() throws Exception {
        HLOOKUP h = new HLOOKUP();
        assertResult(
                "HLOOKUP(3,{1,2,3;\"a\",\"b\",\"c\";\"d\",\"e\",\"f\"},2,TRUE)",
                "c");
        fail("HLOOKUP not implemented");
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.