Examples of AreaI

org.apache.poi.hssf.record.formula.AreaI
Common interface for AreaPtg and Area3DPtg, and their child classes.
org.apache.poi.ss.formula.ptg.AreaI
Common interface for AreaPtg and Area3DPtg, and their child classes.

Examples of org.apache.poi.hssf.record.formula.AreaI

    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

Examples of org.apache.poi.hssf.record.formula.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

Examples of org.apache.poi.hssf.record.formula.AreaI

    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

Examples of org.apache.poi.hssf.record.formula.AreaI

    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

Examples of org.apache.poi.hssf.record.formula.AreaI

    return _evaluator.getEvalForCell(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

Examples of org.apache.poi.hssf.record.formula.AreaI

    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

Examples of org.apache.poi.hssf.record.formula.AreaI

    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

Examples of org.apache.poi.hssf.record.formula.AreaI

    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

Examples of org.apache.poi.hssf.record.formula.AreaI

    return _evaluator.getEvalForCell(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

Examples of org.apache.poi.hssf.record.formula.AreaI

    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

0 1 2 3

TOP

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.