private void AddDefaultStyleXFs()
{
XF xf = new XF(_doc);
xf.IsStyleXF = true;
xf.CellLocked = true; //TODO: Is this correct? Default Style XF is CellLocked? what's the origin of this line?
_xfs.Add(xf);
xf = (XF)xf.Clone();
xf.UseBackground = false;
xf.UseBorder = false;
xf.UseFont = true;
xf.UseMisc = false;
xf.UseNumber = false;
xf.UseProtection = false;
//Gotta have a 16th (index 15) XF for the Default Cell Format...
//See excelfileformat.pdf Sec. 4.6.2: The default cell format is always present
//in an Excel file, described by the XF record with the fixed index 15 (0-based).
//By default, it uses the worksheet/workbook default cell style, described by
//the very first XF record (index 0);
//Apparently Excel 2003 was okay without it, but 2007 chokes if it's not there.
for (int i = 0; i < 15; i++)
{
_xfs.Add((XF)xf.Clone());
}
}
internal ushort Add(XF xf)
{
_workbook.Fonts.Add(xf.Font);
_workbook.Formats.Add(xf.Format);
_workbook.Styles.Add(xf.Style);
//TODO: What happens if they try to re-add a Default (i.e. non-user) XF?
short xfId = GetId(xf);
if (xfId == -1)
{
xfId = (short)_xfs.Count;
_xfs.Add((XF)xf.Clone());
}
//NOTE: Not documented, but User-defined XFs must have a minimum
//index of 16 (0-based).
return((ushort)xfId);
}