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

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


    }
    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) {
          worksheet = book.getWorksheet(((LazyAreaEval) ve).getSheetName());
        } else {
          worksheet = sheet;
        }
       
        final int rows = ae.getHeight();
        final int cols = ae.getWidth();
        final int top = ae.getFirstRow();
        final int left = ae.getFirstColumn();
        String[] xlist = new String[rows*cols];
        for (int r = 0, j=0; r < rows; ++r) {
          int rowIndex = r + top;
          for (int c = 0; c < cols; ++c) {
            int colIndex = c + left;
View Full Code Here

TOP

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

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.