public static AbstractRange ToHeading3(this AbstractRange range)
{
return(range.ToColorBackground(Heading3Background)
.ToColorForeground(Heading3Foreground)
.ToFontSize(Heading3FontSize)
.ToItalic());
}
public static AbstractRange ToHeading2(this AbstractRange range)
{
return(range.ToColorBackground(Heading2Background)
.ToColorForeground(Heading2Foreground)
.ToFontSize(Heading2FontSize)
.ToBold());
}
public static AbstractRange SetValue(this AbstractRange range, decimal value, bool emptyIfZero)
{
if (value != 0 || !emptyIfZero)
{
range.Value = value;
}
return(range);
}
public static AbstractRange SetValue(this AbstractRange range, DateTime?date)
{
if (date.HasValue)
{
range.Value = date.Value.ToShortDateString();
}
return(range);
}
public static AbstractRange SetBorders(this AbstractRange range, MultipleBorders borders, LineStyle lineStyle,
SpreadsheetColor borderColor = default(SpreadsheetColor))
{
range.Style.SetBorders(borders, lineStyle, borderColor);
return(range);
}
public static AbstractRange SetFormula(this AbstractRange range, string formula)
{
range.Formula = formula;
return(range);
}
public static AbstractRange SetHyperlink(this AbstractRange range, string locationUrl, bool isExternal = true)
{
range.Hyperlink.Location = locationUrl;
range.Hyperlink.IsExternal = isExternal;
return(range);
}
public static AbstractRange ToDate(this AbstractRange range)
{
range.Style.ToDate();
return(range);
}
public static AbstractRange SetValue(this AbstractRange range, string value, int indentLevel = 0)
{
range.Value = string.Format("{0}{1}",
new string(Convert.ToChar(" "), 3 * indentLevel), value);
return(range);
}
public static AbstractRange ToCurrency(this AbstractRange range, bool includeSymbol = true, bool includeChange = true)
{
range.Style.ToCurrency(includeSymbol, includeChange);
return(range);
}
public static AbstractRange ToPercent(this AbstractRange range)
{
range.Style.ToPercent();
return(range);
}
public static AbstractRange To2Digits(this AbstractRange range)
{
range.Style.To2Digits();
return(range);
}
public static AbstractRange ToColorBackground(this AbstractRange range, SpreadsheetColor color)
{
range.Style.ToColorBackground(color);
return(range);
}
public static AbstractRange ToFontSize(this AbstractRange range, int fontSize)
{
range.Style.ToFontSize(fontSize);
return(range);
}
public static AbstractRange ToUnderline(this AbstractRange range, UnderlineStyle underlineStyle = UnderlineStyle.Single)
{
range.Style.ToUnderline(underlineStyle);
return(range);
}
public static AbstractRange ToItalic(this AbstractRange range)
{
range.Style.ToItalic();
return(range);
}