You might want to set up your sheet so that alternating rows have a different appearance. For example, in a ledger, alternating rows often have a green background. In Spread, you can set up multiple alternating row appearances, which are applied in sequence, starting with the first row.

Set up the alternating rows using an index into the alternating row appearances. It might help to think of the default row appearance as the first alternating row style (or style zero, because the index is zero-based). Set the other alternating row appearances to subsequent indexes.

The figure here shows the results for the example code given below for setting up alternating rows for every three rows.

For more details, refer to the AlternatingRow class.

Return to Customizing the Row or Column Appearance.

Using the Properties Window

1. At design time, in the Properties window, select the Spread component.
2. Select the Sheets property.
3. Click the button to display the SheetView Collection Editor.
4. Select the sheet for which you want to create alternating rows from the collection list.
5. Select the AlternatingRows property from the property list for that sheet.
6. If you want to add additional alternating rows patterns, set the Count property to the number of patterns you want.
7. Click the AlternatingRows property button to display the AlternatingRow Collection Editor.
8. Select alternating row pattern for which to set properties.
9. Set properties for the selected pattern using the property list.
10. Click OK to close the AlternatingRow Collection Editor.
11. Click OK to close the SheetView Collection Editor.

Using a Shortcut

1. Set the Count property for the AlternatingRows shortcut object.
2. Set the various appearance and other properties of the AlternatingRows shortcut object, such as the BackColor and ForeColor properties.
3. Create additional alternating row appearances by setting properties for additional AlternatingRows shortcut objects, increasing the index for each appearance you create.

Example

This example code creates a sheet that has three different appearance settings for rows. The first row uses the default appearance. The second row has a light blue background with navy text, and the third row has a light yellow background with navy text. This pattern repeats for all subsequent rows.

C#

Copy Code

fpSpread1.Sheets[0].AlternatingRows.Count = 3; fpSpread1.Sheets[0].AlternatingRows[0].BackColor = Color.RoyalBlue; fpSpread1.Sheets[0].AlternatingRows[0].ForeColor = Color.Navy; fpSpread1.Sheets[0].AlternatingRows[1].BackColor = Color.LightYellow; fpSpread1.Sheets[0].AlternatingRows[1].ForeColor = Color.Navy; fpSpread1.Sheets[0].AlternatingRows[2].BackColor = Color.Salmon; fpSpread1.Sheets[0].AlternatingRows[2].ForeColor = Color.Navy;

VB

Copy Code

FpSpread1.Sheets(0).AlternatingRows.Count = 3 FpSpread1.Sheets(0).AlternatingRows(0).BackColor = Color.RoyalBlue FpSpread1.Sheets(0).AlternatingRows(0).ForeColor = Color.Navy FpSpread1.Sheets(0).AlternatingRows(1).BackColor = Color.LightYellow FpSpread1.Sheets(0).AlternatingRows(1).ForeColor = Color.Navy FpSpread1.Sheets(0).AlternatingRows(2).BackColor = Color.Salmon FpSpread1.Sheets(0).AlternatingRows(2).ForeColor = Color.Navy

Using the Spread Designer

1. Select the sheet tab for the sheet for which you want to set the alternating rows.
2. From the property list for that sheet, in the Appearance category, select the AlternatingRows property.
3. If you want to add additional alternating rows patterns, set the Count property to the number of patterns you want.
4. Click the AlternatingRows button to display the AlternatingRow Collection Editor.
5. Select alternating row pattern for which to set properties.
6. Set properties for the selected pattern using the property list.
7. Click OK to close the AlternatingRow Collection Editor.
8. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer