ComponentOne VSFlexGrid 8.0
CellBorder Method

Draws a border around and within the selected cells.

Syntax

[form!]VSFlexGrid.CellBorder Color As OLE_COLOR, Left As Integer, Top As Integer, Right As Integer, Bottom As Integer, Vertical As Integer, Horizontal As Integer

Remarks

The CellBorder method allows you to draw borders around groups of cells. It works on the current selection, so in order to use it, you must start by selecting the group of cells where the border is to be drawn. Then call the CellBorder method using the following parameters:

Color As OLE_COLOR

This parameter determines the color of the border.

Left, Top, Right, Bottom As Integer

These parameters specify the width, in pixels, of the border to be drawn around the selection. Specify zero to remove the border, or any negative number to preserve the existing border.

Vertical, Horizontal As Integer

These parameters specify the width, in pixels, of the borders to be drawn inside the selection in the vertical and horizontal directions. Specify zero to remove the border, or any negative number to preserve the width of the existing border.

For example, the code below draws blue borders around a selected range:

    Private Sub Form_Load()

        ' draw borders around a table

        fg.Select 1, 1, 4, 4

        fg.CellBorder RGB(0, 0, 125), 2, 3, 2, 2, 1, 1

   

        ' apply special formatting to first line of table

        fg.Select 1, 1, 1, 4

        fg.CellBorder RGB(0, 0, 125), -1, -1, -1, 3, 0, 0

       

    End Sub

The result looks like this:

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback