Package org.apache.poi.hssf.record.formula.functions.LookupUtils

Examples of org.apache.poi.hssf.record.formula.functions.LookupUtils.ValueVector

94
95
96
97
98
99
100
101
102
103
104
    // Note - Excel does not strictly require -1 and +1
    boolean findLargestLessThanOrEqual = match_type > 0;

    try {
      ValueEval lookupValue = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex);
      ValueVector lookupRange = evaluateLookupRange(arg1);
      int index = findIndexOfValue(lookupValue, lookupRange, matchExact, findLargestLessThanOrEqual);
      return new NumberEval(index + 1); // +1 to convert to 1-based
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
    if (eval instanceof RefEval) {
      RefEval re = (RefEval) eval;
      return new SingleValueVector(re.getInnerValueEval());
    }
    if (eval instanceof AreaEval) {
      ValueVector result = LookupUtils.createVector((AreaEval)eval);
      if (result == null) {
        throw new EvaluationException(ErrorEval.NA);
      }
      return result;
    }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
      ValueEval lookupValue = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex);
      AreaEval tableArray = LookupUtils.resolveTableArrayArg(arg1);
      boolean isRangeLookup = LookupUtils.resolveRangeLookupArg(arg3, srcRowIndex, srcColumnIndex);
      int colIndex = LookupUtils.lookupIndexOfValue(lookupValue, LookupUtils.createRowVector(tableArray, 0), isRangeLookup);
      int rowIndex = LookupUtils.resolveRowOrColIndexArg(arg2, srcRowIndex, srcColumnIndex);
      ValueVector resultCol = createResultColumnVector(tableArray, rowIndex);
      return resultCol.getItem(colIndex);
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
  }
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
      ValueEval lookupValue = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex);
      AreaEval tableArray = LookupUtils.resolveTableArrayArg(arg1);
      boolean isRangeLookup = LookupUtils.resolveRangeLookupArg(arg3, srcRowIndex, srcColumnIndex);
      int rowIndex = LookupUtils.lookupIndexOfValue(lookupValue, LookupUtils.createColumnVector(tableArray, 0), isRangeLookup);
      int colIndex = LookupUtils.resolveRowOrColIndexArg(arg2, srcRowIndex, srcColumnIndex);
      ValueVector resultCol = createResultColumnVector(tableArray, colIndex);
      return resultCol.getItem(rowIndex);
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
  }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
    try {
      ValueEval lookupValue = OperandResolver.getSingleValue(arg0, srcRowIndex, srcColumnIndex);
      AreaEval aeLookupVector = LookupUtils.resolveTableArrayArg(arg1);
      AreaEval aeResultVector = LookupUtils.resolveTableArrayArg(arg2);

      ValueVector lookupVector = createVector(aeLookupVector);
      ValueVector resultVector = createVector(aeResultVector);
      if(lookupVector.getSize() > resultVector.getSize()) {
        // Excel seems to handle this by accessing past the end of the result vector.
        throw new RuntimeException("Lookup vector and result vector of differing sizes not supported yet");
      }
      int index = LookupUtils.lookupIndexOfValue(lookupValue, lookupVector, true);

      return resultVector.getItem(index);
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
  }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
      return e.getErrorEval();
    }
  }

  private static ValueVector createVector(AreaEval ae) {
    ValueVector result = LookupUtils.createVector(ae);
    if (result != null) {
      return result;
    }
    // extra complexity required to emulate the way LOOKUP can handles these abnormal cases.
    throw new RuntimeException("non-vector lookup or result areas not supported yet");
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
109
110
  public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) {

    double result;
    try {
      ValueVector vvX = createValueVector(arg0);
      ValueVector vvY = createValueVector(arg1);
      int size = vvX.getSize();
      if (size == 0 || vvY.getSize() != size) {
        return ErrorEval.NA;
      }
      result = evaluateInternal(vvX, vvY, size);
    } catch (EvaluationException e) {
      return e.getErrorEval();
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
113
114
115
      return ErrorEval.VALUE_INVALID;
    }

    double result;
    try {
      ValueVector vvX = createValueVector(args[0]);
      ValueVector vvY = createValueVector(args[1]);
      int size = vvX.getSize();
      if (size == 0 || vvY.getSize() != size) {
        return ErrorEval.NA;
      }
      result = evaluateInternal(vvX, vvY, size);
    } catch (EvaluationException e) {
      return e.getErrorEval();
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
    boolean findLargestLessThanOrEqual = match_type > 0;


    try {
      ValueEval lookupValue = OperandResolver.getSingleValue(args[0], srcCellRow, srcCellCol);
      ValueVector lookupRange = evaluateLookupRange(args[1]);
      int index = findIndexOfValue(lookupValue, lookupRange, matchExact, findLargestLessThanOrEqual);
      return new NumberEval(index + 1); // +1 to convert to 1-based
    } catch (EvaluationException e) {
      return e.getErrorEval();
    }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
    if (eval instanceof RefEval) {
      RefEval re = (RefEval) eval;
      return new SingleValueVector(re.getInnerValueEval());
    }
    if (eval instanceof AreaEval) {
      ValueVector result = LookupUtils.createVector((AreaEval)eval);
      if (result == null) {
        throw new EvaluationException(ErrorEval.NA);
      }
      return result;
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.formula.functions.LookupUtils.ValueVector

  • org.apache.poi.hssf.record.formula.functions.Hlookup
  • org.apache.poi.hssf.record.formula.functions.Lookup
  • org.apache.poi.hssf.record.formula.functions.Match
  • org.apache.poi.hssf.record.formula.functions.Vlookup
  • org.apache.poi.hssf.record.formula.functions.XYNumericFunction
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.