Examples of BiffRec

com.extentech.formats.XLS.BiffRec
To change the template for this generated type comment go to Window>Preferences>Java>Code Generation>Code and Comments

Examples of com.extentech.formats.XLS.BiffRec

        return false;
    }
    
    protected boolean isXAxisLabel() {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==OBJECTLINK) {
                ObjectLink ol = (ObjectLink) b;
                return ol.isXAxisLabel();
            }
        }
        return false;

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

        return false;
    }
    
    protected boolean isYAxisLabel() {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==OBJECTLINK) {
                ObjectLink ol = (ObjectLink) b;
                return ol.isYAxisLabel();
            }
        }
        return false;

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

     * 
     * @return truth of "This TextDisp represents the Z axis"
     */
    protected boolean isZAxisLabel() {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==OBJECTLINK) {
                ObjectLink ol = (ObjectLink) b;
                return ol.getType()==ObjectLink.TYPE_ZAXIS;
            }
        }
        return false;

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

     * 
     * @return
     */
    public String toString() {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==SERIESTEXT) {
                SeriesText st = (SeriesText) b;
                return st.toString();
            }
        }
        return "";

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

     * Set the text of this textDisplay object.
     * Requires setting the child seriesText object
     */
    public void setText(String newText) {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==SERIESTEXT) {
                SeriesText st = (SeriesText) b;
                st.setText(newText);
                break;
            }
        }

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

     */
    public boolean contains(CellHandle ch){
        String chsheet = ch.getWorkSheetName();
        String mysheet = "";
        if(this.getParentRec()!=null) {
            BiffRec b = this.getParentRec();
            if (b.getSheet()!=null) {
                mysheet = b.getSheet().getSheetName();
            }
        }
        if(!chsheet.equalsIgnoreCase(mysheet))
          return false;
        String adr = ch.getCellAddress();

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

        Object returnval= new Double(0);
        String retstr = null;
        String array= "";
        boolean isArray= (this.parent_rec instanceof Array);
        for(int t=0;t<refCell.length;t++) {
          BiffRec cel = refCell[t];
          if (cel==null) { // 20090203 KSC
            continue;            
          }
            
          try{
            Formula f = (Formula)cel.getFormulaRec();
            if (f!=null){
              Object oby = f.calculateFormula();
                String s = String.valueOf(oby);
                try{
                  //Double d = new Double(s);
                    returnval = new Double(s);
                }catch(NumberFormatException ex) {
                  retstr = s;          // 20090202 KSC: was +=
                }


            }else{
              returnval = cel.getInternalVal();  //DblVal();  // 20090202 KSC: was +=
            }
          } catch(FunctionNotSupportedException e) {
            ; // keep going???          
          } catch(Exception e){
        returnval = cel.getInternalVal();  //DblVal();    // 20090202 KSC: was +=
          }
          if (!isArray)  // 20080730 KSC: if not an array, retrieve only 1st referenced cell value
            break;
          //
          if (retstr!=null)

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

   * AreaFormat Record's FOREGROUND color (icvFore)
   * @param bg  color int
   */
  public void setBgColor(int bg) {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b instanceof AreaFormat)
              ((AreaFormat) b).seticvFore(bg);
        }
  }

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

     * 
     * @return
     */
    protected ChartFormat getChartFormat(int nChart, boolean addNew) {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==CHARTFORMAT) {
                ChartFormat cf = (ChartFormat) b;
                if (cf.getDrawingOrder()==nChart)
                  return cf;
            }
        }

View Full Code Here

Examples of com.extentech.formats.XLS.BiffRec

   * @param axisType
   */
    public void removeAxis(int axisType) {
      // Remove axis
      for (int i= 0; i < chartArr.size(); i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
               if (b.getOpcode()==AXIS) {
                 if (((Axis)b).getAxis()==axisType) {
                   chartArr.remove(i);
                   break;
                 }
            }
      }
      int tdType= TextDisp.convertType(axisType);
      // Remove TextDisp assoc with Axis
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==TEXTDISP) {
                TextDisp td = (TextDisp)b;
                if (tdType==td.getType()) { 
                  chartArr.remove(i);
                  break;
                }

View Full Code Here

0 1 2 3

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.