Some charting work (this is not currently working so don't expect much).

git-svn-id: https://svn.apache.org/repos/asf/jakarta/poi/trunk@352938 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 818 insertions, 0 deletions

diff --git a/src/contrib/src/org/apache/poi/hssf/usermodel/HSSFChart.java b/src/contrib/src/org/apache/poi/hssf/usermodel/HSSFChart.java
new file mode 100644
index 0000000000..b23b1669e5
--- /dev/null
+++ b/src/contrib/src/org/apache/poi/hssf/usermodel/HSSFChart.java
@@ -0,0 +1,818 @@
+/* ====================================================================
+ * The Apache Software License, Version 1.1
+ *
+ * Copyright (c) 2002 The Apache Software Foundation.  All rights
+ * reserved.
+ *
+ * Redistribution and use in source and binary forms, with or without
+ * modification, are permitted provided that the following conditions
+ * are met:
+ *
+ * 1. Redistributions of source code must retain the above copyright
+ *    notice, this list of conditions and the following disclaimer.
+ *
+ * 2. Redistributions in binary form must reproduce the above copyright
+ *    notice, this list of conditions and the following disclaimer in
+ *    the documentation and/or other materials provided with the
+ *    distribution.
+ *
+ * 3. The end-user documentation included with the redistribution,
+ *    if any, must include the following acknowledgment:
+ *       "This product includes software developed by the
+ *        Apache Software Foundation (http://www.apache.org/)."
+ *    Alternately, this acknowledgment may appear in the software itself,
+ *    if and wherever such third-party acknowledgments normally appear.
+ *
+ * 4. The names "Apache" and "Apache Software Foundation" and
+ *    "Apache POI" must not be used to endorse or promote products
+ *    derived from this software without prior written permission. For
+ *    written permission, please contact apache@apache.org.
+ *
+ * 5. Products derived from this software may not be called "Apache",
+ *    "Apache POI", nor may "Apache" appear in their name, without
+ *    prior written permission of the Apache Software Foundation.
+ *
+ * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
+ * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
+ * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+ * DISCLAIMED.  IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
+ * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
+ * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
+ * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
+ * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+ * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
+ * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
+ * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
+ * SUCH DAMAGE.
+ * ====================================================================
+ *
+ * This software consists of voluntary contributions made by many
+ * individuals on behalf of the Apache Software Foundation.  For more
+ * information on the Apache Software Foundation, please see
+ * <http://www.apache.org/>.
+ */
+
+package org.apache.poi.hssf.usermodel;
+
+import org.apache.poi.hssf.record.*;
+import org.apache.poi.hssf.record.formula.Area3DPtg;
+
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Stack;
+
+/**
+ * Has methods for construction of a chart object.
+ *
+ * @author Glen Stampoultzis (glens at apache.org)
+ */
+public class HSSFChart
+{
+
+    /**
+     * Creates a bar chart.  API needs some work. :)
+     * <p>
+     * NOTE:  Does not yet work...  checking it in just so others
+     * can take a look.
+     */
+    public void createBarChart( HSSFWorkbook workbook, HSSFSheet sheet )
+    {
+
+        List records = new ArrayList();
+        records.add( createMSDrawingObjectRecord() );
+        records.add( createOBJRecord() );
+        records.add( createBOFRecord() );
+        records.add( createHeaderRecord() );
+        records.add( createFooterRecord() );
+        records.add( createHCenterRecord() );
+        records.add( createVCenterRecord() );
+        records.add( createPrintSetupRecord() );
+        // unknown 33
+        records.add( createFontBasisRecord1() );
+        records.add( createFontBasisRecord2() );
+        records.add( createProtectRecord() );
+        records.add( createUnitsRecord() );
+        records.add( createChartRecord( 0, 0, 30434904, 19031616 ) );
+        records.add( createBeginRecord() );
+        records.add( createSCLRecord( (short) 1, (short) 1 ) );
+        records.add( createPlotGrowthRecord( 65536, 65536 ) );
+        records.add( createFrameRecord1() );
+        records.add( createBeginRecord() );
+        records.add( createLineFormatRecord(true) );
+        records.add( createAreaFormatRecord1() );
+        records.add( createEndRecord() );
+        records.add( createSeriesRecord() );
+        records.add( createBeginRecord() );
+        records.add( createTitleLinkedDataRecord() );
+        records.add( createValuesLinkedDataRecord() );
+        records.add( createCategoriesLinkedDataRecord() );
+        records.add( createDataFormatRecord() );
+        //        records.add(createBeginRecord());
+        // unknown
+        //        records.add(createEndRecord());
+        records.add( createSeriesToChartGroupRecord() );
+        records.add( createEndRecord() );
+        records.add( createSheetPropsRecord() );
+        records.add( createDefaultTextRecord( DefaultDataLabelTextPropertiesRecord.CATEGORY_DATA_TYPE_ALL_TEXT_CHARACTERISTIC ) );
+        records.add( createAllTextRecord() );
+        records.add( createBeginRecord() );
+        // unknown
+        records.add( createFontIndexRecord( 5 ) );
+        records.add( createDirectLinkRecord() );
+        records.add( createEndRecord() );
+        records.add( createDefaultTextRecord( (short) 3 ) ); // eek, undocumented text type
+        records.add( createUnknownTextRecord() );
+        records.add( createBeginRecord() );
+        records.add( createFontIndexRecord( (short) 6 ) );
+        records.add( createDirectLinkRecord() );
+        records.add( createEndRecord() );
+
+        records.add( createAxisUsedRecord( (short) 1 ) );
+        createAxisRecords( records );
+
+        records.add( createEndRecord() );
+        records.add( createDimensionsRecord() );
+        records.add( createSeriesIndexRecord(2) );
+        records.add( createSeriesIndexRecord(1) );
+        records.add( createSeriesIndexRecord(3) );
+        records.add( createEOFRecord() );
+
+
+
+        sheet.insertChartRecords( records );
+        workbook.insertChartRecord();
+    }
+
+    private EOFRecord createEOFRecord()
+    {
+        return new EOFRecord();
+    }
+
+    private SeriesIndexRecord createSeriesIndexRecord( int index )
+    {
+        SeriesIndexRecord r = new SeriesIndexRecord();
+        r.setIndex((short)index);
+        return r;
+    }
+
+    private DimensionsRecord createDimensionsRecord()
+    {
+        DimensionsRecord r = new DimensionsRecord();
+        r.setFirstRow(0);
+        r.setLastRow(31);
+        r.setFirstCol((short)0);
+        r.setLastCol((short)1);
+        return r;
+    }
+
+    private HCenterRecord createHCenterRecord()
+    {
+        HCenterRecord r = new HCenterRecord();
+        r.setHCenter(false);
+        return r;
+    }
+
+    private VCenterRecord createVCenterRecord()
+    {
+        VCenterRecord r = new VCenterRecord();
+        r.setVCenter(false);
+        return r;
+    }
+
+    private PrintSetupRecord createPrintSetupRecord()
+    {
+        PrintSetupRecord r = new PrintSetupRecord();
+        r.setPaperSize((short)0);
+        r.setScale((short)18);
+        r.setPageStart((short)1);
+        r.setFitWidth((short)1);
+        r.setFitHeight((short)1);
+        r.setLeftToRight(false);
+        r.setLandscape(false);
+        r.setValidSettings(true);
+        r.setNoColor(false);
+        r.setDraft(false);
+        r.setNotes(false);
+        r.setNoOrientation(false);
+        r.setUsePage(false);
+        r.setHResolution((short)0);
+        r.setVResolution((short)0);
+        r.setHeaderMargin(0.5);
+        r.setFooterMargin(0.5);
+        r.setCopies((short)15); // what the ??
+        return r;
+    }
+
+    private FontBasisRecord createFontBasisRecord1()
+    {
+        FontBasisRecord r = new FontBasisRecord();
+        r.setXBasis((short)9120);
+        r.setYBasis((short)5640);
+        r.setHeightBasis((short)200);
+        r.setScale((short)0);
+        r.setIndexToFontTable((short)5);
+        return r;
+    }
+
+    private FontBasisRecord createFontBasisRecord2()
+    {
+        FontBasisRecord r = createFontBasisRecord1();
+        r.setIndexToFontTable((short)6);
+        return r;
+    }
+
+    private ProtectRecord createProtectRecord()
+    {
+        ProtectRecord r = new ProtectRecord();
+        r.setProtect(false);
+        return r;
+    }
+
+    private FooterRecord createFooterRecord()
+    {
+        FooterRecord r = new FooterRecord();
+        r.setFooter(null);
+        return r;
+    }
+
+    private HeaderRecord createHeaderRecord()
+    {
+        HeaderRecord r = new HeaderRecord();
+        r.setHeader(null);
+        return r;
+    }
+
+    private BOFRecord createBOFRecord()
+    {
+        BOFRecord r = new BOFRecord();
+        r.setVersion((short)600);
+        r.setType((short)20);
+        r.setBuild((short)0x1CFE);
+        r.setBuildYear((short)1997);
+        r.setHistoryBitMask(0x40C9);
+        r.setRequiredVersion(106);
+        return r;
+    }
+
+    private UnknownRecord createOBJRecord()
+    {
+        byte[] data = {
+            (byte) 0x15, (byte) 0x00, (byte) 0x12, (byte) 0x00, (byte) 0x05, (byte) 0x00, (byte) 0x02, (byte) 0x00, (byte) 0x11, (byte) 0x60, (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0xB8, (byte) 0x03,
+            (byte) 0x87, (byte) 0x03, (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x00, (byte) 0x00,
+        };
+
+        return new UnknownRecord( (short) 0x005D, (short) 0x001a, data );
+    }
+
+    private UnknownRecord createMSDrawingObjectRecord()
+    {
+        // Since we haven't created this object yet we'll just put in the raw
+        // form for the moment.
+
+        byte[] data = {
+            (byte)0x0F, (byte)0x00, (byte)0x02, (byte)0xF0, (byte)0xC0, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x10, (byte)0x00, (byte)0x08, (byte)0xF0, (byte)0x08, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x02, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x02, (byte)0x04, (byte)0x00, (byte)0x00, (byte)0x0F, (byte)0x00, (byte)0x03, (byte)0xF0, (byte)0xA8, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x0F, (byte)0x00, (byte)0x04, (byte)0xF0, (byte)0x28, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x01, (byte)0x00, (byte)0x09, (byte)0xF0, (byte)0x10, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x02, (byte)0x00, (byte)0x0A, (byte)0xF0, (byte)0x08, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x04, (byte)0x00, (byte)0x00, (byte)0x05, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x0F, (byte)0x00, (byte)0x04, (byte)0xF0, (byte)0x70, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x92, (byte)0x0C, (byte)0x0A, (byte)0xF0, (byte)0x08, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x02, (byte)0x04, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x0A, (byte)0x00, (byte)0x00, (byte)0x93, (byte)0x00, (byte)0x0B, (byte)0xF0, (byte)0x36, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x7F, (byte)0x00, (byte)0x04, (byte)0x01, (byte)0x04, (byte)0x01, (byte)0xBF, (byte)0x00, (byte)0x08, (byte)0x00, (byte)0x08, (byte)0x00, (byte)0x81, (byte)0x01, (byte)0x4E, (byte)0x00,
+            (byte)0x00, (byte)0x08, (byte)0x83, (byte)0x01, (byte)0x4D, (byte)0x00, (byte)0x00, (byte)0x08, (byte)0xBF, (byte)0x01, (byte)0x10, (byte)0x00, (byte)0x11, (byte)0x00, (byte)0xC0, (byte)0x01,
+            (byte)0x4D, (byte)0x00, (byte)0x00, (byte)0x08, (byte)0xFF, (byte)0x01, (byte)0x08, (byte)0x00, (byte)0x08, (byte)0x00, (byte)0x3F, (byte)0x02, (byte)0x00, (byte)0x00, (byte)0x02, (byte)0x00,
+            (byte)0xBF, (byte)0x03, (byte)0x00, (byte)0x00, (byte)0x08, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x10, (byte)0xF0, (byte)0x12, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00,
+            (byte)0x04, (byte)0x00, (byte)0xC0, (byte)0x02, (byte)0x0A, (byte)0x00, (byte)0xF4, (byte)0x00, (byte)0x0E, (byte)0x00, (byte)0x66, (byte)0x01, (byte)0x20, (byte)0x00, (byte)0xE9, (byte)0x00,
+            (byte)0x00, (byte)0x00, (byte)0x11, (byte)0xF0, (byte)0x00, (byte)0x00, (byte)0x00, (byte)0x00
+        };
+
+        return new UnknownRecord((short)0x00EC, (short)0x00C8, data);
+    }
+
+    private void createAxisRecords( List records )
+    {
+        records.add( createAxisParentRecord() );
+        records.add( createBeginRecord() );
+        records.add( createAxisRecord( AxisRecord.AXIS_TYPE_CATEGORY_OR_X_AXIS ) );
+        records.add( createBeginRecord() );
+        records.add( createCategorySeriesAxisRecord() );
+        records.add( createAxisOptionsRecord() );
+        records.add( createTickRecord1() );
+        records.add( createEndRecord() );
+        records.add( createAxisRecord( AxisRecord.AXIS_TYPE_VALUE_AXIS ) );
+        records.add( createBeginRecord() );
+        records.add( createValueRangeRecord() );
+        records.add( createTickRecord2() );
+        records.add( createAxisLineFormatRecord( AxisLineFormatRecord.AXIS_TYPE_MAJOR_GRID_LINE ) );
+        records.add( createLineFormatRecord(false) );
+        records.add( createEndRecord() );
+        records.add( createPlotAreaRecord() );
+        records.add( createFrameRecord2() );
+        records.add( createBeginRecord() );
+        records.add( createLineFormatRecord2() );
+        records.add( createAreaFormatRecord2() );
+        records.add( createEndRecord() );
+        records.add( createChartFormatRecord() );
+        records.add( createBeginRecord() );
+        records.add( createBarRecord() );
+        // unknown 1022
+        records.add( createLegendRecord() );
+        records.add( createBeginRecord() );
+        // unknown 104f
+        records.add( createTextRecord() );
+        records.add( createBeginRecord() );
+        // unknown 104f
+        records.add( createLinkedDataRecord() );
+        records.add( createEndRecord() );
+        records.add( createEndRecord() );
+        records.add( createEndRecord() );
+        records.add( createEndRecord() );
+    }
+
+    private LinkedDataRecord createLinkedDataRecord()
+    {
+        LinkedDataRecord r = new LinkedDataRecord();
+        r.setLinkType(LinkedDataRecord.LINK_TYPE_TITLE_OR_TEXT);
+        r.setReferenceType(LinkedDataRecord.REFERENCE_TYPE_DIRECT);
+        r.setCustomNumberFormat(false);
+        r.setIndexNumberFmtRecord((short)0);
+        r.setFormulaOfLink( new LinkedDataFormulaField() );
+        return r;
+    }
+
+    private TextRecord createTextRecord()
+    {
+        TextRecord r = new TextRecord();
+        r.setHorizontalAlignment(TextRecord.HORIZONTAL_ALIGNMENT_CENTER);
+        r.setVerticalAlignment(TextRecord.VERTICAL_ALIGNMENT_CENTER);
+        r.setDisplayMode((short)1);
+        r.setRgbColor(0x00000000);
+        r.setX(-37);
+        r.setY(-60);
+        r.setWidth(0);
+        r.setHeight(0);
+        r.setAutoColor(true);
+        r.setShowKey(false);
+        r.setShowValue(false);
+        r.setVertical(false);
+        r.setAutoGeneratedText(true);
+        r.setGenerated(true);
+        r.setAutoLabelDeleted(false);
+        r.setAutoBackground(true);
+        r.setRotation((short)0);
+        r.setShowCategoryLabelAsPercentage(false);
+        r.setShowValueAsPercentage(false);
+        r.setShowBubbleSizes(false);
+        r.setShowLabel(false);
+        r.setIndexOfColorValue((short)77);
+        r.setDataLabelPlacement((short)0);
+        r.setTextRotation((short)0);
+        return r;
+    }
+
+    private LegendRecord createLegendRecord()
+    {
+        LegendRecord r = new LegendRecord();
+        r.setXAxisUpperLeft(3542);
+        r.setYAxisUpperLeft(1566);
+        r.setXSize(437);
+        r.setYSize(213);
+        r.setType(LegendRecord.TYPE_RIGHT);
+        r.setSpacing(LegendRecord.SPACING_MEDIUM);
+        r.setAutoPosition(true);
+        r.setAutoSeries(true);
+        r.setAutoXPositioning(true);
+        r.setAutoYPositioning(true);
+        r.setVertical(true);
+        r.setDataTable(false);
+        return r;
+    }
+
+    private BarRecord createBarRecord()
+    {
+        BarRecord r = new BarRecord();
+        r.setBarSpace((short)0);
+        r.setCategorySpace((short)150);
+        r.setHorizontal(false);
+        r.setStacked(false);
+        r.setDisplayAsPercentage(false);
+        r.setShadow(false);
+        return r;
+    }
+
+    private ChartFormatRecord createChartFormatRecord()
+    {
+        ChartFormatRecord r = new ChartFormatRecord();
+        r.setXPosition(0);
+        r.setYPosition(0);
+        r.setWidth(0);
+        r.setHeight(0);
+        r.setVaryDisplayPattern(false);
+        return r;
+    }
+
+    private PlotAreaRecord createPlotAreaRecord()
+    {
+        PlotAreaRecord r = new PlotAreaRecord(  );
+        return r;
+    }
+
+    private AxisLineFormatRecord createAxisLineFormatRecord( short format )
+    {
+        AxisLineFormatRecord r = new AxisLineFormatRecord();
+        r.setAxisType( format );
+        return r;
+    }
+
+    private ValueRangeRecord createValueRangeRecord()
+    {
+        ValueRangeRecord r = new ValueRangeRecord();
+        r.setMinimumAxisValue( 0.0 );
+        r.setMaximumAxisValue( 0.0 );
+        r.setMajorIncrement( 0 );
+        r.setMinorIncrement( 0 );
+        r.setCategoryAxisCross( 0 );
+        r.setAutomaticMinimum( true );
+        r.setAutomaticMaximum( true );
+        r.setAutomaticMajor( true );
+        r.setAutomaticMinor( true );
+        r.setAutomaticCategoryCrossing( true );
+        r.setLogarithmicScale( false );
+        r.setValuesInReverse( false );
+        r.setCrossCategoryAxisAtMaximum( false );
+        r.setReserved( true );    // what's this do??
+        return r;
+    }
+
+    private TickRecord createTickRecord1()
+    {
+        TickRecord r = new TickRecord();
+        r.setMajorTickType( (byte) 2 );
+        r.setMinorTickType( (byte) 0 );
+        r.setLabelPosition( (byte) 3 );
+        r.setBackground( (byte) 1 );
+        r.setLabelColorRgb( 0 );
+        r.setZero1( (short) 0 );
+        r.setZero2( (short) 0 );
+        r.setZero3( (short) 45 );
+        r.setAutorotate( true );
+        r.setAutoTextBackground( true );
+        r.setRotation( (short) 0 );
+        r.setAutorotate( true );
+        r.setTickColor( (short) 77 );
+        return r;
+    }
+
+    private TickRecord createTickRecord2()
+    {
+        TickRecord r = createTickRecord1();
+        r.setZero3((short)0);
+        return r;
+    }
+
+    private AxisOptionsRecord createAxisOptionsRecord()
+    {
+        AxisOptionsRecord r = new AxisOptionsRecord();
+        r.setMinimumCategory( (short) -28644 );
+        r.setMaximumCategory( (short) -28715 );
+        r.setMajorUnitValue( (short) 2 );
+        r.setMajorUnit( (short) 0 );
+        r.setMinorUnitValue( (short) 1 );
+        r.setMinorUnit( (short) 0 );
+        r.setBaseUnit( (short) 0 );
+        r.setCrossingPoint( (short) -28644 );
+        r.setDefaultMinimum( true );
+        r.setDefaultMaximum( true );
+        r.setDefaultMajor( true );
+        r.setDefaultMinorUnit( true );
+        r.setIsDate( true );
+        r.setDefaultBase( true );
+        r.setDefaultCross( true );
+        r.setDefaultDateSettings( true );
+        return r;
+    }
+
+    private CategorySeriesAxisRecord createCategorySeriesAxisRecord()
+    {
+        CategorySeriesAxisRecord r = new CategorySeriesAxisRecord();
+        r.setCrossingPoint( (short) 1 );
+        r.setLabelFrequency( (short) 1 );
+        r.setTickMarkFrequency( (short) 1 );
+        r.setValueAxisCrossing( true );
+        r.setCrossesFarRight( false );
+        r.setReversed( false );
+        return r;
+    }
+
+    private AxisRecord createAxisRecord( short axisType )
+    {
+        AxisRecord r = new AxisRecord();
+        r.setAxisType( axisType );
+        return r;
+    }
+
+    private AxisParentRecord createAxisParentRecord()
+    {
+        AxisParentRecord r = new AxisParentRecord();
+        r.setAxisType( AxisParentRecord.AXIS_TYPE_MAIN );
+        r.setX( 479 );
+        r.setY( 221 );
+        r.setWidth( 2995 );
+        r.setHeight( 2902 );
+        return r;
+    }
+
+    private AxisUsedRecord createAxisUsedRecord( short numAxis )
+    {
+        AxisUsedRecord r = new AxisUsedRecord();
+        r.setNumAxis( numAxis );
+        return r;
+    }
+
+    private LinkedDataRecord createDirectLinkRecord()
+    {
+        LinkedDataRecord r = new LinkedDataRecord();
+        r.setLinkType( LinkedDataRecord.LINK_TYPE_TITLE_OR_TEXT );
+        r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_DIRECT );
+        r.setCustomNumberFormat( false );
+        r.setIndexNumberFmtRecord( (short) 0 );
+        r.setFormulaOfLink( new LinkedDataFormulaField() );
+        return r;
+    }
+
+    private FontIndexRecord createFontIndexRecord( int index )
+    {
+        FontIndexRecord r = new FontIndexRecord();
+        r.setFontIndex( (short) index );
+        return r;
+    }
+
+    private TextRecord createAllTextRecord()
+    {
+        TextRecord r = new TextRecord();
+        r.setHorizontalAlignment( TextRecord.HORIZONTAL_ALIGNMENT_CENTER );
+        r.setVerticalAlignment( TextRecord.VERTICAL_ALIGNMENT_CENTER );
+        r.setDisplayMode( TextRecord.DISPLAY_MODE_TRANSPARENT );
+        r.setRgbColor( 0 );
+        r.setX( -37 );
+        r.setY( -60 );
+        r.setWidth( 0 );
+        r.setHeight( 0 );
+        r.setAutoColor( true );
+        r.setShowKey( false );
+        r.setShowValue( true );
+        r.setVertical( false );
+        r.setAutoGeneratedText( true );
+        r.setGenerated( true );
+        r.setAutoLabelDeleted( false );
+        r.setAutoBackground( true );
+        r.setRotation( (short) 0 );
+        r.setShowCategoryLabelAsPercentage( false );
+        r.setShowValueAsPercentage( false );
+        r.setShowBubbleSizes( false );
+        r.setShowLabel( false );
+        r.setIndexOfColorValue( (short) 77 );
+        r.setDataLabelPlacement( (short) 0 );
+        r.setTextRotation( (short) 0 );
+        return r;
+    }
+
+    private TextRecord createUnknownTextRecord()
+    {
+        TextRecord r = new TextRecord();
+        r.setHorizontalAlignment( TextRecord.HORIZONTAL_ALIGNMENT_CENTER );
+        r.setVerticalAlignment( TextRecord.VERTICAL_ALIGNMENT_CENTER );
+        r.setDisplayMode( TextRecord.DISPLAY_MODE_TRANSPARENT );
+        r.setRgbColor( 0 );
+        r.setX( -37 );
+        r.setY( -60 );
+        r.setWidth( 0 );
+        r.setHeight( 0 );
+        r.setAutoColor( true );
+        r.setShowKey( false );
+        r.setShowValue( false );
+        r.setVertical( false );
+        r.setAutoGeneratedText( true );
+        r.setGenerated( true );
+        r.setAutoLabelDeleted( false );
+        r.setAutoBackground( true );
+        r.setRotation( (short) 0 );
+        r.setShowCategoryLabelAsPercentage( false );
+        r.setShowValueAsPercentage( false );
+        r.setShowBubbleSizes( false );
+        r.setShowLabel( false );
+        r.setIndexOfColorValue( (short) 77 );
+        r.setDataLabelPlacement( (short) 11088 );
+        r.setTextRotation( (short) 0 );
+        return r;
+    }
+
+    private DefaultDataLabelTextPropertiesRecord createDefaultTextRecord( short categoryDataType )
+    {
+        DefaultDataLabelTextPropertiesRecord r = new DefaultDataLabelTextPropertiesRecord();
+        r.setCategoryDataType( categoryDataType );
+        return r;
+    }
+
+    private SheetPropertiesRecord createSheetPropsRecord()
+    {
+        SheetPropertiesRecord r = new SheetPropertiesRecord();
+        r.setChartTypeManuallyFormatted( false );
+        r.setPlotVisibleOnly( true );
+        r.setDoNotSizeWithWindow( false );
+        r.setDefaultPlotDimensions( true );
+        r.setAutoPlotArea( false );
+        return r;
+    }
+
+    private SeriesToChartGroupRecord createSeriesToChartGroupRecord()
+    {
+        return new SeriesToChartGroupRecord();
+    }
+
+    private DataFormatRecord createDataFormatRecord()
+    {
+        DataFormatRecord r = new DataFormatRecord();
+        r.setPointNumber( (short) -1 );
+        r.setSeriesIndex( (short) 0 );
+        r.setSeriesNumber( (short) 0 );
+        r.setUseExcel4Colors( false );
+        return r;
+    }
+
+    private LinkedDataRecord createCategoriesLinkedDataRecord()
+    {
+        LinkedDataRecord r = new LinkedDataRecord();
+        r.setLinkType( LinkedDataRecord.LINK_TYPE_CATEGORIES );
+        r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET );
+        r.setCustomNumberFormat( false );
+        r.setIndexNumberFmtRecord( (short) 0 );
+        LinkedDataFormulaField formula = new LinkedDataFormulaField();
+        Stack tokens = new Stack();
+        Area3DPtg p = new Area3DPtg();
+        p.setExternSheetIndex( (short) 0 );
+        p.setFirstColumn( (short) 1 );
+        p.setLastColumn( (short) 1 );
+        p.setFirstRow( (short) 0 );
+        p.setLastRow( (short) 31 );
+        tokens.add( p );
+        formula.setFormulaTokens( tokens );
+        r.setFormulaOfLink( formula );
+        return r;
+    }
+
+    private LinkedDataRecord createValuesLinkedDataRecord()
+    {
+        LinkedDataRecord r = new LinkedDataRecord();
+        r.setLinkType( LinkedDataRecord.LINK_TYPE_VALUES );
+        r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET );
+        r.setCustomNumberFormat( false );
+        r.setIndexNumberFmtRecord( (short) 0 );
+        LinkedDataFormulaField formula = new LinkedDataFormulaField();
+        Stack tokens = new Stack();
+        Area3DPtg p = new Area3DPtg();
+        p.setExternSheetIndex( (short) 0 );
+        p.setFirstColumn( (short) 0 );
+        p.setLastColumn( (short) 0 );
+        p.setFirstRow( (short) 0 );
+        p.setLastRow( (short) 31 );
+        tokens.add( p );
+        formula.setFormulaTokens( tokens );
+        r.setFormulaOfLink( formula );
+        return r;
+    }
+
+    private LinkedDataRecord createTitleLinkedDataRecord()
+    {
+        LinkedDataRecord r = new LinkedDataRecord();
+        r.setLinkType( LinkedDataRecord.LINK_TYPE_TITLE_OR_TEXT );
+        r.setReferenceType( LinkedDataRecord.REFERENCE_TYPE_DIRECT );
+        r.setCustomNumberFormat( false );
+        r.setIndexNumberFmtRecord( (short) 0 );
+        r.setFormulaOfLink( new LinkedDataFormulaField() );
+        return r;
+    }
+
+    private SeriesRecord createSeriesRecord()
+    {
+        SeriesRecord r = new SeriesRecord();
+        r.setCategoryDataType( SeriesRecord.CATEGORY_DATA_TYPE_NUMERIC );
+        r.setValuesDataType( SeriesRecord.VALUES_DATA_TYPE_NUMERIC );
+        r.setNumCategories( (short) 32 );
+        r.setNumValues( (short) 31 );
+        r.setBubbleSeriesType( SeriesRecord.BUBBLE_SERIES_TYPE_NUMERIC );
+        r.setNumBubbleValues( (short) 0 );
+        return r;
+    }
+
+    private EndRecord createEndRecord()
+    {
+        return new EndRecord();
+    }
+
+    private AreaFormatRecord createAreaFormatRecord1()
+    {
+        AreaFormatRecord r = new AreaFormatRecord();
+        r.setForegroundColor( 16777215 );     // RGB Color
+        r.setBackgroundColor( 0 );            // RGB Color
+        r.setPattern( (short) 1 );             // TODO: Add Pattern constants to record
+        r.setAutomatic( true );
+        r.setInvert( false );
+        r.setForecolorIndex( (short) 78 );
+        r.setBackcolorIndex( (short) 77 );
+        return r;
+    }
+
+    private AreaFormatRecord createAreaFormatRecord2()
+    {
+        AreaFormatRecord r = new AreaFormatRecord();
+        r.setForegroundColor(0x00c0c0c0);
+        r.setBackgroundColor(0x00000000);
+        r.setPattern((short)1);
+        r.setAutomatic(false);
+        r.setInvert(false);
+        r.setForecolorIndex((short)22);
+        r.setBackcolorIndex((short)79);
+        return r;
+    }
+
+    private LineFormatRecord createLineFormatRecord( boolean drawTicks )
+    {
+        LineFormatRecord r = new LineFormatRecord();
+        r.setLineColor( 0 );
+        r.setLinePattern( LineFormatRecord.LINE_PATTERN_SOLID );
+        r.setWeight( (short) -1 );
+        r.setAuto( true );
+        r.setDrawTicks( drawTicks );
+        r.setColourPaletteIndex( (short) 77 );  // what colour is this?
+        return r;
+    }
+
+    private LineFormatRecord createLineFormatRecord2()
+    {
+        LineFormatRecord r = new LineFormatRecord();
+        r.setLineColor( 0x00808080 );
+        r.setLinePattern( (short) 0 );
+        r.setWeight( (short) 0 );
+        r.setAuto( false );
+        r.setDrawTicks( false );
+        r.setUnknown( false );
+        r.setColourPaletteIndex( (short) 23 );
+        return r;
+    }
+
+    private FrameRecord createFrameRecord1()
+    {
+        FrameRecord r = new FrameRecord();
+        r.setBorderType( FrameRecord.BORDER_TYPE_REGULAR );
+        r.setAutoSize( false );
+        r.setAutoPosition( true );
+        return r;
+    }
+
+    private FrameRecord createFrameRecord2()
+    {
+        FrameRecord r = new FrameRecord();
+        r.setBorderType( FrameRecord.BORDER_TYPE_REGULAR );
+        r.setAutoSize( true );
+        r.setAutoPosition( true );
+        return r;
+    }
+
+    private PlotGrowthRecord createPlotGrowthRecord( int horizScale, int vertScale )
+    {
+        PlotGrowthRecord r = new PlotGrowthRecord();
+        r.setHorizontalScale( horizScale );
+        r.setVerticalScale( vertScale );
+        return r;
+    }
+
+    private SCLRecord createSCLRecord( short numerator, short denominator )
+    {
+        SCLRecord r = new SCLRecord();
+        r.setDenominator( denominator );
+        r.setNumerator( numerator );
+        return r;
+    }
+
+    private BeginRecord createBeginRecord()
+    {
+        return new BeginRecord();
+    }
+
+    private ChartRecord createChartRecord( int x, int y, int width, int height )
+    {
+        ChartRecord r = new ChartRecord();
+        r.setX( x );
+        r.setY( y );
+        r.setWidth( width );
+        r.setHeight( height );
+        return r;
+    }
+
+    private UnitsRecord createUnitsRecord()
+    {
+        UnitsRecord r = new UnitsRecord();
+        r.setUnits( (short) 0 );
+        return r;
+    }
+}