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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
Reference
SheetView ClassSheetView Members
AlternatingRow Class
AlternatingRows Class