FileDocCategorySizeDatePackage
Exact.javaAPI DocApache Poi 3.0.12965Sun Mar 11 12:59:30 GMT 2007org.apache.poi.hssf.record.formula.functions

Exact

public class Exact extends TextFunction
author
Amol S. Deshmukh < amolweb at ya hoo dot com >

Fields Summary
Constructors Summary
Methods Summary
public org.apache.poi.hssf.record.formula.eval.Evalevaluate(org.apache.poi.hssf.record.formula.eval.Eval[] operands, int srcCellRow, short srcCellCol)

        ValueEval retval = null;
        String s0 = null;
        String s1 = null;
        
        switch (operands.length) {
        default:
            retval = ErrorEval.VALUE_INVALID;
            break;
        case 2:
            ValueEval ve = singleOperandEvaluate(operands[0], srcCellRow, srcCellCol);
            if (ve instanceof StringValueEval) {
                StringValueEval sve = (StringValueEval) ve;
                s0 = sve.getStringValue();
            }
            else if (ve instanceof BlankEval) {
                s0 = StringEval.EMPTY_INSTANCE.getStringValue();
            }
            else {
                retval = ErrorEval.VALUE_INVALID;
                break;
            }

            if (retval == null) {
                ve = singleOperandEvaluate(operands[1], srcCellRow, srcCellCol);
                if (ve instanceof StringValueEval) {
                    StringValueEval sve = (StringValueEval) ve;
                    s1 = sve.getStringValue();
                }
                else if (ve instanceof BlankEval) {
                    s1 = StringEval.EMPTY_INSTANCE.getStringValue();
                }
                else {
                    retval = ErrorEval.VALUE_INVALID;
                    break;
                }
            }
        }
        
        if (retval == null) {
            boolean b = s0.equals(s1);
            retval = b ? BoolEval.TRUE : BoolEval.FALSE;
        }
        
        return retval;