Examples of AreaEval

Examples of org.apache.poi.hssf.record.formula.eval.AreaEval

44
45
46
47
48
49
50
51
52
53
54
55
    }
    Eval firstArg = args[0];

    int result;
    if (firstArg instanceof AreaEval) {
      AreaEval ae = (AreaEval) firstArg;
      result = ae.getLastRow() - ae.getFirstRow() + 1;
    } else if (firstArg instanceof RefEval) {
      result = 1;
    } else { // anything else is not valid argument
      return ErrorEval.VALUE_INVALID;
    }
View Full Code Here

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

59
60
61
62
63
64
65
66
67
68
69
    ValueEval[] values = new ValueEval[TEST_VALUES0.length];
    for (int i = 0; i < TEST_VALUES0.length; i++) {
      values[i] = new NumberEval(TEST_VALUES0[i]);
    }

    AreaEval arg1 = EvalFactory.createAreaEval("C1:D5", values);
    ValueEval args[] = { new NumberEval(function), arg1 };

    ValueEval result = new Subtotal().evaluate(args, 0, 0);

    assertEquals(NumberEval.class, result.getClass());
View Full Code Here

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

4901
4902
4903
4904
4905
4906
4907
4908
4909
4910
4911
4912
4913
4914
4915
4916
4917
4918
4919
4920
4921
4922
4923
    }
    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
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.