public final ValueEval evaluate(ValueEval[] args, int srcRow, int srcCol) { if (args.length < 1) { return ErrorEval.VALUE_INVALID; } boolean boolResult; try { boolResult = calculate(args); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(boolResult); }
private ValueEval convertObjectEval(Object token) { if (token == null) { throw new RuntimeException("Array item cannot be null"); } if (token instanceof String) { return new StringEval((String)token); } if (token instanceof Double) { return new NumberEval(((Double)token).doubleValue()); } if (token instanceof Boolean) { return BoolEval.valueOf(((Boolean)token).booleanValue()); } if (token instanceof ErrorConstant) { return ErrorEval.valueOf(((ErrorConstant)token).getErrorCode()); } throw new IllegalArgumentException("Unexpected constant class (" + token.getClass().getName() + ")"); }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { boolean boolArgVal; try { ValueEval ve = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex); Boolean b = OperandResolver.coerceValueToBoolean(ve, false); boolArgVal = b == null ? false : b.booleanValue(); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(!boolArgVal); } };
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) { String s0; String s1; try { s0 = evaluateStringArg(arg0, srcRowIndex, srcColumnIndex); s1 = evaluateStringArg(arg1, srcRowIndex, srcColumnIndex); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(s0.equals(s1)); } };
@SuppressWarnings("unused") public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { ValueEval ve; try { ve = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex); } catch (EvaluationException e) { // Note - it is more usual to propagate error codes straight to the result like this: // but logical functions behave a little differently // return e.getErrorEval(); // this will usually cause a 'FALSE' result except for ISNONTEXT() ve = e.getErrorEval(); } return BoolEval.valueOf(evaluate(ve)); } /**
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) { if (args.length != 1) { return ErrorEval.VALUE_INVALID; } int val; try { val = evaluateArgParity(args[0], ec.getRowIndex(), ec.getColumnIndex()); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(val == _desiredParity); }
/** * Gets the value from a non-formula cell. * @param cell may be <code>null</code> * @return {@link BlankEval} if cell is <code>null</code> or blank, never <code>null</code> */ /* package */ static ValueEval getValueFromNonFormulaCell(EvaluationCell cell) { if (cell == null) { return BlankEval.instance; } CellType cellType = cell.getCellType(); switch (cellType) { case NUMERIC: return new NumberEval(cell.getNumericCellValue()); case STRING: return new StringEval(cell.getStringCellValue()); case BOOLEAN: return BoolEval.valueOf(cell.getBooleanCellValue()); case BLANK: return BlankEval.instance; case ERROR: return ErrorEval.valueOf(cell.getErrorCellValue()); default: throw new RuntimeException("Unexpected cell type (" + cellType + ")"); } }
return BoolEval.valueOf(result);
return BoolEval.valueOf(cell.getBooleanCellValue()); case ERROR: return ErrorEval.valueOf(cell.getErrorCellValue());
return BoolEval.valueOf(((BoolPtg) ptg).getValue());
int cmpResult = doCompare(vA, vB); boolean result = convertComparisonResult(cmpResult); vals[idx++] = BoolEval.valueOf(result);
break; case BOOLEAN: result = BoolEval.valueOf(srcCell.getBooleanCellValue()); break; case ERROR:
public final ValueEval evaluate(ValueEval[] args, int srcRow, int srcCol) { if (args.length < 1) { return ErrorEval.VALUE_INVALID; } boolean boolResult; try { boolResult = calculate(args); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(boolResult); }
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { boolean boolArgVal; try { ValueEval ve = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex); Boolean b = OperandResolver.coerceValueToBoolean(ve, false); boolArgVal = b == null ? false : b.booleanValue(); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(!boolArgVal); } };
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { boolean boolArgVal; try { ValueEval ve = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex); Boolean b = OperandResolver.coerceValueToBoolean(ve, false); boolArgVal = b == null ? false : b.booleanValue(); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(!boolArgVal); } };
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) { boolean boolArgVal; try { ValueEval ve = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex); Boolean b = OperandResolver.coerceValueToBoolean(ve, false); boolArgVal = b == null ? false : b.booleanValue(); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(!boolArgVal); } };
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) { String s0; String s1; try { s0 = evaluateStringArg(arg0, srcRowIndex, srcColumnIndex); s1 = evaluateStringArg(arg1, srcRowIndex, srcColumnIndex); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(s0.equals(s1)); } };
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) { if (args.length != 1) { return ErrorEval.VALUE_INVALID; } int val; try { val = evaluateArgParity(args[0], ec.getRowIndex(), ec.getColumnIndex()); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(val == _desiredParity); }
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) { if (args.length != 1) { return ErrorEval.VALUE_INVALID; } int val; try { val = evaluateArgParity(args[0], ec.getRowIndex(), ec.getColumnIndex()); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(val == _desiredParity); }
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) { if (args.length != 1) { return ErrorEval.VALUE_INVALID; } int val; try { val = evaluateArgParity(args[0], ec.getRowIndex(), ec.getColumnIndex()); } catch (EvaluationException e) { return e.getErrorEval(); } return BoolEval.valueOf(val == _desiredParity); }