src/java/org/apache/poi/hssf/record/formula/functions/Mina.java

   1 /*
   2 * Licensed to the Apache Software Foundation (ASF) under one or more
   3 * contributor license agreements.  See the NOTICE file distributed with
   4 * this work for additional information regarding copyright ownership.
   5 * The ASF licenses this file to You under the Apache License, Version 2.0
   6 * (the "License"); you may not use this file except in compliance with
   7 * the License.  You may obtain a copy of the License at
   8 *
   9 *     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 package org.apache.poi.hssf.record.formula.functions;
  19
  20 import org.apache.poi.hssf.record.formula.eval.ErrorEval;
  21 import org.apache.poi.hssf.record.formula.eval.Eval;
  22 import org.apache.poi.hssf.record.formula.eval.NumberEval;
  23 import org.apache.poi.hssf.record.formula.eval.ValueEval;
  24 import org.apache.poi.hssf.record.formula.eval.ValueEvalToNumericXlator;
  25
  26 /**
  27  * @author Amol S. Deshmukh &lt; amolweb at ya hoo dot com &gt;
  28  *
  29  */
  30 public class Mina extends MultiOperandNumericFunction {
  31     private static final ValueEvalToNumericXlator DEFAULT_NUM_XLATOR =
  32         new ValueEvalToNumericXlator((short) (
  33                   ValueEvalToNumericXlator.BOOL_IS_PARSED
  34                 | ValueEvalToNumericXlator.REF_BOOL_IS_PARSED
  35                 | ValueEvalToNumericXlator.STRING_IS_PARSED
  36               //| ValueEvalToNumericXlator.REF_STRING_IS_PARSED
  37               //| ValueEvalToNumericXlator.EVALUATED_REF_STRING_IS_PARSED
  38               //| ValueEvalToNumericXlator.STRING_TO_BOOL_IS_PARSED
  39               //| ValueEvalToNumericXlator.REF_STRING_TO_BOOL_IS_PARSED
  40                 | ValueEvalToNumericXlator.STRING_IS_INVALID_VALUE
  41               //| ValueEvalToNumericXlator.REF_STRING_IS_INVALID_VALUE
  42                 | ValueEvalToNumericXlator.REF_BLANK_IS_PARSED
  43                 | ValueEvalToNumericXlator.BLANK_IS_PARSED
  44                 ));
  45
  46     protected ValueEvalToNumericXlator getXlator() {
  47         return DEFAULT_NUM_XLATOR;
  48     }
  49
  50
  51     public Eval evaluate(Eval[] operands, int srcCellRow, short srcCellCol) {
  52         ValueEval retval = null;
  53         double[] values = getNumberArray(operands, srcCellRow, srcCellCol);
  54         if (values == null) {
  55             retval = ErrorEval.VALUE_INVALID;
  56         }
  57         else {
  58             double d = values.length > 0 ? MathX.min(values) : 0;
  59             retval = (Double.isNaN(d) || Double.isInfinite(d))
  60                     ? (ValueEval) ErrorEval.NUM_ERROR
  61                     : new NumberEval(d);
  62         }
  63
  64         return retval;
  65     }
  66 }