Spread Windows Forms 7.0 Product Documentation
DefaultStyle Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : DefaultStyle Property


Glossary Item Box

Gets or sets a StyleInfo object for the default style of the sheet.

Syntax

Visual Basic (Declaration) 
Public Property DefaultStyle As StyleInfo
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As StyleInfo
 
instance.DefaultStyle = value
 
value = instance.DefaultStyle
C# 
public StyleInfo DefaultStyle {get; set;}

Property Value

StyleInfo object containing the style information

Remarks

If you are assigning the same color (for example) to every cell, it is best to set the color to the DefaultStyle of the SheetView object. If you are assigning different colors (for example) to every cell, set the styles directly in the StyleModel of the SheetView.

DefaultStyle and its related properties are wrapper object properties which get or set the style model's StyleInfo object (style property settings) for row -1 and column -1, which is inherited by all cells in the style model's GetCompositeInfo method unless overridden by another StyleInfo object setting at the column, row, or cell level.

  • SheetView.DefaultStyle operates on SheetView.DocumentsModels.Style and affects the client area cells in the sheet (all non header cells).
  • SheetView.ColumnHeader.DefaultStyle operates on SheetView.DocumentsModels.ColumnHeaderStyle and affects all column header cells in the sheet. 
  • SheetView.RowHeader.DefaultStyle operates on SheetView.DocumentsModels.RowHeaderStyle and affects all row header cells in the sheet.
  • SheetView.SheetCornerStyle gets or sets the style settings for the sheet corner area, which is used by SpreadView to paint the sheet corner.

All of those properties have corresponding Name properties for getting and setting style names for NamedStyle objects in SheetView.NamedStyles (that is, SheetView.DefaultStyleName, SheetView.SheetCornerStyleName, etc.).

Example

This example sets the background color and text color for the sheet based on the style information provided.
C#Copy Code
fpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.LightBlue;
Visual BasicCopy Code
FpSpread1.ActiveSheet.DefaultStyle.BackColor = Color.LightBlue

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.