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

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


    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


    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

        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

    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

    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

    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

    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

    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

    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

    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

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.