Package org.apache.poi.ss.formula.ptg

Examples of org.apache.poi.ss.formula.ptg.AreaI

53
54
55
56
57
58
59
60
61
62
    return _evaluator.getEvalForCell(rowIx, colIx);
  }

  public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) {
    AreaI area = new OffsetArea(getFirstRow(), getFirstColumn(),
        relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);

    return new LazyAreaEval(area, _evaluator);
  }
View Full Code Here
77
78
79
80
81
82
83
84
85
    public ValueEval getInnerValueEval(int sheetIndex) {
      throw new RuntimeException("not expected to be called during this test");
    }
    public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx,
        int relLastColIx) {
      AreaI area = new OffsetArea(getRow(), getColumn(),
          relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);
      return new MockAreaEval(area);
    }
View Full Code Here
99
100
101
102
103
104
105
106
107
108
        public ValueEval getRelativeValue(int sheetIndex, int relativeRowIndex, int relativeColumnIndex) {
            throw new RuntimeException("not expected to be called during this test");
        }
    public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx,
        int relLastColIx) {
      AreaI area = new OffsetArea(getFirstRow(), getFirstColumn(),
          relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);

      return new MockAreaEval(area);
    }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
    return _evaluator.getEvalForCell(sheetIndex, rowIx, colIx);
  }

  public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) {
    AreaI area = new OffsetArea(getFirstRow(), getFirstColumn(),
        relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);

    return new LazyAreaEval(area, _evaluator);
  }
View Full Code Here
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
    cell.setCellFormula("count(fp1)"); // plain cell ref, col is in range
  }

  public void testParseAreaRefHighRow_bug45358() {
    Ptg[] ptgs;
    AreaI aptg;

    HSSFWorkbook book = new HSSFWorkbook();
    book.createSheet("Sheet1");

    ptgs = HSSFFormulaParser.parse("Sheet1!A10:A40000", book);
    aptg = (AreaI) ptgs[0];
    if (aptg.getLastRow() == -25537) {
      throw new AssertionFailedError("Identified bug 45358");
    }
    assertEquals(39999, aptg.getLastRow());

    ptgs = HSSFFormulaParser.parse("Sheet1!A10:A65536", book);
    aptg = (AreaI) ptgs[0];
    assertEquals(65535, aptg.getLastRow());

    // plain area refs should be ok too
    ptgs = parseFormula("A10:A65536");
    aptg = (AreaI) ptgs[0];
    assertEquals(65535, aptg.getLastRow());

  }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
    return _evaluator.getEvalForCell(sheetIndex, getRow(), getColumn());
  }

  public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) {

    AreaI area = new OffsetArea(getRow(), getColumn(),
        relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);

    return new LazyAreaEval(area, _evaluator);
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
    return _evaluator.getEvalForCell(rowIx, colIx);
  }

  public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) {
    AreaI area = new OffsetArea(getFirstRow(), getFirstColumn(),
        relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);

    return new LazyAreaEval(area, _evaluator);
  }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
    return _evaluator.getEvalForCell(rowIx, colIx);
  }

  public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) {
    AreaI area = new OffsetArea(getFirstRow(), getFirstColumn(),
        relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);

    return new LazyAreaEval(area, _evaluator);
  }
View Full Code Here
78
79
80
81
82
83
84
85
86
    public ValueEval getInnerValueEval() {
      throw new RuntimeException("not expected to be called during this test");
    }
    public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx,
        int relLastColIx) {
      AreaI area = new OffsetArea(getRow(), getColumn(),
          relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);
      return new MockAreaEval(area);
    }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
    public ValueEval getRelativeValue(int relativeRowIndex, int relativeColumnIndex) {
      throw new RuntimeException("not expected to be called during this test");
    }
    public AreaEval offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx,
        int relLastColIx) {
      AreaI area = new OffsetArea(getFirstRow(), getFirstColumn(),
          relFirstRowIx, relLastRowIx, relFirstColIx, relLastColIx);

      return new MockAreaEval(area);
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.ptg.AreaI

  • org.apache.poi.hssf.model.TestFormulaParser
  • org.apache.poi.ss.formula.eval.TestRangeEval$MockAreaEval
  • org.apache.poi.ss.formula.eval.TestRangeEval$MockRefEval
  • org.apache.poi.ss.formula.LazyAreaEval
  • org.apache.poi.ss.formula.LazyRefEval
    • 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.