internal SLDifferentialFormat TranslateToDifferentialFormat(SLStyle style)
{
style.Sync();
SLDifferentialFormat df = new SLDifferentialFormat();
if (style.HasNumberingFormat) df.FormatCode = style.FormatCode;
if (style.Font.Italic != null && style.Font.Italic.Value) df.Font.Italic = true;
if (style.Font.Bold != null && style.Font.Bold.Value) df.Font.Bold = true;
if (style.Font.HasUnderline) df.Font.Underline = style.Font.Underline;
if (style.Font.HasFontColor)
{
df.Font.clrFontColor = style.Font.clrFontColor.Clone();
df.Font.HasFontColor = true;
}
if (style.Font.Strike != null && style.Font.Strike.Value) df.Font.Strike = true;
if (style.HasBorder) df.Border = style.Border.Clone();
if (style.HasFill) df.Fill = style.Fill.Clone();
df.Sync();
return df;
}
internal SLDifferentialFormat TranslateToDifferentialFormat(SLHighlightCellsStyleValues style)
{
SLDifferentialFormat df = new SLDifferentialFormat();
switch (style)
{
case SLHighlightCellsStyleValues.LightRedFillWithDarkRedText:
df.Font.Condense = false;
df.Font.Extend = false;
df.Font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x00, 0x06);
df.Fill.SetPatternBackgroundColor(System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xC7, 0xCE));
break;
case SLHighlightCellsStyleValues.YellowFillWithDarkYellowText:
df.Font.Condense = false;
df.Font.Extend = false;
df.Font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x65, 0x00);
df.Fill.SetPatternBackgroundColor(System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xEB, 0x9C));
break;
case SLHighlightCellsStyleValues.GreenFillWithDarkGreenText:
df.Font.Condense = false;
df.Font.Extend = false;
df.Font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x00, 0x61, 0x00);
df.Fill.SetPatternBackgroundColor(System.Drawing.Color.FromArgb(0xFF, 0xC6, 0xEF, 0xCE));
break;
case SLHighlightCellsStyleValues.LightRedFill:
df.Fill.SetPatternBackgroundColor(System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xC7, 0xCE));
break;
case SLHighlightCellsStyleValues.RedText:
df.Font.Condense = false;
df.Font.Extend = false;
df.Font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x00, 0x06);
break;
case SLHighlightCellsStyleValues.RedBorder:
df.Border.SetLeftBorder(BorderStyleValues.Thin, System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x00, 0x06));
df.Border.SetRightBorder(BorderStyleValues.Thin, System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x00, 0x06));
df.Border.SetTopBorder(BorderStyleValues.Thin, System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x00, 0x06));
df.Border.SetBottomBorder(BorderStyleValues.Thin, System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x00, 0x06));
break;
}
df.Sync();
return df;
}
