Examples of com.extentech.formats.XLS.formulas.PtgArea

Package com.extentech.formats.XLS.formulas

Examples of com.extentech.formats.XLS.formulas.PtgArea

com.extentech.formats.XLS.formulas.PtgArea

ptgArea is a reference to an area (rectangle) of cells. Essentially it is a collection of two ptgRef's, so it will be treated that way in the code...

 Offset      Size    Contents ---------------------------------------------------- 0			2 		Index to first row (065535) or offset of first row (method [B], -3276832767) 2 			2 		Index to last row (065535) or offset of last row (method [B], -3276832767) 4 			2 		Index to first column or offset of first column, with relative flags (see table above) 6 			2 		Index to last column or offset of last column, with relative flags (see table above) Only the low-order 14 bits specify the Col, the other bits specify relative vs absolute for both the col or the row. Bits        Mask        Name    Contents ----------------------------------------------------- 15          8000h       fRwRel  =1 if row offset relative,  =0 if otherwise 14          4000h       fColRel =1 if row offset relative, =0 if otherwise 13-0        3FFFh       col     Ordinal column offset or number

@see Ptg @see Formula

        * @param parentRec
        */
       public SqRef(String range, XLSRecord parentRec) {
           // add handling for different ref types, for now utilize a PtgArea
         if (range!=null && !range.equals("")) {
             myPtg = new PtgArea(range, parentRec);
             myPtg.addToRefTracker();
         }
       }

View Full Code Here


          int col2 = ByteTools.readShort(b[6], b[7]);
          int[] rc = {row,col,row2, col2};
          boolean[] bool = {true,true,true,true};
          String location = ExcelTools.formatRangeRowCol(rc, bool);
          myPtg = new PtgArea(location, parentRec);
          myPtg.addToRefTracker();
      }

View Full Code Here


        int col2 = ByteTools.readShort(b[6], b[7]);
        int[] rc = {row,col,row2, col2};
        boolean[] bool = {true,true,true,true};
        String location = ExcelTools.formatRangeRowCol(rc, bool);
        PtgArea pa= new PtgArea(location, parentRec);
        pa.addToRefTracker();
        return this.add(pa);        
    }

View Full Code Here

    }
  
    public boolean add(String range, XLSRecord parentRec) {
        // add handling for different ref types, for now utilize a PtgArea
      if (range!=null && !range.equals("")) {
           PtgArea pa= new PtgArea(range, parentRec);
           pa.addToRefTracker();
           return this.add(pa);
      }
      return false;
    }

View Full Code Here

        cRangeList = new ArrayList();
        for (int i=0;i<numLocs; i++) {
            byte[] b = new byte[1];
            b[0] = 0x0;
            b = ByteTools.append(b, this.getBytesAt(offset, 8));
            PtgArea p = new PtgArea(false);
            p.setParentRec(this);
            p.init(b);
            cRangeList.add(p);
            offset+=8;
        }
        
        // set all the grbit fields

View Full Code Here

      if (range==null) {  // for creating a dv and adding range info later
        cRangeList= null;
        return;
      }
        if(range.indexOf(":")==-1)range = range+":"+range;
        PtgArea p = new PtgArea(range, this, false);
        cRangeList = new ArrayList();
        cRangeList.add(p);
        dirtyflag = true;
    }

View Full Code Here

       if (cRangeList==null) cRangeList= new ArrayList();  // 20090605 KSC: Added
       /*int[] i = ExcelTools.getRowColFromString(range);
       if(i.length==2) {
           
       }else {*/
        PtgArea p = new PtgArea(range, this, false);  // 20090609 KSC: absolute refs if '$' -really should test if row or col     
        cRangeList.add(p);
        dirtyflag = true;
    }

View Full Code Here

     * 
     * @param range
     */
    public void addOoxmlRange(String range) {
        if (cRangeList==null) cRangeList= new ArrayList();  // 20090605 KSC: Added
        PtgArea p = new PtgArea(range, this, (range!=null)?(range.indexOf('$')==-1):false); // 20090609 KSC: absolute refs if '$' -really should test if row or col
//        p.setUseReferenceTracker(false);
        cRangeList.add(p);
        dirtyflag = true;
    }

View Full Code Here

TOP

Related Classes of com.extentech.formats.XLS.formulas.PtgArea

com.extentech.formats.XLS.BiffRec

com.extentech.formats.XLS.Boundsheet

com.extentech.formats.XLS.DiscontiguousRefStruct$SqRef

com.extentech.formats.XLS.Dv

com.extentech.formats.XLS.Formula

com.extentech.formats.XLS.refPtgs

com.extentech.toolkit.FastAddVector

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.