Examples of com.extentech.formats.XLS.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

     * axis frame and plot area records as are not necessary
     */
    protected void removePlotArea() {
      boolean remove= false;
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==AXIS) {
              remove= true;
            } else if (b.getOpcode()==CHARTFORMAT) {
              break;  
            } else if (remove) {
              chartArr.remove(i);
              i--;
            }

View Full Code Here

      boolean bHasAxis= false;
      boolean bHasLabel= false;
      StringBuffer sb= new StringBuffer();
      int tdType= TextDisp.convertType(axis);
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==AXIS) {
              if (((Axis) b).getAxis()==axis)  {
                sb.append(((Axis) b).getOptionsXML());
                bHasAxis= true;
              }
            } else if (b.getOpcode()==TEXTDISP) {
                if (((TextDisp)b).getType()==tdType) { 
                  sb.append(((TextDisp) b).getOptionsXML());
                  bHasLabel= true;
                  break;
                }

View Full Code Here

    int lastAxis= 0;
    Axis a= null;
    TextDisp td= null;
      int tdType= TextDisp.convertType(axisType);
        for (int i=0;i<chartArr.size() && td==null;i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b.getOpcode()==AXIS) {
              lastAxis= i;
              if (((Axis) b).getAxis()==axisType) {
                a= ((Axis) b);
                a.setAP(this);  // ensure axis is linked to it's parent AxisParent 20090108 KSC:
                //if (!bCreateIfNecessary) return a;
              }
            } else if (b.getOpcode()==TEXTDISP) {                
                lastTd= i;
                if (tdType==((TextDisp)b).getType()) {
                  td= (TextDisp) b;
                  if (bCreateIfNecessary) {// 20080723 KSC: added guard - but when is clearing td text necessary????
                    td.setText("");  // clear out axis legend

View Full Code Here

   * returns the plot area background color
   * @return plot area background color hex string
   */
  public String getPlotAreaBgColor() {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b instanceof Frame) {
              return ((Frame)b).getBgColor();
            }          
        }
    return null;  //FormatHandle.COLOR_WHITE;

View Full Code Here

   * sets the plot area background color 
   * @param bg color int
   */
  public void setPlotAreaBgColor(int bg) {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b instanceof Frame) {
              ((Frame)b).setBgColor(bg);
              break;
            }          
        }

View Full Code Here

   * @param lw
   * @param lclr
   */
  public void setPlotAreaBorder(int lw, int lclr) {
        for (int i=0;i<chartArr.size();i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            if (b instanceof Frame) {
              ((Frame)b).addBox(lw, lclr, -1);
              break;
            }          
        }

View Full Code Here

      boolean hasMajorGridLines= false;  
        // Axis 0: CatserRange, Axcent, Tick [AxisLineFormat, LineFormat, AreaFormat]           last 3 recs are for 3d formatting  
    // Axis 1: ValueRange, Tick, AxisLineFormat, LineFormat [AreaFormat, LineFormat, AreaFormat]    "  "
        // Axis 2: [CatserRange, Tick]    Z axis, for surface charts (only??)
      for (int i= 0; i < chartArr.size(); i++) {
            BiffRec b = (BiffRec)chartArr.get(i);
            // Handle subordinate record options here rather than in the specific rec
            if (b instanceof CatserRange) {
              CatserRange c= ((CatserRange) b);
              // record deviations from defaults
              if (c.getCatCross()!=1)

View Full Code Here

        ;
      }
    }
    j= 1;
    for (; j < chartArr.size(); j++) {
      BiffRec b= (BiffRec) chartArr.get(j);
      if (b.getOpcode()==AREAFORMAT ||
          b.getOpcode()==GELFRAME ||
          b.getOpcode()==2213 ||  /* TextPropsStream */
          b.getOpcode()==2212 ||  /* ShapePropsStream */
          b.getOpcode()==2206)  /* CtrlMlFrt */ 
          break;          
    }
        alf= (AxisLineFormat) AxisLineFormat.getPrototype();
        alf.setId(type);  // default has major gridlines
        chartArr.add(j++, alf);

View Full Code Here

      // includeZero, natural (true)
      // min, max
      // minorTicks, majorTicks, microTicks (true/false)
      // minorTickStep, majorTickStep, microTickStep (#)
        for (int i= 0; i < chartArr.size(); i++) {
              BiffRec b = (BiffRec)chartArr.get(i);
              if (b instanceof CatserRange) {
                CatserRange c= ((CatserRange) b);                
          // for x/Category axis:  if has labels, gather and input into axis label JSON array
          String[] categories= this.getParentChart().getCategories(-1);
          if (categories!=null) {

View Full Code Here

      }
      } else {    // valuerange, caterrange options  -- crosses, crossBetween, crossesAt, tickMarkSkip (cat only), tickLblSkip (cat only), majorUnit (val only), minorUnit (val only)  
// KSC: TESTING
//Logger.logInfo("Setting option: " + op + "=" + val);
        for (int i= 0; i < chartArr.size(); i++) {
              BiffRec b = (BiffRec)chartArr.get(i);
              if (b instanceof CatserRange) {
                if (((CatserRange)b).setOption(op, val))
                  break;
              }else if (b instanceof ValueRange) {
                if (((ValueRange)b).setOption(op, val))

View Full Code Here

0 1 2 3

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

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.