By default sheets display grid lines. You can set the color, the width, and the style of grid lines. In the following figure, the horizontal grid lines are flat and red, and the vertical grid lines are flat and green.

You can choose to display the grid lines as three-dimensional lines, with a highlight and shadow color. If you do so, set the highlight and shadow color to create the effect you want. For basic customization of grid lines, use the following properties of the GridLine class.

• Color - the color of the grid line
• HighlightColor - the highlight color for three-dimensional grid lines
• ShadowColor - the shadow color for three-dimensional grid lines
• Type - the type of grid line
• Width - the width in pixels of the grid line

The Color property is for flat lines, and the HighlightColor and ShadowColor property are for the other types of lines.

You can hide the grid line in a particular direction by setting the Type property of grid line to "None". Refer to the following line of code to hide horizontal grid line.

fpSpread1.ActiveSheet.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);

fpSpread1.ActiveSheet.HorizontalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None)

To customize other properties, create a new GridLine object (rather than changing a property on the existing object).

For more details on how to work with the grid lines in code, refer to the examples below, the GridLine class, and HorizontalGridLine property or VerticalGridLine property of the SheetView 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. In the Members list, select the sheet for which you want to set the grid line color.
5. To set the horizontal grid line color,
   1. Select the HorizontalGridLine object in the property list.
   2. If you want to display three-dimensional grid lines, set the Type property to Lowered or Raised.
   3. If the grid lines are not three-dimensional, select the Color property, and then click the drop-down button to display the color picker. Select a color in the color picker.
   4. If the grid lines are three-dimensional, select the HighlightColor property, and then click the drop-down button to display the color picker. Select a color in the color picker. Do the same for the ShadowColor property.
6. To set the vertical grid line color,
   1. Select the VerticalGridLine object in the property list
   2. If you want to display three-dimensional grid lines, set the Type property to Lowered or Raised.
   3. If the grid lines are not three-dimensional, select the Color property, and then click the drop-down button to display the color picker. Select a color in the color picker.
   4. If the grid lines are three-dimensional, select the HighlightColor property, and then click the drop-down button to display the color picker. Select a color in the color picker. Do the same for the ShadowColor property.
7. Click OK to close the editor.

Using Code

1. Create a GridLine object, setting the color or colors and the style for the grid line in the constructor.
2. Assign the GridLine object to the specified sheet by setting the SheetView object HorizontalGridLine or VerticalGridLine property to the GridLine object you created in step 1.

Example

This example code sets the horizontal grid line color to red and the vertical grid line color to chartreuse. Both grid lines are flat.

FarPoint.Win.Spread.GridLine HGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Red);
FarPoint.Win.Spread.GridLine VGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Chartreuse);
fpSpread1.Sheets[0].HorizontalGridLine = HGridLine;
fpSpread1.Sheets[0].VerticalGridLine = VGridLine;

Dim HGridLine As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Red)
Dim VGridLine As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Chartreuse)
fpSpread1.Sheets(0).HorizontalGridLine = HGridLine
fpSpread1.Sheets(0).VerticalGridLine = VGridLine

Using the Spread Designer

1. Select the sheet tab for the sheet for which you want to set the grid line colors.
2. To set the horizontal grid line color,
   1. In the Appearance category, select the HorizontalGridLine object in the property list.
   2. If you want to display three-dimensional grid lines, set the Type property to Lowered or Raised.
   3. If the grid lines are not three-dimensional, select the Color property, and then click the drop-down button to display the color picker. Select a color in the color picker.
   4. If the grid lines are three-dimensional, select the HighlightColor property, and then click the drop-down button to display the color picker. Select a color in the color picker. Do the same for the ShadowColor property.
3. To set the vertical grid line color,
   1. In the Appearance category, select the VerticalGridLine object in the property list
   2. If you want to display three-dimensional grid lines, set the Type property to Lowered or Raised.
   3. If the grid lines are not three-dimensional, select the Color property, and then click the drop-down button to display the color picker. Select a color in the color picker.
   4. If the grid lines are three-dimensional, select the HighlightColor property, and then click the drop-down button to display the color picker. Select a color in the color picker. Do the same for the ShadowColor property.
4. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.