Package org.apache.poi.hssf.util

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

50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    protected 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
240
241
242
243
244
245
246
247
248
249
250
251
    return result;
  }*/

  public void setArea( String ref )
  {
    AreaReference ar = new AreaReference( ref );
    CellReference[] crs = ar.getCells();
   
    CellReference firstCell = crs[0];
    CellReference lastCell = firstCell;
    if(crs.length > 1) {
      lastCell = crs[1];
View Full Code Here
554
555
556
557
558
559
560
561
562
563
564
565
        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());
        CellReference[] crefs = aref.getCells();
        assertNotNull(crefs);
        assertEquals("Should be exactly 1 cell in the named cell :'" +cellName+"'", 1, crefs.length);
        for (int i=0, iSize=crefs.length; i<iSize; i++) {
            CellReference cref = crefs[i];
            assertNotNull(cref);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
    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
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
    return result;
  }*/

  public void setArea( String ref )
  {
    AreaReference ar = new AreaReference( ref );

    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
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.