public SharedResource(bool newbook)
{
FONT font = new FONT();
font.Height = 200;
font.OptionFlags = 0;
font.ColorIndex = 32767;
font.Weight = 400;
font.Escapement = 0;
font.Underline = 0;
font.CharacterSet = 1;
font.Name = "Arial";
//Fonts.Add(font);
for (ushort i = 0; i < 21; i++) // required by MS Excel 2003
{
XF xf = new XF();
xf.Attributes = 252;
xf.CellProtection = 65524;
xf.PatternColorIndex = 64;
xf.PatternBackgroundColorIndex = 130;
xf.FontIndex = 0;
xf.FormatIndex = i;
ExtendedFormats.Add(xf);
}
MaxNumberFormatIndex = 163;
GetXFIndex(CellFormat.General);
SharedStringTable = new SST();
}
public SharedResource(bool newbook)
{
FONT font = new FONT();
font.Height = 200;
font.OptionFlags = 0;
font.ColorIndex = 32767;
font.Weight = 400;
font.Escapement = 0;
font.Underline = 0;
font.CharacterSet = 1;
font.Name = "Arial";
//Fonts.Add(font);
for (ushort i = 0; i < 21; i++) // required by MS Excel 2003
{
XF xf = new XF();
xf.Attributes = 252;
xf.CellProtection = 65524;
xf.PatternColorIndex = 64;
xf.PatternBackgroundColorIndex = 130;
xf.FontIndex = 0;
xf.FormatIndex = i;
ExtendedFormats.Add(xf);
}
MaxNumberFormatIndex = 163;
GetXFIndex(CellFormat.General);
SharedStringTable = new SST();
}
private static EXTSST CreateEXTSST(SST sst, int sstOffset)
{
EXTSST extSST = new EXTSST();
extSST.NumStrings = 8;
int counter = 0;
int totalLength = sstOffset + 0x0C;
int relativeLength = 0x0C;
foreach (string text in sst.StringList)
{
int stringLength = Record.GetStringDataLength(text);
if (relativeLength + stringLength > Record.MaxContentLength + 4)
{
totalLength += 4;
relativeLength = 4;
}
if (counter == 0)
{
StringOffset stringOffset = new StringOffset();
stringOffset.AbsolutePosition = (uint)totalLength;
stringOffset.RelativePosition = (ushort)relativeLength;
extSST.Offsets.Add(stringOffset);
}
counter++;
if (counter == extSST.NumStrings)
{
counter = 0;
}
totalLength += stringLength;
relativeLength += stringLength;
}
return(extSST);
}
private static EXTSST CreateEXTSST(SST sst, int sstOffset)
{
EXTSST extSST = new EXTSST();
extSST.NumStrings = 8;
int counter = 0;
int totalLength = sstOffset + 0x0C;
int relativeLength = 0x0C;
foreach (string text in sst.StringList)
{
int stringLength = Record.GetStringDataLength(text);
if (relativeLength + stringLength > Record.MaxContentLength + 4)
{
totalLength += 4;
relativeLength = 4;
}
if (counter == 0)
{
StringOffset stringOffset = new StringOffset();
stringOffset.AbsolutePosition = (uint)totalLength;
stringOffset.RelativePosition = (ushort)relativeLength;
extSST.Offsets.Add(stringOffset);
}
counter++;
if (counter == extSST.NumStrings)
{
counter = 0;
}
totalLength += stringLength;
relativeLength += stringLength;
}
return extSST;
}