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


Glossary Item Box

Gets the sheet (SheetView object) that is binding to a data source.

Syntax

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

Property Value

SheetView object containing the sheet

Example

This example changes the background color of the first row in the configured column.
C#Copy Code
private void fpSpread1DataColumnConfigure(object sender, FarPoint.Win.Spread.DataColumnConfigureEventArgs e) 
{ 
       e.Sheet.Cells[0, e.Column].BackColor = Color.Yellow;
} 
Visual BasicCopy Code
Private Sub FpSpread1DataColumnConfigure(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.DataColumnConfigureEventArgs)
Handles FpSpread1.DataColumnConfigure
       e.Sheet.Cells(0, e.Column).BackColor = Color.Yellow
End Sub

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.