View | Details | Raw Unified | Return to bug 60823
Collapse All | Expand All

(-)a/src/java/org/apache/poi/ss/formula/functions/DGet.java (-3 / +11 lines)
Lines 36-45 public final class DGet implements IDStarAlgorithm { Link Here
36
        {
36
        {
37
            result = eval;
37
            result = eval;
38
        }
38
        }
39
        else // There was a previous match, since there is only exactly one allowed, bail out.
39
        else // There was a previous match. Only one non-blank result is allowed. #NUM! on multiple values.
40
        {
40
        {
41
            result = ErrorEval.NUM_ERROR;
41
            if(result instanceof BlankEval) {
42
            return false;
42
                result = eval;
43
            }
44
            else {
45
                // We have a previous filled result.
46
                if(!(eval instanceof BlankEval)) {
47
                    result = ErrorEval.NUM_ERROR;
48
                    return false;
49
                }
50
            }
43
        }
51
        }
44
52
45
        return true;
53
        return true;

Return to bug 60823