FarPoint's Spread for Windows Forms Product Tour

The style model includes appearance settings, whether determined in the Spread Designer, or set as properties in the Properties List or as inherited by a custom skin for a whole sheet or by a custom style for individual cells.

The appearance settings may be set from any of the following classes in the Spread namespace that represent shortcut objects: Cell, Column, Row, AlternatingRow. They also may be set from any of these classes in the Spread namespace that affect style:

Appearance
DefaultSkins
NamedStyle
SheetSkin

Here is a list of the style properties that are included in the style model, which are basically the members of the StyleInfo class and affect the appearance or style of a cell:

BackColor
Border
CellType
Editor
Font
ForeColor
Formatter
HorizontalAlignment
Locked
Renderer
VerticalAlignment

Properties that correspond to StyleInfo properties are stored in the style model through the ISheetStyleModel interface. Style properties can be set for a cell, row (column index -1), column (row index -1), or the entire model (column and row index -1). Properties that are NOT set in a cell are inherited from the row setting, or the column setting if the row has no setting, or the model default if the column also has no setting. The default is exposed through the DefaultStyle property (SheetView.DefaultStyle, ColumnHeader.DefaultStyle, and RowHeader.DefaultStyle). If you set or get a style property using Rows.Default or Rows[-1] or Columns.Default or Columns[-1], then you will actually be setting or getting the DefaultStyle property. This is because Column and Row always use row index -1 and column index -1 when accessing the style model, respectively, and so using a column index or a row index of -1 will be setting or getting the model default.

Have a question?

RSS Subscribe