Package org.apache.poi.hssf.util

Examples of org.apache.poi.hssf.util.AreaReference

87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
   
  
    protected AreaPtg(String arearef) {
        //int[] xyxy = ReferenceUtil.getXYXYFromAreaRef(arearef);
        AreaReference ar = new AreaReference(arearef);
       
        setFirstRow((short)ar.getCells()[0].getRow());
        setFirstColumn((short)ar.getCells()[0].getCol());
        setLastRow((short)ar.getCells()[1].getRow());
        setLastColumn((short)ar.getCells()[1].getCol());
        setFirstColRelative(!ar.getCells()[0].isColAbsolute());
        setLastColRelative(!ar.getCells()[1].isColAbsolute());
        setFirstRowRelative(!ar.getCells()[0].isRowAbsolute());
        setLastRowRelative(!ar.getCells()[1].isRowAbsolute());
       
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    Eval[] args = {
      createRefEval(refA),
      createRefEval(refB),
    };
    AreaReference ar = new AreaReference(expectedAreaRef);
    Eval result = RangeEval.instance.evaluate(args, 0, (short)0);
    assertTrue(result instanceof AreaEval);
    AreaEval ae = (AreaEval) result;
    assertEquals(ar.getFirstCell().getRow(), ae.getFirstRow());
    assertEquals(ar.getLastCell().getRow(), ae.getLastRow());
    assertEquals(ar.getFirstCell().getCol(), ae.getFirstColumn());
    assertEquals(ar.getLastCell().getCol(), ae.getLastColumn());
  }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
65
    ValueEval[] args = {
      createRefEval(refA),
      createRefEval(refB),
    };
    AreaReference ar = new AreaReference(expectedAreaRef);
    ValueEval result = EvalInstances.Range.evaluate(args, 0, (short)0);
    assertTrue(result instanceof AreaEval);
    AreaEval ae = (AreaEval) result;
    assertEquals(ar.getFirstCell().getRow(), ae.getFirstRow());
    assertEquals(ar.getLastCell().getRow(), ae.getLastRow());
    assertEquals(ar.getFirstCell().getCol(), ae.getFirstColumn());
    assertEquals(ar.getLastCell().getCol(), ae.getLastColumn());
  }
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
263
264
265
    return result;
  }*/

  public void setArea( String ref )
  {
    AreaReference ar = new AreaReference( ref );
   
    CellReference frstCell = ar.getFirstCell();
    CellReference lastCell = ar.getLastCell();

    setFirstRow(  (short) frstCell.getRow() );
    setFirstColumn(     frstCell.getCol() );
    setLastRow(   (short) lastCell.getRow() );
    setLastColumn(      lastCell.getCol() );
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
65
66
    protected AreaPtg() {
      //Required for clone methods
    }
  
    public AreaPtg(String arearef) {
        AreaReference ar = new AreaReference(arearef);
        CellReference firstCell = ar.getFirstCell();
        CellReference lastCell = ar.getLastCell();
        setFirstRow(firstCell.getRow());
        setFirstColumn(firstCell.getCol());
        setLastRow(lastCell.getRow());
        setLastColumn(lastCell.getCol());
        setFirstColRelative(!firstCell.isColAbsolute());
View Full Code Here
310
311
312
313
314
315
316
317
318
319
    protected static String toFormulaString(AreaI area, HSSFWorkbook book) {
      CellReference topLeft = new CellReference(area.getFirstRow(),area.getFirstColumn(),!area.isFirstRowRelative(),!area.isFirstColRelative());
      CellReference botRight = new CellReference(area.getLastRow(),area.getLastColumn(),!area.isLastRowRelative(),!area.isLastColRelative());
     
      if(AreaReference.isWholeColumnReference(topLeft, botRight)) {
        return (new AreaReference(topLeft, botRight)).formatAsString();
      } else {
        return topLeft.formatAsString() + ":" + botRight.formatAsString();
      }
    }
View Full Code Here
487
488
489
490
491
492
493
494
495
496
497
498
499
500
    int namedCellIdx = wb.getNameIndex(cellName);
    HSSFName aNamedCell = wb.getNameAt(namedCellIdx);
    assertNotNull(aNamedCell);

    // retrieve the cell at the named range and test its contents
    AreaReference aref = new AreaReference(aNamedCell.getReference());
    assertTrue("Should be exactly 1 cell in the named cell :'" +cellName+"'", aref.isSingleCell());

    CellReference cref = aref.getFirstCell();
    assertNotNull(cref);
    HSSFSheet s = wb.getSheet(cref.getSheetName());
    assertNotNull(s);
    HSSFRow r = sheet.getRow(cref.getRow());
    HSSFCell c = r.getCell(cref.getCol());
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    private AreaPtg() {
      //Required for clone methods
    }
  
    public AreaPtg(String arearef) {
        AreaReference ar = new AreaReference(arearef);
        setFirstRow((short)ar.getCells()[0].getRow());
        setFirstColumn((short)ar.getCells()[0].getCol());
        setLastRow((short)ar.getCells()[1].getRow());
        setLastColumn((short)ar.getCells()[1].getCol());
        setFirstColRelative(!ar.getCells()[0].isColAbsolute());
        setLastColRelative(!ar.getCells()[1].isColAbsolute());
        setFirstRowRelative(!ar.getCells()[0].isRowAbsolute());
        setLastRowRelative(!ar.getCells()[1].isRowAbsolute());
       
    }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
   
  
    protected AreaPtg(String arearef) {
        //int[] xyxy = ReferenceUtil.getXYXYFromAreaRef(arearef);
        AreaReference ar = new AreaReference(arearef);
       
        setFirstRow((short)ar.getCells()[0].getRow());
        setFirstColumn((short)ar.getCells()[0].getCol());
        setLastRow((short)ar.getCells()[1].getRow());
        setLastColumn((short)ar.getCells()[1].getCol());
        setFirstColRelative(!ar.getCells()[0].isColAbsolute());
        setLastColRelative(!ar.getCells()[1].isColAbsolute());
        setFirstRowRelative(!ar.getCells()[0].isRowAbsolute());
        setLastRowRelative(!ar.getCells()[1].isRowAbsolute());
       
    }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
    {
    }

    public Area3DPtg( String arearef, short externIdx )
    {
        AreaReference ar = new AreaReference( arearef );

        setFirstRow( (short) ar.getCells()[0].getRow() );
        setFirstColumn( (short) ar.getCells()[0].getCol() );
        setLastRow( (short) ar.getCells()[1].getRow() );
        setLastColumn( (short) ar.getCells()[1].getCol() );
        setFirstColRelative( !ar.getCells()[0].isColAbsolute() );
        setLastColRelative( !ar.getCells()[1].isColAbsolute() );
        setFirstRowRelative( !ar.getCells()[0].isRowAbsolute() );
        setLastRowRelative( !ar.getCells()[1].isRowAbsolute() );
        setExternSheetIndex( externIdx );

    }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.util.AreaReference

  • net.firstpartners.spreadsheet.RangeConvertor
  • org.apache.poi.hssf.model.FormulaParser
  • org.apache.poi.hssf.record.formula.Area3DPtg
  • org.apache.poi.hssf.record.formula.AreaPtg
  • org.apache.poi.hssf.record.formula.AreaPtgBase
  • org.apache.poi.hssf.record.formula.eval.TestRangeEval
  • org.apache.poi.hssf.usermodel.TestNamedRange
  • org.apache.poi.ss.formula.eval.TestRangeEval
  • org.apache.poi.ss.formula.FormulaParser
  • java.util.StringTokenizer
    • 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.