///<summary>
///Determines if the two font settings supplied are the same.
///</summary>
protected internal static bool CompareFont(SpreadsheetStyle font1, SpreadsheetStyle font2)
{
if (!font1.Italic.Compare(font2.Italic))
{
return(false);
}
if (!font1.Bold.Compare(font2.Bold))
{
return(false);
}
if (!font1.Underline.Compare(font2.Underline))
{
return(false);
}
if (!font1.Color.Compare(font2.Color))
{
return(false);
}
if (!font1.FontSize.Compare(font2.FontSize))
{
return(false);
}
if (!font1.FontName.Compare(font2.FontName))
{
return(false);
}
if (!font1.FontFamily.Compare(font2.FontFamily))
{
return(false);
}
if (!font1.FontScheme.Compare(font2.FontScheme))
{
return(false);
}
return(true);
}
///<summary>
///Creates or gets an existing number format.
///</summary>
public static uint CreateNumberFormat(SpreadsheetStyle style, WorkbookStylesPart styles)
{
NumberingFormat formatMatch = null;
uint formatIndex = 0; //starts at 164
//Loop through and see if there is a matching border style
if (styles.Stylesheet.NumberingFormats != null)
{
foreach (var formatElement in styles.Stylesheet.NumberingFormats)
{
var format = (NumberingFormat)formatElement;
//If we have a match then use this font
if (SpreadsheetStyle.CompareNumberFormat(format, style))
{
formatMatch = format;
break;
}
formatIndex += Convert.ToUInt32(1);
}
}
//Add the new number format if not found
if (formatMatch == null)
{
NumberingFormat format = style.ToNumberFormat();
format.NumberFormatId = formatIndex + Convert.ToUInt32(164);
if (styles.Stylesheet.NumberingFormats == null)
{
styles.Stylesheet.NumberingFormats = new NumberingFormats();
}
styles.Stylesheet.NumberingFormats.AppendChild <NumberingFormat>(format);
styles.Stylesheet.NumberingFormats.Count = formatIndex + Convert.ToUInt32(1);
}
return(formatIndex + Convert.ToUInt32(164));
}
///<summary>
///Determines if the two format settings supplied are the same.
///</summary>
protected internal static bool CompareNumberFormat(NumberingFormat format1, SpreadsheetStyle format2)
{
return(CompareNumberFormat(new SpreadsheetStyle(format1), format2));
}
///<summary>
///Determines if the two alignment settings supplied are the same.
///</summary>
protected internal static bool CompareAlignment(Alignment alignment1, SpreadsheetStyle alignment2)
{
return(CompareAlignment(new SpreadsheetStyle(alignment1), alignment2));
}
///<summary>
///Determines if the two border settings supplied are the same.
///</summary>
protected internal static bool CompareBorder(Border border1, SpreadsheetStyle border2)
{
return(CompareBorder(new SpreadsheetStyle(border1), border2));
}
///<summary>
///Determines if the two fill settings supplied are the same.
///</summary>
protected internal static bool CompareFill(Fill fill1, SpreadsheetStyle fill2)
{
return(CompareFill(new SpreadsheetStyle(fill1), fill2));
}
///<summary>
///Determines if the two font settings supplied are the same.
///</summary>
protected internal static bool CompareFont(Font font1, SpreadsheetStyle font2)
{
return(CompareFont(new SpreadsheetStyle(font1), font2));
}