Examples with OperationEvaluationContext org.apache.poi.ss.formula.OperationEvaluationContext used on opensource projects

Example 16 with OperationEvaluationContext

use of org.apache.poi.ss.formula.OperationEvaluationContext in project poi by apache.

the class TestHex2Dec method testEvalOperationEvaluationContextFails.

public void testEvalOperationEvaluationContextFails() {
    OperationEvaluationContext ctx = createContext();
    ValueEval[] args = new ValueEval[] { ctx.getRefEval(0, 0), ctx.getRefEval(0, 0) };
    ValueEval result = new Hex2Dec().evaluate(args, ctx);
    assertEquals(ErrorEval.class, result.getClass());
    assertEquals(ErrorEval.VALUE_INVALID, result);
}

Example 17 with OperationEvaluationContext

use of org.apache.poi.ss.formula.OperationEvaluationContext in project poi by apache.

the class TestHex2Dec method createContext.

private OperationEvaluationContext createContext() {
    HSSFWorkbook wb = new HSSFWorkbook();
    wb.createSheet();
    HSSFEvaluationWorkbook workbook = HSSFEvaluationWorkbook.create(wb);
    WorkbookEvaluator workbookEvaluator = new WorkbookEvaluator(workbook, new IStabilityClassifier() {

        @Override
        public boolean isCellFinal(int sheetIndex, int rowIndex, int columnIndex) {
            return true;
        }
    }, null);
    OperationEvaluationContext ctx = new OperationEvaluationContext(workbookEvaluator, workbook, 0, 0, 0, null);
    return ctx;
}

Example 18 with OperationEvaluationContext

use of org.apache.poi.ss.formula.OperationEvaluationContext in project poi by apache.

the class TestDec2Hex method testRefs.

public void testRefs() {
    OperationEvaluationContext ctx = createContext();
    ValueEval[] args = new ValueEval[] { ctx.getRefEval(0, 0) };
    ValueEval result = new Dec2Hex().evaluate(args, -1, -1);
    assertEquals("Had: " + result, StringEval.class, result.getClass());
    assertEquals("7B", ((StringEval) result).getStringValue());
}

Example 19 with OperationEvaluationContext

use of org.apache.poi.ss.formula.OperationEvaluationContext in project poi by apache.

the class TestDec2Hex method testWithTooManyParams.

public void testWithTooManyParams() {
    OperationEvaluationContext ctx = createContext();
    ValueEval[] args = new ValueEval[] { ctx.getRefEval(0, 0), ctx.getRefEval(0, 1), ctx.getRefEval(0, 1) };
    ValueEval result = new Dec2Hex().evaluate(args, ctx);
    assertEquals(ErrorEval.class, result.getClass());
    assertEquals(ErrorEval.VALUE_INVALID, result);
}

Example 20 with OperationEvaluationContext

use of org.apache.poi.ss.formula.OperationEvaluationContext in project poi by apache.

the class TestHex2Dec method testRefs.

public void testRefs() {
    OperationEvaluationContext ctx = createContext();
    ValueEval[] args = new ValueEval[] { ctx.getRefEval(0, 0) };
    ValueEval result = new Hex2Dec().evaluate(args, -1, -1);
    assertEquals(NumberEval.class, result.getClass());
    assertEquals("0", ((NumberEval) result).getStringValue());
}