Examples of PtgRef

com.extentech.formats.XLS.formulas.PtgRef

ptgRef is a reference to a single cell. It contains row and column information, plus a grbit to determine whether these values are relative or absolute. This grbit is, stupidly, but expectedly, encoded within the column value.

 Offset      Name        Size    Contents ---------------------------------------------------- 0           rw          2       the row 2           grbitCol    2       (see following table) 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 col offset relative, =0 if otherwise 13-0        3FFFh       col     Ordinal column offset or number

@see WorkBook @see Boundsheet @see Dbcell @see Row @see Cell @see XLSRecord

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

      String[] s = new String[allrefs.size()];
        Iterator ptgs= allrefs.values().iterator();
        int i= 0;
        while (ptgs.hasNext()) {       
          try{
            PtgRef pr= (PtgRef) ptgs.next();
            s[i++]= pr.getLocation();
          } catch (Exception ex) {
          }
      }
        return s;
    }

View Full Code Here

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

      
      byte[] retData= new byte[0];
        Iterator ptgs= allrefs.values().iterator();
        while (ptgs.hasNext()) {        
          try{
            PtgRef pr= (PtgRef) ptgs.next();            
//              retData = ByteTools.append(getRecordData((PtgRef)refs[i]), retData);
              retData = ByteTools.append(retData, getRecordData(pr));
          } catch (Exception ex) {
          }
      }

View Full Code Here

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

        for (int i= refs.length-1; i >= 0; i--) {*/
        int[] retValues = {Integer.MAX_VALUE,Integer.MAX_VALUE,0,0};
        Iterator ptgs= allrefs.values().iterator();
        int i= 0;
        while (ptgs.hasNext()) {
          PtgRef pr= (PtgRef) ptgs.next();
//          PtgRef pr= (PtgRef)refs[i];
            int[] locs = pr.getIntLocation();
            for (int x=0;x<2;x++) {
                if((locs[x]<retValues[x]))retValues[x]=locs[x];
            }
            for (int x=2;x<4;x++) {
                if((locs[x]>retValues[x]))retValues[x]=locs[x];

View Full Code Here

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


    Iterator x = cfmt.getRules().iterator();
    while (x.hasNext()) {
      Cf cx1 = ((Cf) x.next());
      // create a ptgref for this Cell
      Ptg pref = new PtgRef(this.getCellAddress(), this.mycell, false);


      if (cx1.evaluate(pref)) {
        // TODO: evaluate and combine multiple rules...
        // currently returns on first true format
        int ret = cfmt.getCfxe();

View Full Code Here

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.