[]
        
(Showing Draft Content)

Cell Styles Dialog

You can set cell-specific styles in a worksheet using the Spread Designer. The cell styles dialog is located in the Home tab under the Styles ribbon group.

Spread WinForms displays the Cell Styles gallery and Style dialog for defining reusable worksheet formatting properties.

Adding a Style

You can apply a style in a cell by clicking on a style in the Styles group or clicking on the “More” dropdown arrow in the style gallery to choose from additional style formats.

Spread WinForms applies the Good cell style from the Styles gallery to the selected worksheet cell.

Removing a Style

You can remove an applied style by first selecting the cell which needs to change back to default. Choose the "Normal" style from the styles gallery.

Spread WinForms removes an applied cell style by selecting the worksheet cell and choosing Normal from the Styles gallery.

Creating a New Style

You can create a new style by choosing the “New Cell Styles” option at the bottom of the style gallery.

The option opens a Style dialog where you can select various style properties. The “Format” button opens the "Format cells" dialog where you can select the formats for the new style.

Spread WinForms opens the Style dialog, names a custom style, and adds it to the Styles gallery.

Style Context Menu

You can perform additional operations on a style by accessing its context menu. When you right-click on a cell style, the context menu displays the following items to choose from.

  • Apply: Choose to apply the style on the selected cell.

  • Modify: Choose to modify the selected style. The style dialog is shown where formatting properties can be chosen as well as the format can be modified.

  • Duplicate: Choose to create a duplicate of the selected style. The style dialog is shown where a new style name can be entered as well as any existing formatting property can be modified.

  • Delete: Choose to delete the selected style. Every style can be deleted except the "Normal" style.

Spread WinForms displays the cell style context menu with Apply, Modify, Duplicate, and Delete commands for style management.