FarPoint's Spread Developer Tour

You can choose to show the horizontal grid lines, the vertical grid lines, or both. You can have the grid lines display as solid or dotted lines and you can specify the color of the grid lines. By default, the background color of a cell overlaps (hides) the right and bottom sides of the cell's grid lines. You can specify that the complete grid lines display or that only the right or bottom sides are covered.

The following example removes the vertical grid lines

fpSpread1.GridShowHoriz = True fpSpread1.GridShowVert = False

Set the Grid Line / Gray Area Color

You can change the color of the grid lines. The gray area is the space between the spreadsheet and the edges of the fpSpread control. You can see the gray area when you scroll beyond the last row or column in the spreadsheet.

The following example changes the grid line color to blue and gray-area color of the spreadsheet to yellow.

' Define grid color fpSpread1.GridColor = &HFF0000 'Define the gray-area color fpSpread1.GrayAreaBackColor = &HC0FFFF

Change the 3D Appearance
The control can display a flat appearance, a raised three-dimensional appearance, or a raised three-dimensional appearance with an outline border. The following example changes the control's default border appearance `fpSpread1.Appearance = Appearance3DWithBorder`

Hide Selections When the Spreadsheet Does Not Have the Focus

By default, the spreadsheet displays the focus rectangle or selection highlighting when the spreadsheet does not have the focus. If you prefer, the spreadsheet can hide the focus rectangle or selection highlighting when the spreadsheet does not have the focus.

This example hides the focus rectangle or selection highlighting when the spreadsheet does not have the focus.

fpSpread1.RetainSelBlock = False

Prevent Flickering

By default, when you set a property or function that changes the spreadsheet's appearance or data, the spreadsheet automatically refreshes itself. However, when you make multiple changes or add large amounts of data, the spreadsheet appears as if it were flickering because the spreadsheet is redrawing itself multiple times. You can prevent these multiple spreadsheet redraws and flickering. Your application will also run faster.

The following example sets the ReDraw property to False, places text in three cells, and then sets the ReDraw property back to True to refresh the spreadsheet.

fpSpread1.ReDraw = False fpSpread1.Row = 0 fpSpread1.Col = 1 fpSpread1.Text = "Home" fpSpread1.Col = 2 fpSpread1.Text = "Auto" fpSpread1.Col = 3 fpSpread1.Text = "Phone" fpSpread1.ReDraw = True