By default the component displays a color in the empty areas not filled in with column or row headers. These are the header empty areas as illustrated in the figure.

To customize the color of the header empty area, you can use the SheetView HeaderGrayAreaColor property. You can add images to the empty area with the HeaderGrayAreaBackgroundImageUrl property.

Using the Properties Window

1. At design time, in the Properties window, select the Sheets property for the FpSpread component.
2. Click the button to display the SheetView Collection Editor.
3. In the Members list, select the sheet for which you want to set the color of the header empty area.
4. Select the HeaderGrayAreaColor property (or HeaderGrayAreaBackgroundImageUrl and select an image) in the property list, and then click the drop-down button to display the color picker.
5. Select a color in the color picker.
6. Click OK to close the editor.

Using Code

Set the HeaderGrayAreaBackgroundImageUrl property.

Example

This example code sets the color or image properties for the gray area.

// Set a color or an image for the gray area.
FpSpread1.Sheets[0].HeaderGrayAreaBackgroundImageUrl = "happy.bmp";
//FpSpread1.Sheets[0].HeaderGrayAreaColor = Color.BurlyWood; 

' Set a color or an image for the gray area.
FpSpread1.Sheets(0).HeaderGrayAreaBackgroundImageUrl = "happy.bmp
'FpSpread1.Sheets(0).HeaderGrayAreaColor = Color.BurlyWood 

Copyright © GrapeCity, inc. All rights reserved.