Package org.zkoss.poi.ss.formula.eval

Examples of org.zkoss.poi.ss.formula.eval.ArrayEval


    } else {
      String txt = constraint.getFormula1();
      Book book = sheet.getBook();
      final ValueEval ve = BookHelper.evaluateFormulaValueEval(book, book.getSheetIndex(sheet), txt, false);
      if (ve instanceof ArrayEval) {
        final ArrayEval ae = (ArrayEval) ve;
        if (ae.isColumn() || ae.isRow()) {
          final int rows = ae.getHeight();
          final int cols = ae.getWidth();
          for (int r = 0; r < rows; ++r) {
            for (int c = 0; c < cols; ++c) {
              ValueEval xve = ae.getValue(r, c);
              final CellValue candidate = book.getFormulaEvaluator().getCellValueByValueEval(xve);
              if (equalCellValue(target, candidate)) {
                return true;
              }
            }
View Full Code Here

TOP

Related Classes of org.zkoss.poi.ss.formula.eval.ArrayEval

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.