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

Package com.extentech.formats.XLS.charts

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

com.extentech.formats.XLS.charts.Ai
Ai: Linked Chart Data (1051h)
This record specifies linked series data or text. Offset Name Size Contents -- 4 id 1 index id: (0=title or text, 1=series vals, 2=series cats + (3=bubbles) 5 rt 1 reference type(0=default,1=text in formula bar, 2=worksheet, 4=error) 6 grbit 2 flags 8 ifmt 2 Index to number format (used if fCustomIfmt= true) 10 cce 2 size of rgce (in bytes) 12 rgce var Parsed formula of link The grbit field contains the following option flags. 0 0 0x1 fCustomIfmt TRUE if this object has a custom number format; FALSE if number format is linked to data source a 1 0x2 (reserved) Reserved; must be zero 0 5-2 0x3C st Source type (always zero) a 7-6 0xCO (reserved) Reserved; must be zero 1 7-0 0xFF (reserved) Reserved; must be zero @see Formula @see Chart

                String newseries= ExcelTools.formatLocation(rc, pr.isRowRel(), pr.isColRel());
                if (isRange && newseries.indexOf(":")==-1) // handle special case of SHOULD be a range but 1st and last match
                  newseries= newseries + ":" + newseries;
                newseries= sht+ "!" + newseries;
                // Adjust Legend Range
                Ai legend= s.getLegendAi();
                rc= ExcelTools.getRowColFromString(legend.getDefinition());
                if (rc[0]==rownum) 
                  rc[0]--;
                String legendRange= ExcelTools.formatLocation(rc);
                // Adjust Bubble Range if present
                Ai bubble= s.getBubbleValueAi();
                String bubbleRange= "";
                if (bubble!=null && !bubble.getDefinition().equals("")) {
                  rc= ExcelTools.getRowColFromString(bubble.getDefinition());
                  if (rc[0]==rownum) 
                    rc[0]--;
                  if (rc.length>2)   
                    rc[2]--;  
                  bubbleRange= ExcelTools.formatLocation(rc);

View Full Code Here

  public void clearChartReferences() {
    ArrayList<ChartHandle> ret = new ArrayList();
    Iterator ii = this.wbh.getWorkBook().getRefTracker()
        .getChartReferences(this.getCell()).iterator();
    while (ii.hasNext()) {
      Ai ai = (Ai) ii.next();
      if(ai.getParentChart()!=null)
        ai.getParentChart().setMetricsDirty();
    }
  }

View Full Code Here

TOP

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

com.extentech.ExtenXLS.CellHandle

com.extentech.formats.XLS.ReferenceTracker

java.util.Iterator

java.util.List

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.