/**
* 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<Record> records = new List<Record>();
records.Add( CreateMSDrawingObjectRecord() );
records.Add( CreateOBJRecord() );
records.Add( CreateBOFRecord() );
records.Add(new HeaderRecord(""));
records.Add(new FooterRecord(""));
records.Add( CreateHCenterRecord() );
records.Add( CreateVCenterRecord() );
records.Add( CreatePrintSetupRecord() );
// unknown 33
records.Add( CreateFontBasisRecord1() );
records.Add( CreateFontBasisRecord2() );
records.Add(new ProtectRecord(false));
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(EOFRecord.instance);
sheet.InsertChartRecords( records );
workbook.InsertChartRecord();
}
