Table View Properties 

The Table View object has the following properties:

Table View Properties

Name

Type

Description

Events

Long

Enables or disables events fired by the control.

BorderStyle

short

Sets the border style for the control. Possible values are:

   

Enable3D = 0

(Draws a 3D frame)

   

Simpleframe = 1

(Draws a simple frame)

ForeColor

OleColor

Defines the table foreground color. This color is used for displaying text.

BackColor

OleColor

Defines the table background color.

Enabled

Boolean

Enables or disables the entire control.

HWnd

Handle

Window handle of the control.

Parent

Handle

Window handle of the parent window.

Font

Object

Font object used as default font for displaying text.

ActiveColumn

Long

Returns or sets the column index for the active cell.

ActiveRow

Long

Returns or sets the row index for the active cell.

Columns

Object

Collection of all Column objects in the Table View. Read-only.

Rows

Object

Collection of all Row objects in the Table View. Read-only.

ColumnCount

Long

Number of columns.

RowCount

Long

Number of rows.

FixedColumns

Long

Number of fixed columns. Fixed columns are columns which do not scroll.

FixedRows

Long

Number of fixed rows. Fixed rows are rows which do not scroll.

Selection

Object

Returns or sets the current selection.

HideSelection

Boolean

Indicates whether the selected range should be highlighted when the control does not own the input focus.

ShowGridLines

Boolean

Indicates whether grid lines should be drawn.

ShowHScrollBar

Boolean

Indicates whether a horizontal scrollbar should be attached to the control.

ShowVScrollBar

Boolean

Indicates whether a vertical scrollbar should be attached to the control.

ShowRowHeaders

Boolean

Indicates whether a row header should be displayed. (See also Header property of row object).

ShowColHeaders

Boolean

Indicates whether a column header should be displayed

(see also Header property of column object).

EnableProtection

Boolean

Enables or disables the protection of cells, rows or columns.

SelectMode

CSelModeType

Sets or returns the current selection mode. Possible values are:

   

tavSelModeDisable = 1

No selection is possible.

   

tavSelModeCell = 2

Selection of single cells, rows and columns is possible.

   

tavSelModeRow = 3

Only entire rows may be selected.

   

tavSelModeCol = 4

Only entire columns may be selected.

DragDrop

CDragDropType

Sets or returns the current drag and drop mode.

(See also DropEnter, Drop, DragSourceFill and DragComplete events.)

Possible values are:

   

tavDragDropModeDisable = 1

Drag and Drop is disabled.

   

tavDragOnly = 2

The control may only be used as drag source.

   

tavDropOnly = 3

The control may only be used as drop target.

   

tavDragDropAll = 4

Full drag and drop is enabled.

Formula

Variant

Not implemented yet. Returns the same as Value.

Value

Variant

Returns the data of a single cell.

Data

Array of Variant

Sets or returns the entire data of the control in a two dimensional array. A single element of the array has type variant.

Cell

Object

Returns a Cell object. Read-only.

AutoConfig

CAutoConfig

Defines how the connection to a SAP Table object is established. Possible values are:

(See also Connecting Table Views and Table Objects.)

   

tavAutoConfigDisabled = 0

The connection is defined by the TableIndex property of the column and row objects .

   

tavAutoConfigRows = 1

The connection is defined by the TableIndex property of the column objects. Rows are automatically maintained by the connection.

   

tavAutoConfigCols = 2

The connection is defined by the TableIndex property of the row objects. Columns are automatically maintained by the connection.

   

tavAutoConfigAll = 3

The connection is automatically maintained by the connection.

Table

Object

Returns the SAP Table object connected to the view. (See also Connecting Table Views and Table Objects)