Package org.boris.expr.function.excel

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

20
21
22
23
24
25
26
27
28
29
30
import org.boris.expr.function.excel.VLOOKUP;

public class ExcelLookupAndReferenceFunctionsTest extends TH
{
    public void testADDRESS() throws Exception {
        ADDRESS a = new ADDRESS();
        assertEquals(eval(a, 1, 1, 2, 0, "Sheet "), "\'Sheet \'!R1C[1]");
        assertEquals(eval(a, 2, 3), "$C$2");
        assertEquals(eval(a, 2, 3, 2), "C$2");
        assertEquals(eval(a, 2, 3, 2, false), "R2C[3]");
        assertEquals(eval(a, 2, 3, 1, false, "EXCEL SHEET"),
View Full Code Here
TOP

Related Classes of org.boris.expr.function.excel.ADDRESS

  • org.boris.expr.ExcelLookupAndReferenceFunctionsTest
  • org.boris.expr.ExprString
  • 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.