internal int CloneStyle(ExcelStyles style, int styleID, bool isNamedStyle)
{
return CloneStyle(style, styleID, isNamedStyle, false);
}
internal int CloneStyle(ExcelStyles style, int styleID, bool isNamedStyle, bool allwaysAdd)
{
ExcelXfs xfs;
lock (style)
{
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
{
if (allwaysAdd)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
else
{
index = CellXfs.FindIndexByID(newXfs.Id);
if (index < 0)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
}
}
return index;
}
}
internal int CloneStyle(ExcelStyles style, int styleID, bool isNamedStyle, bool allwaysAdd)
{
ExcelXfs xfs;
lock (style)
{
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
{
if (allwaysAdd)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
else
{
index = CellXfs.FindIndexByID(newXfs.Id);
if (index < 0)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
}
}
return(index);
}
}
internal int CloneStyle(ExcelStyles style, int styleID)
{
return CloneStyle(style, styleID, false, false);
}
internal int CloneStyle(ExcelStyles style, int styleID, bool isNamedStyle)
{
return(CloneStyle(style, styleID, isNamedStyle, false));
}
internal int CloneStyle(ExcelStyles style, int styleID)
{
return(CloneStyle(style, styleID, false, false));
}
internal int CloneStyle(ExcelStyles style, int styleID, bool isNamedStyle, bool allwaysAdd)
{
ExcelXfs xfs;
lock (style)
{
if (isNamedStyle)
{
xfs = style.CellStyleXfs[styleID];
}
else
{
xfs = style.CellXfs[styleID];
}
ExcelXfs newXfs = xfs.Copy(this);
//Numberformat
if (xfs.NumberFormatId > 0)
{
//rake36: Two problems here...
//rake36: 1. the first time through when format stays equal to String.Empty, it adds a string.empty to the list of Number Formats
//rake36: 2. when adding a second sheet, if the numberformatid == 164, it finds the 164 added by previous sheets but was using the array index
//rake36: for the numberformatid
string format = string.Empty;
foreach (var fmt in style.NumberFormats)
{
if (fmt.NumFmtId == xfs.NumberFormatId)
{
format = fmt.Format;
break;
}
}
//rake36: Don't add another format if it's blank
if (!String.IsNullOrEmpty(format))
{
int ix = NumberFormats.FindIndexByID(format);
if (ix < 0)
{
var item = new ExcelNumberFormatXml(NameSpaceManager)
{
Format = format, NumFmtId = NumberFormats.NextId++
};
NumberFormats.Add(format, item);
//rake36: Use the just added format id
newXfs.NumberFormatId = item.NumFmtId;
}
else
{
//rake36: Use the format id defined by the index... not the index itself
newXfs.NumberFormatId = NumberFormats[ix].NumFmtId;
}
}
}
//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 = newId;
}
else if (style._wb != _wb && allwaysAdd == false) //Not the same workbook, copy the namedstyle to the workbook or match the id
{
var nsFind = style.NamedStyles.ToDictionary(d => (d.StyleXfId));
if (nsFind.ContainsKey(xfs.XfId))
{
var st = nsFind[xfs.XfId];
if (NamedStyles.ExistsKey(st.Name))
{
newXfs.XfId = NamedStyles.FindIndexByID(st.Name);
}
else
{
var ns = CreateNamedStyle(st.Name, st.Style);
newXfs.XfId = NamedStyles.Count - 1;
}
}
}
}
int index;
if (isNamedStyle)
{
index = CellStyleXfs.Add(newXfs.Id, newXfs);
}
else
{
if (allwaysAdd)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
else
{
index = CellXfs.FindIndexByID(newXfs.Id);
if (index < 0)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
}
}
return(index);
}
}
internal int CloneStyle(ExcelStyles style, int styleID, bool isNamedStyle, bool allwaysAdd)
{
ExcelXfs xfs;
lock (style)
{
if (isNamedStyle)
{
xfs = style.CellStyleXfs[styleID];
}
else
{
xfs = style.CellXfs[styleID];
}
ExcelXfs newXfs = xfs.Copy(this);
//Numberformat
if (xfs.NumberFormatId > 0)
{
//rake36: Two problems here...
//rake36: 1. the first time through when format stays equal to String.Empty, it adds a string.empty to the list of Number Formats
//rake36: 2. when adding a second sheet, if the numberformatid == 164, it finds the 164 added by previous sheets but was using the array index
//rake36: for the numberformatid
string format = string.Empty;
foreach (var fmt in style.NumberFormats)
{
if (fmt.NumFmtId == xfs.NumberFormatId)
{
format = fmt.Format;
break;
}
}
//rake36: Don't add another format if it's blank
if (!String.IsNullOrEmpty(format))
{
int ix = NumberFormats.FindIndexByID(format);
if (ix < 0)
{
var item = new ExcelNumberFormatXml(NameSpaceManager) { Format = format, NumFmtId = NumberFormats.NextId++ };
NumberFormats.Add(format, item);
//rake36: Use the just added format id
newXfs.NumberFormatId = item.NumFmtId;
}
else
{
//rake36: Use the format id defined by the index... not the index itself
newXfs.NumberFormatId = NumberFormats[ix].NumFmtId;
}
}
}
//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 = newId;
}
else if(style._wb!=_wb && allwaysAdd==false) //Not the same workbook, copy the namedstyle to the workbook or match the id
{
var nsFind = style.NamedStyles.ToDictionary(d => (d.StyleXfId));
if (nsFind.ContainsKey(xfs.XfId))
{
var st = nsFind[xfs.XfId];
if (NamedStyles.ExistsKey(st.Name))
{
newXfs.XfId = NamedStyles.FindIndexByID(st.Name);
}
else
{
var ns = CreateNamedStyle(st.Name, st.Style);
newXfs.XfId = NamedStyles.Count - 1;
}
}
}
}
int index;
if (isNamedStyle)
{
index = CellStyleXfs.Add(newXfs.Id, newXfs);
}
else
{
if (allwaysAdd)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
else
{
index = CellXfs.FindIndexByID(newXfs.Id);
if (index < 0)
{
index = CellXfs.Add(newXfs.Id, newXfs);
}
}
}
return index;
}
}
internal int CloneStyle(ExcelStyles style, int styleID)
{
ExcelXfs xfs=style.CellXfs[styleID];
ExcelXfs newXfs=xfs.Copy(this);
//Numberformat
if (xfs.NumberFormatId > -1)
{
string format = xfs.Numberformat.Format;
int ix=NumberFormats.FindIndexByID(format);
if (ix<0)
{
ExcelNumberFormatXml item = new ExcelNumberFormatXml(NameSpaceManager) { Format = format, NumFmtId = style.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)
{
ExcelFillXml item = style.Fills[xfs.FillId].Copy();
ix = Fills.Add(xfs.Fill.Id, item);
}
newXfs.FillId = ix;
}
int id = CellXfs.FindIndexByID(newXfs.Id);
if (id < 0)
{
id = CellXfs.Add(newXfs.Id, newXfs);
}
return id;
}
