Examples of com.extentech.formats.XLS.charts.Chart

Package com.extentech.formats.XLS.charts

Examples of com.extentech.formats.XLS.charts.Chart

com.extentech.formats.XLS.charts.Chart
Chart: Chart Location and Dimensions 0x1002h
The Chart record determines the chart dimensions and marks the beginning of the Chart records.
```
 Note that all these values are split up 2 bytes integer and 2 bytes fractional offset  name        size    contents ---     4       x           4       x pos of upper left corner 8       y           4       y pos of upper left corner 12      dx          4       x-size 16      dy          4       y-size 
```
notes on implementation:
A chart may have up to 9 chart types (specific instances of a chart e.g. bar, line, etc.) known as chart groups. These are identified by the chartgroup array list.
The parent of these chart groups are the axis group.
A chart's series and trendlines contains indexes into the chart group. @see Ai

          int nUserShapes= 0; // if charts link to any drawing ml user shapes, see below for handling
          if (charts.size()>0) {
             // for each chart, create a chart.xml + trap references for drawingX.xml.rels 
             for (int i= 0; i < charts.size(); i++) {             
                 try {   // obtain image OOXML + write image file to ZIP
                   Chart c= (Chart) charts.get(i);
                 drawing.append(getChartDrawingOOXML(new ChartHandle(c, bk)));  
                 drawing.append("\r\n");            
                 if (c instanceof OOXMLChart) {
                   ArrayList chartEmbeds= ((OOXMLChart)charts.get(i)).getChartEmbeds();
                   if (chartEmbeds!=null) {

View Full Code Here

   * @throws ChartNotFoundException
   */
    public ChartHandle getChartById(int id) 
    throws ChartNotFoundException{
        AbstractList cv = mybook.getChartVect();
        Chart cht = null;
        for(int x=0;x<cv.size();x++){
            cht = (Chart)cv.get(x);
            if(cht.getId()==id)
              return new ChartHandle(cht, this);
        }
        throw new ChartNotFoundException("Id " + id);
    }

View Full Code Here

    */
    public WorkSheetHandle addWorkSheet(WorkSheetHandle sourceSheet, String NewSheetName){
        sourceSheet.getSheet().populateForTransfer();   // copy all formatting + images for this sheet
        List chts = sourceSheet.getSheet().getCharts();
        for(int i=0;i<chts.size();i++) {
            Chart cxi = (Chart)chts.get(i);
            cxi.populateForTransfer();
        }                    
        byte[] bao = sourceSheet.getSerialBytes();
        try {
          mybook.addBoundsheet(bao, sourceSheet.getSheetName(), NewSheetName, StringTool.stripPath(sourceSheet.getWorkBook().getName()), true);
            WorkSheetHandle wsh = this.getWorkSheet(NewSheetName);

View Full Code Here

     */


      try {
          ObjectInputStream ois = new ObjectInputStream(
          new ByteArrayInputStream( getPrototypeChart() ) );
          Chart newchart= (Chart) ois.readObject();
          newchart.setWorkBook(this.getWorkBook());
          if (this.getIsExcel2007())           
            newchart= new OOXMLChart(newchart, this);
      mybook.addPreChart();
      mybook.addChart(newchart, name, wsh.getSheet());
      /* add font recs if nec: for the default chart:

View Full Code Here

        
        // Delete chart series IF SERIES ARE ROW-BASED -- do before updateReferences
    List charts = this.mysheet.getCharts();  
    for (int i= 0; i < charts.size(); i++) {
      String sht= GenericPtg.qualifySheetname(this.getSheetName());
      Chart c= (Chart) charts.get(i);
      HashMap seriesmap= c.getSeriesPtgs();
      Iterator ii= seriesmap.keySet().iterator();
      while (ii.hasNext()) {
         com.extentech.formats.XLS.charts.Series s= ( com.extentech.formats.XLS.charts.Series) ii.next();
         Ptg[] ptgs= (Ptg[])seriesmap.get(s);
             PtgRef pr;
             String cursheet;
             int[] rc;
         for (int j= 0; j < ptgs.length; j++) {
           try {
             pr= (PtgRef)ptgs[j];
             cursheet= pr.getSheetName();
             rc= pr.getIntLocation();
             if (rc[1]!=rc[3] && sht.equalsIgnoreCase(cursheet)) { // series are in rows, if existing series fall within deleted row 
                if ((rc[0])==rownum-1) { 
                  c.removeSeries(j);
                  break;  // got it
                }
             } else
                    break;  // isn't row-based so split
           } catch (Exception e) {
             continue;  // shouldn't happen!
           }
         }
      }
          // also shift chart up if necessary [BugTracker 2858] 
      int row= c.getRow0();
      // only move images whose top is >= rnum
      int rnum= rownum+1;
      if (row > rnum) {
        int h= c.getHeight();
        // move down 1 row
        c.setRow(row-1);
        c.setHeight(h);
      }
    }
      
        if (flag!=WorkSheetHandle.ROW_DELETE_NO_REFERENCE_UPDATE)
          ReferenceTracker.updateReferences(rownum, -1, this.mysheet, true);

View Full Code Here

        }
      }
      // Insert chart series IF SERIES ARE ROW-BASED      
      List charts = this.mysheet.getCharts(); 
      for (int i= 0; i < charts.size(); i++) {
        Chart c= (Chart) charts.get(i);
        ReferenceTracker.insertChartSeries(c, GenericPtg.qualifySheetname(this.getSheetName()), rownum);
        // also shift charts down [BugTracker 2858]
        int row= c.getRow0();
        // only move charts whose top is >= copyRow
        if (row >= rownum) {
          // move down 1 row
          int h= c.getHeight();
          c.setRow(row+offset);
          c.setHeight(h);          
        }
      }      
      return true;
    }

View Full Code Here

TOP

Related Classes of com.extentech.formats.XLS.charts.Chart

com.extentech.ExtenXLS.WorkBookHandle

com.extentech.ExtenXLS.WorkSheetHandle

com.extentech.formats.XLS.OOXMLWriter

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.