Examples of org.apache.poi.ss.formula.eval.EvaluationException

org.apache.poi.ss.formula.eval.EvaluationException
Eval arg0 = args[0]; if(arg0 instanceof ErrorEval) { return arg0; } if(!(arg0 instanceof AreaEval)) { return ErrorEval.VALUE_INVALID; } double temp = 0; AreaEval area = (AreaEval)arg0; ValueEval[] values = area.getValues(); for (int i = 0; i < values.length; i++) { ValueEval ve = values[i]; if(ve instanceof ErrorEval) { return ve; } if(!(ve instanceof NumericValueEval)) { return ErrorEval.VALUE_INVALID; } temp += ((NumericValueEval)ve).getNumberValue(); } // ... } In this example, if any error is encountered while processing the arguments, an error is returned immediately. This code is difficult to refactor due to all the points where errors are returned.
Using EvaluationException allows the error returning code to be consolidated to one place.
```
 public Eval evaluate(Eval[] args, int srcRow, short srcCol) { try { // ... AreaEval area = getAreaArg(args[0]); double temp = sumValues(area.getValues()); // ... } catch (EvaluationException e) { return e.getErrorEval(); } } private static AreaEval getAreaArg(Eval arg0) throws EvaluationException { if (arg0 instanceof ErrorEval) { throw new EvaluationException((ErrorEval) arg0); } if (arg0 instanceof AreaEval) { return (AreaEval) arg0; } throw EvaluationException.invalidValue(); } private double sumValues(ValueEval[] values) throws EvaluationException { double temp = 0; for (int i = 0; i < values.length; i++) { ValueEval ve = values[i]; if (ve instanceof ErrorEval) { throw new EvaluationException((ErrorEval) ve); } if (!(ve instanceof NumericValueEval)) { throw EvaluationException.invalidValue(); } temp += ((NumericValueEval) ve).getNumberValue(); } return temp; } 
```
It is not mandatory to use EvaluationException, doing so might give the following advantages:
- Methods can more easily be extracted, allowing for re-use.
- Type management (typecasting etc) is simpler because error conditions have been separated from intermediate calculation values.
- Fewer local variables are required. Local variables can have stronger types.
- It is easier to mimic common Excel error handling behaviour (exit upon encountering first error), because exceptions conveniently propagate up the call stack regardless of execution points or the number of levels of nested calls.
Note - Only standard evaluation errors are represented by EvaluationException ( i.e. conditions expected to be encountered when evaluating arbitrary Excel formulas). Conditions that could never occur in an Excel spreadsheet should result in runtime exceptions. Care should be taken to not translate any POI internal error into an Excel evaluation error code. @author Josh Micich

    }
  }


  private static ValueVector createValueVector(ValueEval arg) throws EvaluationException {
    if (arg instanceof ErrorEval) {
      throw new EvaluationException((ErrorEval) arg);
    }
    if (arg instanceof TwoDEval) {
      return new AreaValueArray((TwoDEval) arg);
    }
    if (arg instanceof RefEval) {

View Full Code Here

      result = performBinarySearch(vector, lookupComparer);
    } else {
      result = lookupIndexOfExactValue(lookupComparer, vector);
    }
    if(result < 0) {
      throw new EvaluationException(ErrorEval.NA);
    }
    return result;
  }

View Full Code Here

        atleastOneNonBlank = true;
      }
    }


    if (!atleastOneNonBlank) {
      throw new EvaluationException(ErrorEval.VALUE_INVALID);
    }
    return result;
  }

View Full Code Here

      LinearOffsetRange orRow, LinearOffsetRange orCol) throws EvaluationException {
    LinearOffsetRange absRows = orRow.normaliseAndTranslate(baseRef.getFirstRowIndex());
    LinearOffsetRange absCols = orCol.normaliseAndTranslate(baseRef.getFirstColumnIndex());


    if(absRows.isOutOfBounds(0, LAST_VALID_ROW_INDEX)) {
      throw new EvaluationException(ErrorEval.REF_INVALID);
    }
    if(absCols.isOutOfBounds(0, LAST_VALID_COLUMN_INDEX)) {
      throw new EvaluationException(ErrorEval.REF_INVALID);
    }
    return baseRef.offset(orRow.getFirstIndex(), orRow.getLastIndex(), orCol.getFirstIndex(), orCol.getLastIndex());
  }

View Full Code Here

    }
    if(eval instanceof AreaEval) {
      return new BaseRef((AreaEval)eval);
    }
    if (eval instanceof ErrorEval) {
      throw new EvaluationException((ErrorEval) eval);
    }
    throw new EvaluationException(ErrorEval.VALUE_INVALID);
  }

View Full Code Here

     * @throws EvaluationException exception upon parsing.
     */
    public static Calendar parseDate(String strVal) throws EvaluationException {
        String[] parts = Pattern.compile("/").split(strVal);
        if (parts.length != 3) {
            throw new EvaluationException(ErrorEval.VALUE_INVALID);
        }
        String part2 = parts[2];
        int spacePos = part2.indexOf(' ');
        if (spacePos > 0) {
            // drop time portion if present
            part2 = part2.substring(0, spacePos);
        }
        int f0;
        int f1;
        int f2;
        try {
            f0 = Integer.parseInt(parts[0]);
            f1 = Integer.parseInt(parts[1]);
            f2 = Integer.parseInt(part2);
        } catch (NumberFormatException e) {
            throw new EvaluationException(ErrorEval.VALUE_INVALID);
        }
        if (f0 < 0 || f1 < 0 || f2 < 0 || (f0 > 12 && f1 > 12 && f2 > 12)) {
            // easy to see this cannot be a valid date
            throw new EvaluationException(ErrorEval.VALUE_INVALID);
        }


        if (f0 >= 1900 && f0 < 9999) {
            // when 4 digit value appears first, the format is YYYY/MM/DD, regardless of OS settings
            return makeDate(f0, f1, f2);

View Full Code Here

    /**
     * @param month 1-based
     */
    private static Calendar makeDate(int year, int month, int day) throws EvaluationException {
        if (month < 1 || month > 12) {
            throw new EvaluationException(ErrorEval.VALUE_INVALID);
        }
        Calendar cal = new GregorianCalendar(year, month - 1, 1, 0, 0, 0);
        cal.set(Calendar.MILLISECOND, 0);
        if (day < 1 || day > cal.getActualMaximum(Calendar.DAY_OF_MONTH)) {
            throw new EvaluationException(ErrorEval.VALUE_INVALID);
        }
        cal.set(Calendar.DAY_OF_MONTH, day);
        return cal;
    }

View Full Code Here

      } else {
        // all other combinations of value types are silently ignored
      }
    }
    if (firstXerr != null) {
      throw new EvaluationException(firstXerr);
    }
    if (firstYerr != null) {
      throw new EvaluationException(firstYerr);
    }
    if (!accumlatedSome) {
      throw new EvaluationException(ErrorEval.DIV_ZERO);
    }
    return result;
  }

View Full Code Here

    return result;
  }


  private static ValueVector createValueVector(ValueEval arg) throws EvaluationException {
    if (arg instanceof ErrorEval) {
      throw new EvaluationException((ErrorEval) arg);
    }
    if (arg instanceof TwoDEval) {
      return new AreaValueArray((TwoDEval) arg);
    }
    if (arg instanceof RefEval) {

View Full Code Here


  public static double calculate(double pStartDateVal, double pEndDateVal, int basis) throws EvaluationException {


    if (basis < 0 || basis >= 5) {
      // if basis is invalid the result is #NUM!
      throw new EvaluationException(ErrorEval.NUM_ERROR);
    }


    // common logic for all bases


    // truncate day values

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of org.apache.poi.ss.formula.eval.EvaluationException

org.apache.poi.ss.examples.formula.CalculateMortgage

org.apache.poi.ss.examples.formula.CalculateMortgageFunction

org.apache.poi.ss.formula.atp.DateParser

org.apache.poi.ss.formula.atp.YearFrac

org.apache.poi.ss.formula.atp.YearFracCalculator

org.apache.poi.ss.formula.functions.BooleanFunction

org.apache.poi.ss.formula.functions.DateFunc

org.apache.poi.ss.formula.functions.EDate

org.apache.poi.ss.formula.functions.Index

org.apache.poi.ss.formula.functions.IPMT

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.