@Override public ValueEval getResult() { return new NumberEval(totalValue); } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { int result; if (arg0 instanceof TwoDEval) { result = ((TwoDEval) arg0).getHeight(); } else if (arg0 instanceof RefEval) { result = 1; } else { // anything else is not valid argument return ErrorEval.VALUE_INVALID; } return new NumberEval(result); } }
public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) { switch (args.length) { case 1: return evaluate(srcRowIndex, srcColumnIndex, args[0]); case 0: return new NumberEval(srcColumnIndex+1); } return ErrorEval.VALUE_INVALID; } }
public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) { switch (args.length) { case 1: return evaluate(srcRowIndex, srcColumnIndex, args[0]); case 0: return new NumberEval(srcRowIndex+1); } return ErrorEval.VALUE_INVALID; } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { int result; if (arg0 instanceof TwoDEval) { result = ((TwoDEval) arg0).getWidth(); } else if (arg0 instanceof RefEval) { result = 1; } else { // anything else is not valid argument return ErrorEval.VALUE_INVALID; } return new NumberEval(result); } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex) { Date now = new Date(System.currentTimeMillis()); return new NumberEval(DateUtil.getExcelDate(now)); } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex) { Calendar now = LocaleUtil.getLocaleCalendar(); now.clear(Calendar.HOUR); now.set(Calendar.HOUR_OF_DAY,0); now.clear(Calendar.MINUTE); now.clear(Calendar.SECOND); now.clear(Calendar.MILLISECOND); return new NumberEval(DateUtil.getExcelDate(now.getTime())); } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { double result; if (arg0 instanceof RefEval) { result = CountUtils.countMatchingCellsInRef((RefEval) arg0, predicate); } else if (arg0 instanceof ThreeDEval) { result = CountUtils.countMatchingCellsInArea((ThreeDEval) arg0, predicate); } else { throw new IllegalArgumentException("Bad range arg type (" + arg0.getClass().getName() + ")"); } return new NumberEval(result); }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE) { int number; try { number = OperandResolver.coerceValueToInt(numberVE); } catch (EvaluationException e) { return ErrorEval.VALUE_INVALID; } if (number < 0) { return ErrorEval.NUM_ERROR; } return new NumberEval(factorial(number).longValue()); }
@Override public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) { I_MatchPredicate mp = createCriteriaPredicate(arg1, srcRowIndex, srcColumnIndex); if(mp == null) { // If the criteria arg is a reference to a blank cell, countif always returns zero. return NumberEval.ZERO; } double result = countMatchingCellsInArea(arg0, mp); return new NumberEval(result); } /**
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE) { String octal = OperandResolver.coerceValueToString(numberVE); try { return new NumberEval(BaseNumberUtils.convertToDecimal(octal, OCTAL_BASE, MAX_NUMBER_OF_PLACES)); } catch (IllegalArgumentException e) { return ErrorEval.NUM_ERROR; } }
public final ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol) { double d; try { double[] values = getNumberArray(args); d = evaluate(values); } catch (EvaluationException e) { return e.getErrorEval(); } if (Double.isNaN(d) || Double.isInfinite(d)) return ErrorEval.NUM_ERROR; return new NumberEval(d); }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { double result; try { double d0 = NumericFunction.singleOperandEvaluate(arg0, srcRowIndex, srcColumnIndex); result = Math.log(d0) / LOG_10_TO_BASE_e; NumericFunction.checkValue(result); } catch (EvaluationException e) { return e.getErrorEval(); } return new NumberEval(result); } public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0,
public final ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol) { double result; try { result = eval(args, srcCellRow, srcCellCol); checkValue(result); } catch (EvaluationException e) { return e.getErrorEval(); } return new NumberEval(result); }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { try { OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex); return ErrorEval.NA; } catch (EvaluationException e) { int result = translateErrorCodeToErrorTypeValue(e.getErrorEval().getErrorCode()); return new NumberEval(result); } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) { try { double d0 = NumericFunction.singleOperandEvaluate(arg0, srcRowIndex, srcColumnIndex); double d1 = NumericFunction.singleOperandEvaluate(arg1, srcRowIndex, srcColumnIndex); return new NumberEval(evaluate(d0, d1, false)); } catch (EvaluationException e) { return e.getErrorEval(); } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { double result; try { double d = singleOperandEvaluate(arg0, srcRowIndex, srcColumnIndex); result = evaluate(d); checkValue(result); } catch (EvaluationException e) { return e.getErrorEval(); } return new NumberEval(result); } protected final double eval(ValueEval[] args, int srcCellRow, int srcCellCol) throws EvaluationException {
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) { try { double d0 = NumericFunction.singleOperandEvaluate(arg0, srcRowIndex, srcColumnIndex); double d1 = NumericFunction.singleOperandEvaluate(arg1, srcRowIndex, srcColumnIndex); ValueEval ve = OperandResolver.getSingleValue(arg2, srcRowIndex, srcColumnIndex); Boolean method = OperandResolver.coerceValueToBoolean(ve, false); return new NumberEval(evaluate(d0, d1, method != null && method.booleanValue())); } catch (EvaluationException e) { return e.getErrorEval(); } }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) { double result; try { result = evaluate(evalArg(arg0, srcRowIndex, srcColumnIndex), evalArg(arg1, srcRowIndex, srcColumnIndex), evalArg(arg2, srcRowIndex, srcColumnIndex)); } catch (EvaluationException e) { return e.getErrorEval(); } return new NumberEval(result); } private static int evalArg(ValueEval arg, int srcRowIndex, int srcColumnIndex) throws EvaluationException {
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) { double result; try { double d0 = singleOperandEvaluate(arg0, srcRowIndex, srcColumnIndex); double d1 = singleOperandEvaluate(arg1, srcRowIndex, srcColumnIndex); result = evaluate(d0, d1); checkValue(result); } catch (EvaluationException e) { return e.getErrorEval(); } return new NumberEval(result); }