public int NumeralVariant; //(Integer) The variant of the digit format to use.
/// <summary>
/// Constructor using all defaults for the style.
/// </summary>
public StyleInfo()
{
BColorLeft = BColorRight = BColorTop = BColorBottom = System.Drawing.Color.Black; // (Color) Color of the bottom border
BStyleLeft = BStyleRight = BStyleTop = BStyleBottom = BorderStyleEnum.None;
// _BorderWdith
BWidthLeft = BWidthRight = BWidthTop = BWidthBottom = 1;
BackgroundColor = System.Drawing.Color.Empty;
BackgroundColorText = string.Empty;
BackgroundGradientType = BackgroundGradientTypeEnum.None;
BackgroundGradientEndColor = System.Drawing.Color.Empty;
BackgroundImage = null;
FontStyle = FontStyleEnum.Normal;
_FontFamily = "Arial";
FontSize = 10;
FontWeight = FontWeightEnum.Normal;
TextDecoration = TextDecorationEnum.None;
TextAlign = TextAlignEnum.General;
VerticalAlign = VerticalAlignEnum.Top;
Color = System.Drawing.Color.Black;
ColorText = "Black";
PaddingLeft = PaddingRight = PaddingTop = PaddingBottom = 0;
LineHeight = 0;
Direction = DirectionEnum.LTR;
WritingMode = WritingModeEnum.lr_tb;
Language = "en-US";
UnicodeBiDirectional = UnicodeBiDirectionalEnum.Normal;
Calendar = CalendarEnum.Gregorian;
NumeralLanguage = Language;
NumeralVariant = 1;
}
public VerticalAlignment ConvertVerticalAlignment(VerticalAlignEnum va)
{
switch (va)
{
case VerticalAlignEnum.Middle:
return(VerticalAlignment.Center);
case VerticalAlignEnum.Bottom:
return(VerticalAlignment.Bottom);
default:
return(VerticalAlignment.Top);
}
}
/// <summary>
/// Gets the vertical alignment.
/// </summary>
/// <param name="v"></param>
/// <param name="def"></param>
/// <returns></returns>
public static VerticalAlignEnum GetVerticalAlign(string v, VerticalAlignEnum def)
{
VerticalAlignEnum va;
try
{
va = (VerticalAlignEnum)Enum.Parse(typeof(VerticalAlignEnum), v);
}
catch
{
va = def;
}
return(va);
}
public int NumeralVariant; //(Integer) The variant of the digit format to use.
/// <summary>
/// Constructor using all defaults for the style.
/// </summary>
public StyleInfo()
{
BColorLeft = BColorRight = BColorTop = BColorBottom = System.Drawing.Color.Black; // (Color) Color of the bottom border
BStyleLeft = BStyleRight = BStyleTop = BStyleBottom = BorderStyleEnum.None;
// _BorderWdith
BWidthLeft = BWidthRight = BWidthTop = BWidthBottom = 1;
BackgroundColor = System.Drawing.Color.Empty;
BackgroundColorText = string.Empty;
BackgroundGradientType = BackgroundGradientTypeEnum.None;
BackgroundGradientEndColor = System.Drawing.Color.Empty;
BackgroundImage = null;
FontStyle = FontStyleEnum.Normal;
_FontFamily = "Arial";
//WRP 291008 numFmtId should be 0 (Zero) for General format - will be interpreted as a string
//It has default values in Excel07 as per ECMA-376 standard (SEction 3.8.30) for Office Open XML Excel07
_Format = "General";
FontSize = 10;
FontWeight = FontWeightEnum.Normal;
PatternType = patternTypeEnum.None;
TextDecoration = TextDecorationEnum.None;
TextAlign = TextAlignEnum.General;
VerticalAlign = VerticalAlignEnum.Top;
Color = System.Drawing.Color.Black;
ColorText = "Black";
PaddingLeft = PaddingRight = PaddingTop = PaddingBottom = 0;
LineHeight = 0;
Direction = DirectionEnum.LTR;
WritingMode = WritingModeEnum.lr_tb;
Language = "en-US";
UnicodeBiDirectional = UnicodeBiDirectionalEnum.Normal;
Calendar = CalendarEnum.Gregorian;
NumeralLanguage = Language;
NumeralVariant = 1;
}
/// <summary>
/// Gets the vertical alignment.
/// </summary>
/// <param name="v"></param>
/// <param name="def"></param>
/// <returns></returns>
public static VerticalAlignEnum GetVerticalAlign(string v, VerticalAlignEnum def)
{
VerticalAlignEnum va;
switch (v.ToLower())
{
case "top":
va = VerticalAlignEnum.Top;
break;
case "middle":
va = VerticalAlignEnum.Middle;
break;
case "bottom":
va = VerticalAlignEnum.Bottom;
break;
default:
va = def;
break;
}
return(va);
}
/// <summary>
/// Gets the vertical alignment.
/// </summary>
/// <param name="v"></param>
/// <param name="def"></param>
/// <returns></returns>
public static VerticalAlignEnum GetVerticalAlign(string v, VerticalAlignEnum def)
{
VerticalAlignEnum va;
try
{
va = (VerticalAlignEnum)Enum.Parse(typeof(VerticalAlignEnum), v);
}
catch
{
va = def;
}
return va;
}
public int NumeralVariant; //(Integer) The variant of the digit format to use.
/// <summary>
/// Constructor using all defaults for the style.
/// </summary>
public StyleInfo()
{
BColorLeft = BColorRight = BColorTop = BColorBottom = System.Drawing.Color.Black; // (Color) Color of the bottom border
BStyleLeft = BStyleRight = BStyleTop = BStyleBottom = BorderStyleEnum.None;
// _BorderWdith
BWidthLeft = BWidthRight = BWidthTop = BWidthBottom = 1;
BackgroundColor = System.Drawing.Color.Empty;
BackgroundColorText = string.Empty;
BackgroundGradientType = BackgroundGradientTypeEnum.None;
BackgroundGradientEndColor = System.Drawing.Color.Empty;
BackgroundImage = null;
FontStyle = FontStyleEnum.Normal;
_FontFamily = "Arial";
//WRP 291008 numFmtId should be 0 (Zero) for General format - will be interpreted as a string
//It has default values in Excel07 as per ECMA-376 standard (SEction 3.8.30) for Office Open XML Excel07
_Format = "General";
FontSize = 10;
FontWeight = FontWeightEnum.Normal;
PatternType = patternTypeEnum.None;
TextDecoration = TextDecorationEnum.None;
TextAlign = TextAlignEnum.General;
VerticalAlign = VerticalAlignEnum.Top;
Color = System.Drawing.Color.Black;
ColorText = "Black";
PaddingLeft = PaddingRight = PaddingTop = PaddingBottom = 0;
LineHeight = 0;
Direction = DirectionEnum.LTR;
WritingMode = WritingModeEnum.lr_tb;
Language = "en-US";
UnicodeBiDirectional = UnicodeBiDirectionalEnum.Normal;
Calendar = CalendarEnum.Gregorian;
NumeralLanguage = Language;
NumeralVariant=1;
}
/// <summary>
/// Gets the vertical alignment.
/// </summary>
/// <param name="v"></param>
/// <param name="def"></param>
/// <returns></returns>
public static VerticalAlignEnum GetVerticalAlign(string v, VerticalAlignEnum def)
{
VerticalAlignEnum va;
switch (v.ToLower())
{
case "top":
va = VerticalAlignEnum.Top;
break;
case "middle":
va = VerticalAlignEnum.Middle;
break;
case "bottom":
va = VerticalAlignEnum.Bottom;
break;
default:
va = def;
break;
}
return va;
}
public int NumeralVariant; //(Integer) The variant of the digit format to use.
/// <summary>
/// Constructor using all defaults for the style.
/// </summary>
public StyleInfo()
{
BColorLeft = BColorRight = BColorTop = BColorBottom = System.Drawing.Color.Black; // (Color) Color of the bottom border
BStyleLeft = BStyleRight = BStyleTop = BStyleBottom = BorderStyleEnum.None;
// _BorderWdith
BWidthLeft = BWidthRight = BWidthTop = BWidthBottom = 1;
BackgroundColor = System.Drawing.Color.Empty;
BackgroundGradientType = BackgroundGradientTypeEnum.None;
BackgroundGradientEndColor = System.Drawing.Color.Empty;
BackgroundImage = null;
FontStyle = FontStyleEnum.Normal;
_FontFamily = "Arial";
FontSize = 10;
FontWeight = FontWeightEnum.Normal;
TextDecoration = TextDecorationEnum.None;
TextAlign = TextAlignEnum.Left;
VerticalAlign = VerticalAlignEnum.Top;
Color = System.Drawing.Color.Black;
PaddingLeft = PaddingRight = PaddingTop = PaddingBottom = 0;
LineHeight = 0;
Direction = DirectionEnum.LTR;
WritingMode = WritingModeEnum.lr_tb;
Language = "en-US";
UnicodeBiDirectional = UnicodeBiDirectionalEnum.Normal;
Calendar = CalendarEnum.Gregorian;
NumeralLanguage = Language;
NumeralVariant=1;
}
public void SetVerticalAlign(VerticalAlignEnum vertAlign)
{
verticalAlign = vertAlign;
}
