Edit this page
Available for: UI for ASP.NET AJAX | UI for ASP.NET MVC | UI for WPF | UI for WinForms | UI for Xamarin

Cell Styles

A cell style is a predefined set of formatting options, such as cell borders, fonts, font sizes and number formats. Using cell styles allows you to apply multiple format options in one step and also offers an easy approach to achieve consistency in cell formatting. When a style is updated, all the cells that has already applied this style will be updated with the new value.

Cell Style Properties

A cell style is represented by the SpreadCellStyle class. The properties of the class can be categorized in five groups: number, alignment, font, border and fill. Following are all properties distributed in their corresponding groups:

  • Number group

    • NumberFormat: Gets or sets the number format.
  • Alignment group

    • HorizontalAlignment: Gets or sets the horizontal alignment. The property is of type SpreadHorizontalAlignment.

    • VerticalAlignment: Gets or sets the vertical alignment. The property is of type SpreadVerticalAlignment.

    • Indent: Gets or sets the indent.

    • WrapText: Gets or sets a value indicating if the text in a cell should be line-wrapped within the cell.

  • Font group

    • ForeColor: Gets or sets the fore color. The property is of type SpreadThemableColor.

    • FontFamily: Gets or sets the font family. The property is of type SpreadThemableFontFamily.

    • FontSize: Gets or sets the size of the font.

    • IsBold: Gets or sets a value indicating whether the text is bold.

    • IsItalic: Gets or sets a value indicating whether the text is italic.

    • Underline: Gets or sets the underline type. The property is of type SpreadUnderlineType.

  • Border group

    • LeftBorder: Gets or sets the left border. The property is of type SpreadBorder.

    • RightBorder: Gets or sets the right border. The property is of type SpreadBorder.

    • TopBorder: Gets or sets the top border. The property is of type SpreadBorder.

    • BottomBorder: Gets or sets the bottom border. The property is of type SpreadBorder.

    • DiagonalUpBorder: Gets or sets the diagonal up border. The property is of type SpreadBorder.

    • DiagonalDownBorder: Gets or sets the diagonal down border. The property is of type SpreadBorder.

  • Fill group

In addition to the properties above, the SpreadCellStyle class exposes five Boolean properties that indicate whether the groups above will be applied:

  • ApplyNumberFormat

  • ApplyAlignment

  • ApplyFont

  • ApplyBorder

  • ApplyFill

  • ApplyProtection

When you apply a style to a cell with locally set properties, the end result is an addition of the style properties to the cell's local properties. The end result of such an addition of styles depends on which elements (groups) of the style have been selected as being applied when using the particular style. You can select a group to be applied along with the style by setting the appropriate property to true.

Example 1 shows what applying the Number group looks like.

[C#] Example 1: Get a built-in style and apply a number group

SpreadCellStyle style = workbook.CellStyles.GetByName("Good");
style.ApplyNumberFormat = true;

Through the API you can add, modify or remove styles from the CellStyles collection of IWorkbookExporter.

If you would like to set a particular property of a cell, you could do it through the cell format.

Create a Style

Creating a new style is pretty straight-forward. All you have to do is invoke the Add() method of workbook's CellStyles collection. The method returns an object of type SpreadCellStyle, which you can manipulate.

[C#] Example 2: Create SpreadCellStyle and apply it to a cell

SpreadBorder border = new SpreadBorder(SpreadBorderStyle.Thick, new SpreadThemableColor(new SpreadColor(255, 0, 0)));
SpreadCellStyle style = workbook.CellStyles.Add("MyStyle");

style.TopBorder = border;
style.BottomBorder = border;
style.DiagonalDownBorder = border;
style.DiagonalUpBorder = border;
style.LeftBorder = border;
style.RightBorder = border;
style.Fill = SpreadPatternFill.CreateSolidFill(new SpreadColor(255, 0, 0));
style.FontFamily = new SpreadThemableFontFamily(SpreadThemeFontType.Major);
style.FontSize = 22;
style.ForeColor = new SpreadThemableColor(new SpreadColor(0, 255, 0));
style.Underline = SpreadUnderlineType.DoubleAccounting;
style.IsBold = true;
style.IsItalic = true;
style.HorizontalAlignment = SpreadHorizontalAlignment.Fill;
style.Indent = 5;
style.VerticalAlignment = SpreadVerticalAlignment.Top;
style.WrapText = false;

cell.SetFormat(new SpreadCellFormat()
    CellStyle = style

Modify a Style

Modifying a style is even easier than creating one. All you need to do is retrieve the style from the CellStyles collection and set the properties you need.

Example 3 obtains the Bad style from the cell styles collection of a workbook and modifies it.

[C#] Example 3: Modify a built-in style

SpreadCellStyle style = workbook.CellStyles.GetByName("Bad");
style.IsBold = true;

See Also