Examples of Boundsheet

com.extentech.formats.XLS.Boundsheet
Boundsheet: WorkSheet Information 0x85
This record stores the sheet name, type and stream position.
```
 offset  name        size    contents --- 4       lbPlyPos    4       Stream position of the BOF for the sheet 8       grbit       2       Option flags 10      cch         1       Length of sheet name 11      grbitChr    1       Compressed/Uncompressed Unicode 12      rgch        var     Sheet name 
```
---- File Layout ---- BOUNDSHEET Bof Index Row1 is first index in DBCELL Row2 is the offset of any DBCELLS Row... CELLREC CELLREC CELLREC DBCELL rgdb rg rg rg rg ROWS CELLS DBCELL rg rg rg ... EOF ---------------------- lbplypos used to be the most important thing on earth. now it is not an issue. @see WorkBook @see Index @see Dbcell @see Row @see Cell @see XLSRecord

Examples of com.extentech.formats.XLS.Boundsheet

        int h = 0;
        if(b)h=Boundsheet.VERY_HIDDEN ;
        mysheet.setHidden(h);
        int t = mysheet.getSheetNum();
        try{ // set the next sheet selected...
            Boundsheet s2 = mybook.getWorkSheetByNumber(t+1);
            s2.setSelected(true);
        }catch(WorkSheetNotFoundException e){;}
    }

View Full Code Here

Examples of com.extentech.formats.XLS.Boundsheet

        int h = 0;
        if(b)h=Boundsheet.HIDDEN;
        mysheet.setHidden(h);
        if(mysheet.getSheetNum() == 0){
            try{
                Boundsheet s2 = mybook.getWorkSheetByNumber(mysheet.getSheetNum()+1);
                mybook.setFirstVisibleSheet(s2);
            }catch(WorkSheetNotFoundException e){;}
        }
        if(mysheet.selected()){
            try{ // set the next sheet selected...
                int x = 1;
                Boundsheet s2 = mybook.getWorkSheetByNumber(mysheet.getSheetNum()+x);
                while(s2.getHidden())s2 = mybook.getWorkSheetByNumber(mysheet.getSheetNum()+x++);
                s2.setSelected(true);
            }catch(WorkSheetNotFoundException e){;}
        }
    }

View Full Code Here

Examples of com.extentech.formats.XLS.Boundsheet

   */
  public String getXML() {
      StringBuffer retXML = new StringBuffer();
      String nmv = getExpressionString();
      if(nmv.indexOf("=!")>-1) { // add the sheetname
        Boundsheet bs = myName.getSheet();
        if(bs!=null) {
          nmv = bs.getSheetName() + "!" + nmv;
        }else{ // TODO: why no sheet defined for name???
          nmv = StringTool.replaceChars("!", nmv, "");
        }
      }
      // it's possible that name expression can have quotes and other non-compliant characters

View Full Code Here

Examples of com.extentech.formats.XLS.Boundsheet

   * @return String XML rep of all the cells referenced by this range
   */
  public String getExpandedXML() {
      String nmv = getExpressionString();
      if(nmv.indexOf("=!")>-1) { // add the sheetname
        Boundsheet bs = myName.getSheet();
        if(bs!=null) {
          nmv = bs.getSheetName() + "!" + nmv;
        }else{ // TODO: why no sheet defined for name???
          nmv = StringTool.replaceChars("!", nmv, "");
        }
      }
      String nmx = getName();

View Full Code Here

0 1

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.