internal int CloneStyle(ExcelStyles style, int styleID, bool isNamedStyle)
{
ExcelXfs xfs;
if (isNamedStyle)
{
xfs = style.CellStyleXfs[styleID];
}
else
{
xfs = style.CellXfs[styleID];
}
ExcelXfs newXfs=xfs.Copy(this);
//Numberformat
if (xfs.NumberFormatId > 0)
{
string format="";
foreach (var fmt in style.NumberFormats)
{
if (fmt.NumFmtId == xfs.NumberFormatId)
{
format=fmt.Format;
break;
}
}
int ix=NumberFormats.FindIndexByID(format);
if (ix<0)
{
ExcelNumberFormatXml item = new ExcelNumberFormatXml(NameSpaceManager) { Format = format, NumFmtId = NumberFormats.NextId++ };
NumberFormats.Add(format, item);
ix=item.NumFmtId;
}
newXfs.NumberFormatId= ix;
}
//Font
if (xfs.FontId > -1)
{
int ix=Fonts.FindIndexByID(xfs.Font.Id);
if (ix<0)
{
ExcelFontXml item = style.Fonts[xfs.FontId].Copy();
ix=Fonts.Add(xfs.Font.Id, item);
}
newXfs.FontId=ix;
}
//Border
if (xfs.BorderId > -1)
{
int ix = Borders.FindIndexByID(xfs.Border.Id);
if (ix < 0)
{
ExcelBorderXml item = style.Borders[xfs.BorderId].Copy();
ix = Borders.Add(xfs.Border.Id, item);
}
newXfs.BorderId = ix;
}
//Fill
if (xfs.FillId > -1)
{
int ix = Fills.FindIndexByID(xfs.Fill.Id);
if (ix < 0)
{
var item = style.Fills[xfs.FillId].Copy();
ix = Fills.Add(xfs.Fill.Id, item);
}
newXfs.FillId = ix;
}
//Named style reference
if (xfs.XfId > 0)
{
var id = style.CellStyleXfs[xfs.XfId].Id;
var newId = CellStyleXfs.FindIndexByID(id);
//if (newId < 0)
//{
// newXfs.XfId = CloneStyle(style, xfs.XfId, true);
//}
//else
//{
newXfs.XfId = newId;
//}
}
int index;
if (isNamedStyle)
{
index = CellStyleXfs.Add(newXfs.Id, newXfs);
}
else
{
index = CellXfs.FindIndexByID(newXfs.Id);
if (index < 0)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
}
return index;
}
private int GetIdNumberFormat(eStyleProperty styleProperty, object value)
{
if (styleProperty == eStyleProperty.Format)
{
ExcelNumberFormatXml item=null;
if (!_styles.NumberFormats.FindByID(value.ToString(), ref item))
{
item = new ExcelNumberFormatXml(NameSpaceManager) { Format = value.ToString(), NumFmtId = _styles.NumberFormats.NextId++ };
_styles.NumberFormats.Add(value.ToString(), item);
}
return item.NumFmtId;
}
else
{
throw (new Exception("Invalid property for class Numberformat"));
}
}
/// <summary>
/// Loads the style XML to memory
/// </summary>
private void LoadFromDocument()
{
//NumberFormats
ExcelNumberFormatXml.AddBuildIn(NameSpaceManager, NumberFormats);
XmlNode numNode = _styleXml.SelectSingleNode(NumberFormatsPath, _nameSpaceManager);
if (numNode != null)
{
foreach (XmlNode n in numNode)
{
ExcelNumberFormatXml nf = new ExcelNumberFormatXml(_nameSpaceManager, n);
NumberFormats.Add(nf.Id, nf);
if (nf.NumFmtId >= NumberFormats.NextId) NumberFormats.NextId=nf.NumFmtId+1;
}
}
//Fonts
XmlNode fontNode = _styleXml.SelectSingleNode(FontsPath, _nameSpaceManager);
foreach (XmlNode n in fontNode)
{
ExcelFontXml f = new ExcelFontXml(_nameSpaceManager, n);
Fonts.Add(f.Id, f);
}
//Fills
XmlNode fillNode = _styleXml.SelectSingleNode(FillsPath, _nameSpaceManager);
foreach (XmlNode n in fillNode)
{
ExcelFillXml f;
if (n.FirstChild != null && n.FirstChild.LocalName == "gradientFill")
{
f = new ExcelGradientFillXml(_nameSpaceManager, n);
}
else
{
f = new ExcelFillXml(_nameSpaceManager, n);
}
Fills.Add(f.Id, f);
}
//Borders
XmlNode borderNode = _styleXml.SelectSingleNode(BordersPath, _nameSpaceManager);
foreach (XmlNode n in borderNode)
{
ExcelBorderXml b = new ExcelBorderXml(_nameSpaceManager, n);
Borders.Add(b.Id, b);
}
//cellStyleXfs
XmlNode styleXfsNode = _styleXml.SelectSingleNode(CellStyleXfsPath, _nameSpaceManager);
if (styleXfsNode != null)
{
foreach (XmlNode n in styleXfsNode)
{
ExcelXfs item = new ExcelXfs(_nameSpaceManager, n, this);
CellStyleXfs.Add(item.Id, item);
}
}
XmlNode styleNode = _styleXml.SelectSingleNode(CellXfsPath, _nameSpaceManager);
for (int i = 0; i < styleNode.ChildNodes.Count; i++)
{
XmlNode n = styleNode.ChildNodes[i];
ExcelXfs item = new ExcelXfs(_nameSpaceManager, n, this);
CellXfs.Add(item.Id, item);
}
//cellStyle
XmlNode namedStyleNode = _styleXml.SelectSingleNode(CellStylesPath, _nameSpaceManager);
if (namedStyleNode != null)
{
foreach (XmlNode n in namedStyleNode)
{
ExcelNamedStyleXml item = new ExcelNamedStyleXml(_nameSpaceManager, n, this);
NamedStyles.Add(item.Name, item);
}
}
//dxfsPath
XmlNode dxfsNode = _styleXml.SelectSingleNode(dxfsPath, _nameSpaceManager);
if (dxfsNode != null)
{
foreach (XmlNode x in dxfsNode)
{
ExcelDxfStyleConditionalFormatting item = new ExcelDxfStyleConditionalFormatting(_nameSpaceManager, x, this);
Dxfs.Add(item.Id, item);
}
}
}