Spread Windows Forms 11.0 Product Documentation
Creating Alternating Rows
Spread Windows Forms 11.0 Product Documentation > Developer's Guide > Customizing Row, Column, and Cell Appearance > Customizing the Row or Column Appearance > Creating Alternating Rows

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 following example code for setting up alternating rows for every three rows.

Alternating Rows Example

For more details, refer to the AlternatingRow class.

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 as shown in the following figure.

    Designer Row Edit

  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.