Package com.extentech.formats.XLS

Examples of com.extentech.formats.XLS.BiffRec

334
335
336
337
338
339
340
341
342
343
344
345
        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
345
346
347
348
349
350
351
352
353
354
355
356
        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
360
361
362
363
364
365
366
367
368
369
370
371
     *
     * @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
375
376
377
378
379
380
381
382
383
384
385
386
     *
     * @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
390
391
392
393
394
395
396
397
398
399
400
401
     * 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
221
222
223
224
225
226
227
228
229
230
231
232
233
     */
    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
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
        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
98
99
100
101
102
103
104
105
106
107
   * 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
83
84
85
86
87
88
89
90
91
92
93
94
     *
     * @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
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
   * @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
TOP

Related Classes of com.extentech.formats.XLS.BiffRec

  • com.extentech.ExtenXLS.PrinterSettingsHandle
  • com.extentech.formats.LEO.StorageTable
  • com.extentech.formats.XLS.charts.Axis
  • com.extentech.formats.XLS.charts.AxisParent
  • com.extentech.formats.XLS.charts.ChartFormat
  • com.extentech.formats.XLS.charts.ChartSeries
  • com.extentech.formats.XLS.charts.Frame
  • com.extentech.formats.XLS.charts.GenericChartObject
  • com.extentech.formats.XLS.charts.TextDisp
  • com.extentech.formats.XLS.formulas.InformationCalculator
    • 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.