Package org.apache.poi.ss.formula.functions.LookupUtils

Examples of org.apache.poi.ss.formula.functions.LookupUtils.LookupValueComparer.compareTo()

187
188
189
190
191
192
193
194
195
196
197
    LookupValueComparer lookupComparer = createLookupComparer(lookupValue, matchExact);

    int size = lookupRange.getSize();
    if(matchExact) {
      for (int i = 0; i < size; i++) {
        if(lookupComparer.compareTo(lookupRange.getItem(i)).isEqual()) {
          return i;
        }
      }
      throw new EvaluationException(ErrorEval.NA);
    }
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
    }

    if(findLargestLessThanOrEqual) {
      // Note - backward iteration
      for (int i = size - 1; i>=0;  i--) {
        CompareResult cmp = lookupComparer.compareTo(lookupRange.getItem(i));
        if(cmp.isTypeMismatch()) {
          continue;
        }
        if(!cmp.isLessThan()) {
          return i;
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
    }

    // else - find smallest greater than or equal to
    // TODO - is binary search used for (match_type==+1) ?
    for (int i = 0; i<size; i++) {
      CompareResult cmp = lookupComparer.compareTo(lookupRange.getItem(i));
      if(cmp.isEqual()) {
        return i;
      }
      if(cmp.isGreaterThan()) {
        if(i<1) {
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
    LookupValueComparer lookupComparer = createLookupComparer(lookupValue, matchExact);

    int size = lookupRange.getSize();
    if(matchExact) {
      for (int i = 0; i < size; i++) {
        if(lookupComparer.compareTo(lookupRange.getItem(i)).isEqual()) {
          return i;
        }
      }
      throw new EvaluationException(ErrorEval.NA);
    }
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
    }

    if(findLargestLessThanOrEqual) {
      // Note - backward iteration
      for (int i = size - 1; i>=0;  i--) {
        CompareResult cmp = lookupComparer.compareTo(lookupRange.getItem(i));
        if(cmp.isTypeMismatch()) {
          continue;
        }
        if(!cmp.isLessThan()) {
          return i;
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
    }

    // else - find smallest greater than or equal to
    // TODO - is binary search used for (match_type==+1) ?
    for (int i = 0; i<size; i++) {
      CompareResult cmp = lookupComparer.compareTo(lookupRange.getItem(i));
      if(cmp.isEqual()) {
        return i;
      }
      if(cmp.isGreaterThan()) {
        if(i<1) {
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
    LookupValueComparer lookupComparer = createLookupComparer(lookupValue, matchExact);

    int size = lookupRange.getSize();
    if(matchExact) {
      for (int i = 0; i < size; i++) {
        if(lookupComparer.compareTo(lookupRange.getItem(i)).isEqual()) {
          return i;
        }
      }
      throw new EvaluationException(ErrorEval.NA);
    }
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
    }

    if(findLargestLessThanOrEqual) {
      // Note - backward iteration
      for (int i = size - 1; i>=0;  i--) {
        CompareResult cmp = lookupComparer.compareTo(lookupRange.getItem(i));
        if(cmp.isTypeMismatch()) {
          continue;
        }
        if(!cmp.isLessThan()) {
          return i;
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
    }

    // else - find smallest greater than or equal to
    // TODO - is binary search used for (match_type==+1) ?
    for (int i = 0; i<size; i++) {
      CompareResult cmp = lookupComparer.compareTo(lookupRange.getItem(i));
      if(cmp.isEqual()) {
        return i;
      }
      if(cmp.isGreaterThan()) {
        if(i<1) {
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
    LookupValueComparer lookupComparer = createLookupComparer(lookupValue, matchExact);

    int size = lookupRange.getSize();
    if(matchExact) {
      for (int i = 0; i < size; i++) {
        if(lookupComparer.compareTo(lookupRange.getItem(i)).isEqual()) {
          return i;
        }
      }
      throw new EvaluationException(ErrorEval.NA);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.