private List <long> WriteGlobalStream(BinaryWriter writer)
{
writer.BaseStream.Write(Constants.GLOBAL1, 0, Constants.GLOBAL1.Length);
m_styleContainer.Write(writer);
writer.BaseStream.Write(Constants.GLOBAL3, 0, Constants.GLOBAL3.Length);
RecordFactory.PALETTE(writer, m_colors);
List <long> list = new List <long>();
foreach (WorksheetInfo worksheet in m_worksheets)
{
list.Add(writer.BaseStream.Position);
RecordFactory.BOUNDSHEET(writer, 0u, worksheet.SheetName);
}
if (m_externSheet != null)
{
RecordFactory.SUPBOOK(writer, (ushort)m_worksheets.Count);
RecordFactory.EXTERNSHEET(writer, m_externSheet);
foreach (WorksheetInfo worksheet2 in m_worksheets)
{
if (worksheet2.PrintTitle != null)
{
RecordFactory.NAME_PRINTTITLE(writer, worksheet2.PrintTitle);
}
}
}
if (m_drawingGroupContainer != null)
{
MsoDrawingGroup.WriteToStream(writer, m_drawingGroupContainer);
}
m_stringTable.Write(writer.BaseStream);
writer.BaseStream.Write(Constants.GLOBAL4, 0, Constants.GLOBAL4.Length);
return(list);
}
public ChartSheetContentSequence(IStreamReader reader)
: base(reader)
{
// reset id counter for chart groups
ChartFormatIdGenerator.Instance.StartNewChartsheetSubstream();
ChartAxisIdGenerator.Instance.StartNewChartsheetSubstream();
// CHARTSHEETCONTENT = [WriteProtect] [SheetExt] [WebPub] *HFPicture PAGESETUP PrintSize [HeaderFooter] [BACKGROUND] *Fbi *Fbi2 [ClrtClient] [PROTECTION]
// [Palette] [SXViewLink] [PivotChartBits] [SBaseRef] [MsoDrawingGroup] OBJECTS Units CHARTFOMATS SERIESDATA *WINDOW *CUSTOMVIEW [CodeName] [CRTMLFRT] EOF
// [WriteProtect]
if (BiffRecord.GetNextRecordType(reader) == RecordType.WriteProtect)
{
this.WriteProtect = (WriteProtect)BiffRecord.ReadRecord(reader);
}
// [SheetExt]
if (BiffRecord.GetNextRecordType(reader) == RecordType.SheetExt)
{
this.SheetExt = (SheetExt)BiffRecord.ReadRecord(reader);
}
// [WebPub]
if (BiffRecord.GetNextRecordType(reader) == RecordType.WebPub)
{
this.WebPub = (WebPub)BiffRecord.ReadRecord(reader);
}
// *HFPicture
while (BiffRecord.GetNextRecordType(reader) == RecordType.HFPicture)
{
this.HFPictures.Add((HFPicture)BiffRecord.ReadRecord(reader));
}
// PAGESETUP
this.PageSetupSequence = new PageSetupSequence(reader);
// PrintSize
if (BiffRecord.GetNextRecordType(reader) == RecordType.PrintSize)
{
this.PrintSize = (PrintSize)BiffRecord.ReadRecord(reader);
}
// [HeaderFooter]
if (BiffRecord.GetNextRecordType(reader) == RecordType.HeaderFooter)
{
this.HeaderFooter = (HeaderFooter)BiffRecord.ReadRecord(reader);
}
// [BACKGROUND]
if (BiffRecord.GetNextRecordType(reader) == RecordType.BkHim)
{
this.BackgroundSequence = new BackgroundSequence(reader);
}
// *Fbi
this.Fbis = new List <Fbi>();
while (BiffRecord.GetNextRecordType(reader) == RecordType.Fbi)
{
this.Fbis.Add((Fbi)BiffRecord.ReadRecord(reader));
}
// *Fbi2
this.Fbi2s = new List <Fbi2>();
while (BiffRecord.GetNextRecordType(reader) == RecordType.Fbi2)
{
this.Fbi2s.Add((Fbi2)BiffRecord.ReadRecord(reader));
}
// [ClrtClient]
if (BiffRecord.GetNextRecordType(reader) == RecordType.ClrtClient)
{
this.ClrtClient = (ClrtClient)BiffRecord.ReadRecord(reader);
}
// [PROTECTION]
this.ProtectionSequence = new ProtectionSequence(reader);
// [Palette]
if (BiffRecord.GetNextRecordType(reader) == RecordType.Palette)
{
this.Palette = (Palette)BiffRecord.ReadRecord(reader);
}
// [SXViewLink]
if (BiffRecord.GetNextRecordType(reader) == RecordType.SXViewLink)
{
this.SXViewLink = (SXViewLink)BiffRecord.ReadRecord(reader);
}
// [PivotChartBits]
if (BiffRecord.GetNextRecordType(reader) == RecordType.PivotChartBits)
{
this.PivotChartBits = (PivotChartBits)BiffRecord.ReadRecord(reader);
}
// [SBaseRef]
if (BiffRecord.GetNextRecordType(reader) == RecordType.SBaseRef)
{
this.SBaseRef = (SBaseRef)BiffRecord.ReadRecord(reader);
}
// [MsoDrawingGroup]
if (BiffRecord.GetNextRecordType(reader) == RecordType.MsoDrawingGroup)
{
this.MsoDrawingGroup = (MsoDrawingGroup)BiffRecord.ReadRecord(reader);
}
// OBJECTS
this.ObjectsSequence = new ObjectsSequence(reader);
// Units
this.Units = (Units)BiffRecord.ReadRecord(reader);
// CHARTFOMATS
this.ChartFormatsSequence = new ChartFormatsSequence(reader);
// SERIESDATA
this.SeriesDataSequence = new SeriesDataSequence(reader);
// *WINDOW
this.WindowSequences = new List <WindowSequence>();
while (BiffRecord.GetNextRecordType(reader) == RecordType.Window2)
{
this.WindowSequences.Add(new WindowSequence(reader));
}
// *CUSTOMVIEW
this.CustomViewSequences = new List <CustomViewSequence>();
// CUSTOMVIEW seems to be totally optional,
// so check for the existence of the next sequences
while (BiffRecord.GetNextRecordType(reader) != RecordType.CodeName &&
BiffRecord.GetNextRecordType(reader) != RecordType.CrtMlFrt &&
BiffRecord.GetNextRecordType(reader) != RecordType.EOF)
{
this.CustomViewSequences.Add(new CustomViewSequence(reader));
}
//this.CustomViewSequences = new List<CustomViewSequence>();
//while (BiffRecord.GetNextRecordType(reader) == RecordType.UserSViewBegin)
//{
// this.CustomViewSequences.Add(new CustomViewSequence(reader));
//}
// [CodeName]
if (BiffRecord.GetNextRecordType(reader) == RecordType.CodeName)
{
this.CodeName = (CodeName)BiffRecord.ReadRecord(reader);
}
// [CRTMLFRT]
if (BiffRecord.GetNextRecordType(reader) == RecordType.CrtMlFrt)
{
this.CrtMlfrtSequence = new CrtMlfrtSequence(reader);
}
// EOF
this.EOF = (EOF)BiffRecord.ReadRecord(reader);
}
