poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Glen Stampoultzis <gst...@iinet.net.au>
Subject Re: Support for Images and charting
Date Thu, 22 Jan 2004 12:50:21 GMT
At 04:57 PM 22/01/2004, you wrote:
>I think all things left to do in HSSF are basically easy, but what do I
>know.

Hrrmm... charting will be a lot of work.  The main problem is that there's 
very little information available on how charts work.  These are the 
records for a very "simple" bar chart:


[UNKNOWN RECORD:ec]
[UNKNOWN RECORD:5d]
[BOF RECORD]
     [HEADER]
     [FOOTER]
     [HCENTER]
     [VCENTER]
     [PRINTSETUP]
     [UNKNOWN RECORD:33]
     [FBI]
     [FBI]
     [PROTECT]
     [UNITS]
     [CHART]
     [BEGIN]
         [SCL]                 // zoom magnification
         [PLOTGROWTH]          // font scaling
         [FRAME]               // border around text
         [BEGIN]               // default line and area format
             [LINEFORMAT]
             [AREAFORMAT]
         [END]
         [SERIES]              // start of series
         [BEGIN]
             [AI]              // LINK_TYPE_TITLE_OR_TEXT
             [AI]              // LINK_TYPE_VALUES
             [AI]              // LINK_TYPE_CATEGORIES
             [AI]              // ??
             [DATAFORMAT]      // Formatting applies to series?
             [BEGIN]           // ??
                 [UNKNOWN RECORD]
             [END]
             [SeriesToChartGroup] // Used to support > 1 chart?
         [END]
         [SHTPROPS]            // Some defaults for how chart is displayed.
         [DEFAULTTEXT]         // Describes the characteristics of the next
                               // record
         [TEXT]                // Details of the text that follows in the
                               // next section
         [BEGIN]
             [UNKNOWN RECORD]  // POS record... looks like I missed this one.
                               // docs seem to indicate it's better to use
                               // defaults...
             [FONTX]           // index to font record.
             [AI]              // link to text?  seems to be linking to nothing
         [END]
         [DEFAULTTEXT]         // contains a category type of 3 which is not
                               // documented (sigh).
         [TEXT]                // defines position, color etc for text on 
chart.
         [BEGIN]
             [UNKNOWN RECORD]  // Another pos record
             [FONTX]           // font
             [AI]              // reference type is DIRECT (not sure what this
                               // means)
         [END]
         [AXISUSED]            // number of axis on the chart.
         [AXISPARENT]          // axis size and location
         [BEGIN]               // beginning of axis details
             [UNKNOWN RECORD]        // Another pos record.
             [AXIS]                  // Category axis
             [BEGIN]
                 [CATSERRANGE]       // defines tick marks and other stuff
                 [AXCEXT]            // unit information
                 [TICK]              // tick formating characteristics
             [END]
             [AXIS]                  // Value axis
             [BEGIN]
                 [VALUERANGE]        // defines tick marks and other stuff
                 [TICK]              // tick formating characteristics
                 [AXISLINEFORMAT]    // major grid line axis format
                 [LINEFORMAT]        // what do the lines look like?
             [END]
             [PLOTAREA]              // marks that the frame following belongs
                                     // to the frame.
             [FRAME]                 // border
             [BEGIN]
                 [LINEFORMAT]        // border line
                 [AREAFORMAT]        // border area
             [END]
             [CHARTFORMAT]           // marks a chart group
             [BEGIN]
                 [BAR]               // indicates a bar chart
                 [UNKNOWN RECORD]    // apparently this record is ignoreable
                 [LEGEND]            // positioning for the legend
                 [BEGIN]
                     [UNKNOWN RECORD]    // another position record.
                     [TEXT]              // details of the text that follows
                                         // in the next section
                     [BEGIN]
                         [UNKNOWN RECORD]  // yet another pos record
                         [AI]              // another link (of type direct)
                     [END]
                 [END]
             [END]
         [END]
     [END]
     [DIMENSIONS]
     [SINDEX]
     [SINDEX]
     [SINDEX]
[EOF]





Glen Stampoultzisgstamp@iinet.net.au
http://members.iinet.net.au/~gstamp/glen/


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org


Mime
View raw message