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

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

4899
4900
4901
4902
4903
4904
4905
4906
4907
4908
4909
    if (list != null) {
      return list;
    }
    String txt = constraint.getFormula1();
    Book book = sheet.getBook();
    final ValueEval ve = BookHelper.evaluateFormulaValueEval(book, book.getSheetIndex(sheet), txt, true);
    if (ve instanceof AreaEval) {
      final AreaEval ae = (AreaEval) ve;
      if (ae.isColumn() || ae.isRow()) {
        Worksheet worksheet = null;
        if (ae instanceof LazyAreaEval) {
View Full Code Here
4953
4954
4955
4956
4957
4958
4959
4960
4961
4962
4963
4964
4965
4966
4967
4968
4969
4970
4971
      }
      return false;
    } 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
132
133
134
135
136
137
138
139
140
141
142
        srcRef.setWithIndirectPrecedent(true); //src ref with indirect precedent will always be evaluated, no need to handle other reference
        return;
      }
      for(Ptg ptg : precedents) {
        final WorkbookEvaluator evaluator = ec.getWorkbookEvaluator();
        final ValueEval opResult = evaluator.getEvalForPtg(ptg, ec);
        if (opResult instanceof LazyAreaEval) {
          final LazyAreaEval ae = (LazyAreaEval) opResult;
          final String refBookName = ae.getBookName();
          final String refSheetName = ae.getSheetName();
          final String refLastSheetName = ae.getLastSheetName();
View Full Code Here
TOP

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

  • org.zkoss.poi.ss.formula.DefaultDependencyTracker
  • org.zkoss.zss.model.impl.BookHelper
    • 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.