Syntax
| Visual Basic (Declaration) | |
|---|---|
Public ReadOnly Property AlternatingRows As AlternatingRows | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As SheetView Dim value As AlternatingRows value = instance.AlternatingRows | |
| C# | |
|---|---|
public AlternatingRows AlternatingRows {get;} | |
Property Value
AlternatingRows objectRemarks
This property is available at run time only.
Use this property to return the alternating rows settings object for the spreadsheet data area or the spreadsheet headers. The settings are returned in an AlternatingRows object.
Example
This example assigns a SheetView object to the active sheet and adds another Alternating Row to the default value of 2. The colors of the rows are each set to a new value.
| C# | Copy Code |
|---|---|
FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView; sv.AlternatingRows.Count = 3; sv.AlternatingRows[0].BackColor = Color.Yellow; sv.AlternatingRows[1].BackColor = Color.GreenYellow; sv.AlternatingRows[2].BackColor = Color.Tomato; | |
| Visual Basic | Copy Code |
|---|---|
Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView sv.AlternatingRows.Count = 3 sv.AlternatingRows(0).BackColor = Color.Yellow sv.AlternatingRows(1).BackColor = Color.GreenYellow sv.AlternatingRows(2).BackColor = Color.Tomato | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
Reference
SheetView ClassSheetView Members
AlternatingRow Class
AlternatingRows Class