Modify an Existing Style

Using Microsoft Excel

To update a style in Microsoft Excel 97-2003:

  1. On the Format menu, click Style.
  2. Select the style you want to modify from the Style name list.
  3. Click Modify.
  4. Select the style options that you want using the tabs in the Format Cells dialog.
  5. Click OK.
  6. Under Style includes, specify the style features you want.
  7. Click OK to save the style and apply it to the selected range.

Using Aspose.Cells

Aspose.Cells provides the Style.update method for updating an existing style.

To change a named style, whether created dynamically using Aspose.Cells or predefined, call the Style.update method to reflect any changes in style applied to a cell or range.

The Style.update method behaves like the OK button in the Style dialog: after making changes to an existing style, call to implement the change. If you have already applied a style to a range of cells, modify the style attributes and call the method, the formatting of those cells is updated automatically

Creating and Modifying a Style

This example creates a style object, applies it to a range of cells and modifies the style object. The modifications are automatically applied to the cell and the range the style was applied to.

Modifying an Existing Style

This example uses a simple template Excel file in which a style called Percent has already been applied to a range. The example:

  1. gets the style,
  2. creates a style object and
  3. modifies the style formatting.

The modifications are automatically applied to the range the style was applied to.