FileDocCategorySizeDatePackage
AddEval.javaAPI DocApache Poi 3.0.13373Sun Mar 11 12:59:28 GMT 2007org.apache.poi.hssf.record.formula.eval

AddEval

public class AddEval extends NumericOperationEval
author
Amol S. Deshmukh < amolweb at ya hoo dot com > This is a documentation of the observed behaviour of the '+' operator in Excel:
  1. 1+TRUE = 2
  2. 1+FALSE = 1
  3. 1+"true" = #VALUE!
  4. 1+"1" = 2
  5. 1+A1 = #VALUE if A1 contains "1"
  6. 1+A1 = 2 if A1 contains ="1"
  7. 1+A1 = 2 if A1 contains TRUE or =TRUE
  8. 1+A1 = #VALUE! if A1 contains "TRUE" or ="TRUE"

Fields Summary
private AddPtg
delegate
private static final ValueEvalToNumericXlator
NUM_XLATOR
Constructors Summary
public AddEval(Ptg ptg)


       
        delegate = (AddPtg) ptg;
Methods Summary
public Evalevaluate(Eval[] operands, int srcRow, short srcCol)

        Eval retval = null;
        double d = 0;
        switch (operands.length) {
        default: // will rarely happen. currently the parser itself fails.
            retval = ErrorEval.UNKNOWN_ERROR;
            break;
        case 2:
            for (int i = 0, iSize = 2; retval==null && i < iSize; i++) {
                ValueEval ve = singleOperandEvaluate(operands[i], srcRow, srcCol);
                if (ve instanceof NumericValueEval) {
                    d += ((NumericValueEval) ve).getNumberValue();
                }
                else if (ve instanceof BlankEval) {
                    // do nothing
                }
                else {
                    retval = ErrorEval.VALUE_INVALID;
                }
            } // end for inside case
        } // end switch
        
        if (retval == null) {
            retval = Double.isNaN(d) ? (ValueEval) ErrorEval.VALUE_INVALID : new NumberEval(d);
        }

        return retval;
public intgetNumberOfOperands()

        return delegate.getNumberOfOperands();
public intgetType()

        return delegate.getType();
public ValueEvalToNumericXlatorgetXlator()

        return NUM_XLATOR;