Glen, Thanks for the bar chart records, there very useful. Do you have a similar dump for images?
Kind Regards -- Kais -----Original Message----- From: Glen Stampoultzis [mailto:[EMAIL PROTECTED] Sent: 22 January 2004 12:50 To: POI Developers List Subject: Re: Support for Images and charting 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 [EMAIL PROTECTED] http://members.iinet.net.au/~gstamp/glen/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
