Apply Style

Spread.Services Documentation
Apply Style
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Customize User Interaction > Apply Style

In Spread.Services, a workbook possesses a set of styles that can be utilized to format cell appearance in individual worksheets for enhanced clarity and increased readability.

Applying style in a worksheet involves following tasks.

- Set Sheet Styling
- Create and Delete Named Style
- Get or Set Named Style

Some of the built-in styles in Spread.Services are listed below:

Category | Description | Properties
--- | --- | ---
Number Format | Cell number format. | IRange.NumberFormat

Alignment

Horizontal and vertical alignment of cell content, indentation,text wrap, text rotation and text shrinking.

IRange.AddIndent

IRange.IndentLevel

IRange.WrapText

IRange.ShrinkToFit

IRange.MergeCells

IRange.ReadingOrder

IRange.Orientation

Font | IRange.Font(IFont) | IRange.Font(IFont)
Borders | Cell border line styles and colors. | IRange.Borders(IBorders)
Fill | Cell pattern fill or gradient fill. | IRange.Interior(IInterior)
Protection | Cell protection options (Locked and Hidden) | IRange.Locked IRange.FormulaHidden

Apart from the built-in styles, you can also create custom styles with description for individual cells or a range of cells in a worksheet where you can define all the style attributes and properties including font, font size, number format, alignment etc.

Copyright © GrapeCity, inc. All rights reserved.