public ushort GetIndex(CellFont font)
{
string fontKey = font.ToString();
if (_indexLookup.ContainsKey(fontKey))
{
return _indexLookup[fontKey];
}
var f = new FONT
{
Height = font.Height,
ColorIndex = font.Color.Index,
Escapement = (ushort) font.Escapement,
UnderlineStyle = (byte) font.UnderlineStyle,
Family = (byte) font.Family,
CharacterSet = 1,
Name = font.Name,
Bold = font.Bold,
Italic = font.Italic,
Strikethrough = font.Strikethrough,
Outlined = font.Outlined,
Shadowed = font.Shadowed,
Condensed = font.Condensed,
Extended = font.Extended
};
_fonts.Add(f);
_indexLookup.Add(fontKey, (ushort) (_fonts.Count - 1));
return (ushort) (_fonts.Count - 1);
}
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";
checked
{
for (ushort num = 0; num < 21; num += 1)
{
XF xF = new XF();
xF.Attributes = 252;
xF.CellProtection = 65524;
xF.PatternColorIndex = 64;
xF.PatternBackgroundColorIndex = 130;
xF.FontIndex = 0;
xF.FormatIndex = num;
this.ExtendedFormats.Add(xF);
}
this.MaxNumberFormatIndex = 163;
this.GetXFIndex(CellFormat.General);
this.SharedStringTable = new SST();
}
}
/*
* Sunil Shenoi, 8-25-2008
*
* Assuming cell has a valid string vlaue, find the font record for a given characterIndex
* into the stringValue of the cell
*/
public static FONT getFontForCharacter(Cell cell, UInt16 charIndex)
{
FONT f = null;
int index = cell.Style.RichTextFormat.CharIndexes.BinarySearch(charIndex);
List <UInt16> fontIndexList = cell.Style.RichTextFormat.FontIndexes;
if (index >= 0)
{
// found the object, return the font record
f = getFontRecord(cell.SharedResource, fontIndexList[index]);
//Console.WriteLine("for charIndex={0}, fontIndex={1})", charIndex, fontIndexList[index]);
//Console.WriteLine("Object: {0} found at [{1}]", o, index);
}
else
{
// would have been inserted before the returned value, so insert just before it
if (~index == 0)
{
//f = getFontRecord(sheet,fontIndexList[0]);
//Console.WriteLine("for charIndex={0}, fontIndex=CELL", charIndex);
}
else
{
f = getFontRecord(cell.SharedResource, fontIndexList[(~index) - 1]);
//Console.WriteLine("for charIndex={0}, fontIndex={1})", charIndex, fontIndexList[(~index) - 1]);
}
//Console.WriteLine("Object: {0} not found. "
// + "Next larger object found at [{1}].", o, ~index);
}
return(f);
}
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 List <BOUNDSHEET> DecodeRecords(List <Record> records, out SharedResource sharedResource)
{
sharedResource = new SharedResource();
List <BOUNDSHEET> boundSheets = new List <BOUNDSHEET>();
foreach (Record record in records)
{
record.Decode();
switch (record.Type)
{
case RecordType.BOUNDSHEET:
boundSheets.Add(record as BOUNDSHEET);
break;
case RecordType.XF:
sharedResource.ExtendedFormats.Add(record as XF);
break;
case RecordType.FORMAT:
sharedResource.CellFormats.Add(record as FORMAT);
break;
case RecordType.SST:
sharedResource.SharedStringTable = record as SST;
break;
case RecordType.DATEMODE:
DATEMODE dateMode = record as DATEMODE;
switch (dateMode.Mode)
{
case 0:
sharedResource.BaseDate = Constants.WindowsBaseDate;
break;
case 1:
sharedResource.BaseDate = Constants.MacintoshBaseDate;
break;
}
break;
case RecordType.PALETTE:
PALETTE palette = record as PALETTE;
int colorIndex = 8;
foreach (int color in palette.Colors)
{
sharedResource.ColorPalette[colorIndex] = Color.FromArgb(color);
colorIndex++;
}
break;
case RecordType.FONT:
FONT f = record as FONT;
sharedResource.Fonts.Add(f);
break;
}
}
return(boundSheets);
}
public static FONT getFontForCharacter(Cell cell, ushort charIndex)
{
FONT result = null;
int num = cell.Style.RichTextFormat.CharIndexes.BinarySearch(charIndex);
List <ushort> fontIndexes = cell.Style.RichTextFormat.FontIndexes;
if (num >= 0)
{
result = WorksheetDecoder.getFontRecord(cell.SharedResource, fontIndexes[num]);
}
else
{
if (~num != 0)
{
result = WorksheetDecoder.getFontRecord(cell.SharedResource, fontIndexes[checked (~num - 1)]);
}
}
return(result);
}
public void Add(FONT font)
{
_fonts.Add(font);
}
public static Record Read(Stream stream)
{
Record record = Record.ReadBase(stream);
ushort type = record.Type;
Record result;
if (type <= 146)
{
if (type <= 49)
{
if (type <= 13)
{
if (type == 6)
{
result = new FORMULA(record);
return(result);
}
switch (type)
{
case 10:
result = new EOF(record);
return(result);
case 12:
result = new CALCCOUNT(record);
return(result);
case 13:
result = new CALCMODE(record);
return(result);
}
}
else
{
if (type == 34)
{
result = new DATEMODE(record);
return(result);
}
if (type == 41)
{
result = new BOTTOMMARGIN(record);
return(result);
}
if (type == 49)
{
result = new FONT(record);
return(result);
}
}
}
else
{
if (type <= 93)
{
switch (type)
{
case 60:
result = new CONTINUE(record);
return(result);
case 61:
result = new WINDOW1(record);
return(result);
case 62:
case 63:
case 65:
break;
case 64:
result = new BACKUP(record);
return(result);
case 66:
result = new CODEPAGE(record);
return(result);
default:
if (type == 85)
{
result = new DEFCOLWIDTH(record);
return(result);
}
if (type == 93)
{
result = new OBJ(record);
return(result);
}
break;
}
}
else
{
if (type == 125)
{
result = new COLINFO(record);
return(result);
}
if (type == 133)
{
result = new BOUNDSHEET(record);
return(result);
}
if (type == 146)
{
result = new PALETTE(record);
return(result);
}
}
}
}
else
{
if (type <= 237)
{
if (type <= 190)
{
if (type == 153)
{
result = new STANDARDWIDTH(record);
return(result);
}
switch (type)
{
case 189:
result = new MULRK(record);
return(result);
case 190:
result = new MULBLANK(record);
return(result);
}
}
else
{
switch (type)
{
case 214:
result = new RSTRING(record);
return(result);
case 215:
result = new DBCELL(record);
return(result);
case 216:
case 217:
break;
case 218:
result = new BOOKBOOL(record);
return(result);
default:
if (type == 224)
{
result = new XF(record);
return(result);
}
switch (type)
{
case 233:
result = new BITMAP(record);
return(result);
case 235:
result = new MSODRAWINGGROUP(record);
return(result);
case 236:
result = new MSODRAWING(record);
return(result);
case 237:
result = new MSODRAWINGSELECTION(record);
return(result);
}
break;
}
}
}
else
{
if (type <= 545)
{
switch (type)
{
case 252:
result = new SST(record);
return(result);
case 253:
result = new LABELSST(record);
return(result);
case 254:
break;
case 255:
result = new EXTSST(record);
return(result);
default:
switch (type)
{
case 512:
result = new DIMENSIONS(record);
return(result);
case 513:
result = new BLANK(record);
return(result);
case 514:
case 516:
case 518:
break;
case 515:
result = new NUMBER(record);
return(result);
case 517:
result = new BOOLERR(record);
return(result);
case 519:
result = new STRING(record);
return(result);
case 520:
result = new ROW(record);
return(result);
default:
if (type == 545)
{
result = new ARRAY(record);
return(result);
}
break;
}
break;
}
}
else
{
if (type == 638)
{
result = new RK(record);
return(result);
}
if (type == 1054)
{
result = new FORMAT(record);
return(result);
}
if (type == 2057)
{
result = new BOF(record);
return(result);
}
}
}
}
result = record;
return(result);
}
private static List <BOUNDSHEET> DecodeRecords(List <Record> records, out SharedResource sharedResource)
{
sharedResource = new SharedResource();
List <BOUNDSHEET> list = new List <BOUNDSHEET>();
checked
{
foreach (Record current in records)
{
current.Decode();
ushort type = current.Type;
if (type <= 133)
{
if (type != 34)
{
if (type != 49)
{
if (type == 133)
{
list.Add(current as BOUNDSHEET);
}
}
else
{
FONT item = current as FONT;
sharedResource.Fonts.Add(item);
}
}
else
{
DATEMODE dATEMODE = current as DATEMODE;
switch (dATEMODE.Mode)
{
case 0:
sharedResource.BaseDate = DateTime.Parse("1899-12-31");
break;
case 1:
sharedResource.BaseDate = DateTime.Parse("1904-01-01");
break;
}
}
}
else
{
if (type <= 224)
{
if (type != 146)
{
if (type == 224)
{
sharedResource.ExtendedFormats.Add(current as XF);
}
}
else
{
PALETTE pALETTE = current as PALETTE;
int num = 8;
foreach (int current2 in pALETTE.Colors)
{
sharedResource.ColorPalette[num] = Color.FromArgb(current2);
num++;
}
}
}
else
{
if (type != 252)
{
if (type == 1054)
{
sharedResource.CellFormats.Add(current as FORMAT);
}
}
else
{
sharedResource.SharedStringTable = (current as SST);
}
}
}
}
return(list);
}
}
