01: /*
02: * Licensed to the Apache Software Foundation (ASF) under one or more
03: * contributor license agreements. See the NOTICE file distributed with
04: * this work for additional information regarding copyright ownership.
05: * The ASF licenses this file to You under the Apache License, Version 2.0
06: * (the "License"); you may not use this file except in compliance with
07: * the License. You may obtain a copy of the License at
08: *
09: * http://www.apache.org/licenses/LICENSE-2.0
10: *
11: * Unless required by applicable law or agreed to in writing, software
12: * distributed under the License is distributed on an "AS IS" BASIS,
13: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14: * See the License for the specific language governing permissions and
15: * limitations under the License.
16: */
17: /*
18: * Created on May 8, 2005
19: *
20: */
21: package org.apache.poi.hssf.record.formula.eval;
22:
23: import org.apache.poi.hssf.record.formula.Ptg;
24: import org.apache.poi.hssf.record.formula.DividePtg;
25:
26: /**
27: * @author Amol S. Deshmukh < amolweb at ya hoo dot com >
28: *
29: */
30: public class DivideEval extends NumericOperationEval {
31:
32: private DividePtg delegate;
33:
34: private static final ValueEvalToNumericXlator NUM_XLATOR = new ValueEvalToNumericXlator(
35: (short) (ValueEvalToNumericXlator.BOOL_IS_PARSED
36: | ValueEvalToNumericXlator.EVALUATED_REF_BOOL_IS_PARSED
37: | ValueEvalToNumericXlator.EVALUATED_REF_STRING_IS_PARSED
38: | ValueEvalToNumericXlator.REF_BOOL_IS_PARSED
39: | ValueEvalToNumericXlator.STRING_IS_PARSED | ValueEvalToNumericXlator.REF_STRING_IS_PARSED));
40:
41: public DivideEval(Ptg ptg) {
42: delegate = (DividePtg) ptg;
43: }
44:
45: protected ValueEvalToNumericXlator getXlator() {
46: return NUM_XLATOR;
47: }
48:
49: public Eval evaluate(Eval[] operands, int srcRow, short srcCol) {
50: Eval retval = null;
51: double d0 = 0;
52: double d1 = 0;
53: switch (operands.length) {
54: default: // will rarely happen. currently the parser itself fails.
55: retval = ErrorEval.UNKNOWN_ERROR;
56: break;
57: case 2:
58: ValueEval ve = singleOperandEvaluate(operands[0], srcRow,
59: srcCol);
60: if (ve instanceof NumericValueEval) {
61: d0 = ((NumericValueEval) ve).getNumberValue();
62: } else if (ve instanceof BlankEval) {
63: // do nothing
64: } else {
65: retval = ErrorEval.VALUE_INVALID;
66: }
67:
68: if (retval == null) { // no error yet
69: ve = singleOperandEvaluate(operands[1], srcRow, srcCol);
70: if (ve instanceof NumericValueEval) {
71: d1 = ((NumericValueEval) ve).getNumberValue();
72: } else if (ve instanceof BlankEval) {
73: // do nothing
74: } else {
75: retval = ErrorEval.VALUE_INVALID;
76: }
77: }
78: } // end switch
79:
80: if (retval == null) {
81: retval = (d1 == 0) ? ErrorEval.DIV_ZERO
82: : (Double.isNaN(d0) || Double.isNaN(d1)) ? (ValueEval) ErrorEval.VALUE_INVALID
83: : new NumberEval(d0 / d1);
84: }
85: return retval;
86: }
87:
88: public int getNumberOfOperands() {
89: return delegate.getNumberOfOperands();
90: }
91:
92: public int getType() {
93: return delegate.getType();
94: }
95: }
|