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.
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.