ExplorerBar Property

Returns or sets whether column headers are used to sort and/or move columns.

Syntax

[form!]VSFlexGrid.ExplorerBar[ = ExplorerBarSettings ]

Remarks

The ExplorerBar property allows users to use column headings to sort and move columns without any code. Valid settings are described below:

 

Constant

Value

Description

FlexExNone

0

No ExplorerBar. Fixed rows behave as usual.

FlexExSort

1

Users may sort columns by clicking on their headings.

FlexExMove

2

Users may move columns by dragging their headings.

FlexExSortAndMove

3

Users may sort and move columns.

FlexExSortShow

5

Users may sort columns by clicking on their headings. The control will show the current sorting order by drawing an arrow on the heading.

FlexExSortShowAndMove

7

Users may sort and move columns.  The control will show the current sorting order by drawing an arrow on the heading.

FlexExMoveRows

8

Users may move rows by dragging their headings (fixed cells on the left of each row).

 

Note that these values are a combination of binary flags and are not sequential. You may combine settings using the Or operator. For example:

  ' allow sorting, moving rows, and moving columns

  fg.ExplorerBar = flexExMoveRows Or flexExSortShowAndMove.

By default, the ExplorerBar works like the one in Microsoft's Internet Explorer. One click sorts the column in ascending order, the next in descending order. Any non-fixed column may be dragged to any non-fixed position. The control fires events that allow you to customize this behavior. The events are BeforeSort, AfterSort, BeforeMoveColumn, and AfterMoveColumn.

You must have at least one fixed row to be able to use the ExplorerBar's column moving and sorting capabilities, and at least one fixed column to use the row moving capability. To move rows by dragging non-fixed cells, see the DragRow method.

Data Type

ExplorerBarSettings (Enumeration)

Default Value

flexExNone (0)

See Also

VSFlexGrid Control