A lot of work, but not hard. ;-) -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI
http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are those of the author and are almost definitely not shared by the Apache Software Foundation, its board or its general membership. In fact they probably most definitively disagree with everything espoused in the above email. > From: Glen Stampoultzis <[EMAIL PROTECTED]> > Reply-To: "POI Developers List" <[EMAIL PROTECTED]> > Date: Thu, 22 Jan 2004 23:50:21 +1100 > To: "POI Developers List" <[EMAIL PROTECTED]> > 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]
