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

Example 16 with ErrorEval

use of org.apache.poi.ss.formula.eval.ErrorEval in project poi by apache.

the class BaseXSSFFormulaEvaluator method evaluateFormulaCellValue.

/**
     * Returns a CellValue wrapper around the supplied ValueEval instance.
     */
protected CellValue evaluateFormulaCellValue(Cell cell) {
    EvaluationCell evalCell = toEvaluationCell(cell);
    ValueEval eval = _bookEvaluator.evaluate(evalCell);
    if (eval instanceof NumberEval) {
        NumberEval ne = (NumberEval) eval;
        return new CellValue(ne.getNumberValue());
    }
    if (eval instanceof BoolEval) {
        BoolEval be = (BoolEval) eval;
        return CellValue.valueOf(be.getBooleanValue());
    }
    if (eval instanceof StringEval) {
        StringEval ne = (StringEval) eval;
        return new CellValue(ne.getStringValue());
    }
    if (eval instanceof ErrorEval) {
        return CellValue.getError(((ErrorEval) eval).getErrorCode());
    }
    throw new RuntimeException("Unexpected eval class (" + eval.getClass().getName() + ")");
}

Example 17 with ErrorEval

use of org.apache.poi.ss.formula.eval.ErrorEval in project poi by apache.

the class T method evaluate.

public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) {
    ValueEval arg = arg0;
    if (arg instanceof RefEval) {
        // always use the first sheet
        RefEval re = (RefEval) arg;
        arg = re.getInnerValueEval(re.getFirstSheetIndex());
    } else if (arg instanceof AreaEval) {
        // when the arg is an area, choose the top left cell
        arg = ((AreaEval) arg).getRelativeValue(0, 0);
    }
    if (arg instanceof StringEval) {
        // Text values are returned unmodified
        return arg;
    }
    if (arg instanceof ErrorEval) {
        // Error values also returned unmodified
        return arg;
    }
    // for all other argument types the result is empty string
    return StringEval.EMPTY_INSTANCE;
}