Characteristics of columns found in a Table control in a window

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Editors

Controls (window/page/report)

Controls

Table Column control

Characteristics of columns found in a Table control in a window

Overview

Characteristics of columns found in a Table control in a window

Fixed column, anchored column

Progress Bar column

Memory column and Check Box column (memory Table control and browsing Table control loaded in memory)

Related examples

See also

Characteristics of columns found in a Table control in a window

Overview

The columns are used to display information in a Table control. The same type of information is displayed in the same column.

Remark: The columns in the TreeView Table controls have the same characteristics as the columns in the Table controls.

Versions 20 and later

The Table control (and its columns) is now available for the Android applications.

The Table control (and its columns) is now available for the iPhone/iPad applications.

New in version 20

The Table control (and its columns) is now available for the Android applications.

The Table control (and its columns) is now available for the iPhone/iPad applications.

The Table control (and its columns) is now available for the Android applications.

The Table control (and its columns) is now available for the iPhone/iPad applications.

The following types of data can be displayed in a column:


Text Currency Time Combo Box Not available. Image Progress Bar Not available.	Numeric Date Static Check Box Not available. Duration Not available. Container (not available in Java and in WINDEV Mobile)

Remark: To call gImage in a column, use a Text column.

You have the ability to perform calculations on the content of one or more columns. See Managing the calculations in the columns of a Table control for more details.

Specific characteristics can be configured for each type of column.

The programming of each type of column corresponds to the programming of the corresponding control.

The following paragraphs present the main characteristics of the Table control columns displayed in a window, available regardless of the column type. For the columns of Table controls displayed in a page, see Characteristics of columns found in a Table control in a page.

Characteristics of columns found in a Table control in a window

Most characteristics of the columns found in a Table control are configured in the "General" tab of the characteristics of each column.

Movable column

The user will be able to move the column in the Table control and to change the order in which the columns are displayed.

The columns of the Table control cannot be moved.

Sortable column

The user will be able to sort the column via a click performed on its header. This option is available:

for all the columns found in a memory Table or Treeview Table control.
for some columns found in the browsing Table control (only the columns based on key items and not filtered).

The "Sort options" button is used to define the characteristics of the sort on the Text columns.

and

allow you to know the sort direction of the column at any time.

You have the ability to customize the images used. See Configuring the titles of the columns found in a Table control for more details.

Programming: The sort can also be performed by programming via the following functions:


TableSort	Used to sort the content of a Table or TreeView Table control on one or more columns
TableSortChild	Used to sort a branch of a TreeView Table control on one or more columns (lexicographical sort).

An optional event can also be managed: Whenever the column is sorted.

Magnifier (Filter)

The user will be able to implement a "Starts with" filter in the column. Only the elements starting with the letters typed for the column will be displayed.

Two methods are available:

The user types the sought word directly. This search is automatically performed in the sorted column.
A click performed in the header of the column with magnifier is used to display an edit control. The user will only have to type the sought word.

The user clicks the column header to display the popup menu.

In the popup menu, the user selects the maginfier:
In the input area that is displayed at the top of the Table control, the user types the sought word.

The magnifier is available:

for all the columns found in a memory Table control.
for the columns of browsing Table controls with automatic browse (only the sortable columns based on key items and not filtered).

Caution: The magnifier is not available:

for items associated with a multi-file link.
for the Table controls that use a non-proportional scrollbar ("Proportional scrollbar" unchecked in the "Details" tab of the description window of the Table control).

You have the ability to customize the image used for the magnifier. See Configuring the titles of the columns found in a Table control for more details.

Programming: This feature can be performed by programming via the following functions:


TableSeek	Seeks a value in a column of a memory Table, browsing Table or TreeView Table.
TableSeekChild	Seeks a value in a column of a TreeView Table control, in a specified branch.

An optional event can also be managed: Whenever performing a search with the column magnifier.

Adjustable column

The user will be able to resize the columns.

Programming: The columns can be resized by programming with TableAdjust.

Versions 22 and later

Export and print

The table column can be taken into account during the print and in the exports:

Always,
Never,
If the column is visible in the window.

Remark: This option will be taken into account:

when creating a report on Table/TreeView table.
when printing the table content via the "Print" option found in the popup menu.
when using the export options found in the popup menu of the table.
when using the export functions (TableToExcel, TableToClipboard, TableToText, TableToWord and TableToXML).

Programming: This option can be configured by programming with ..VisibleInExportAndPrint.

New in version 22

Export and print

The table column can be taken into account during the print and in the exports:

Always,
Never,
If the column is visible in the window.

Remark: This option will be taken into account:

when creating a report on Table/TreeView table.
when printing the table content via the "Print" option found in the popup menu.
when using the export options found in the popup menu of the table.
when using the export functions (TableToExcel, TableToClipboard, TableToText, TableToWord and TableToXML).

Programming: This option can be configured by programming with ..VisibleInExportAndPrint.

Export and print

The table column can be taken into account during the print and in the exports:

Always,
Never,
If the column is visible in the window.

Remark: This option will be taken into account:

when creating a report on Table/TreeView table.
when printing the table content via the "Print" option found in the popup menu.
when using the export options found in the popup menu of the table.
when using the export functions (TableToExcel, TableToClipboard, TableToText, TableToWord and TableToXML).

Programming: This option can be configured by programming with ..VisibleInExportAndPrint.

Fixed column, anchored column

Fixed column

A fixed column will always remain displayed during the horizontal scroll of the Table columns. If the column is not fixed, it will move along with the other columns. The fixed columns are always located on the left of the Table control.

The number of fixed columns can be defined in the description of the Table control ("Details" tab). The first x columns will be fixed.

This feature is not available in WINDEV Mobile.

Anchored column

The anchored column is the column onto which the anchoring options will be applied. The width of the column will evolve according to the size of the window and to the size of the Table control.

You have the ability to define:

the number of the anchored column in the "General" tab of the Table control description.
the anchor rate in width of a column in the "UI" tab of the description window of the column.

Progress Bar column

Description

The configuration of the progress bar is performed in the "General" tab of the column description. You can configure:

the initial value of the progress bar,
the maximum value of progress bar,
the active image and the background image.

The "Details" tab of the column description is used to configure the display of the progress percentage, ...

Progress bar with a different upper bound for each row of the Table control

You have the ability to display a progress bar with a different upper bound for each row. In this case, you must:

Assign ..MaxValue to 100 for the column.
In the display code of the row, perform the requested calculation:

<NameProgressBarColumn> = <Value of Progress Bar>*100/<Max Value>

Properties that can be used on a Progress Bar cell

You have the ability to use ..MaxValue and ..MinValue on the Progress Bar cells by using the following syntax:

<Column Name>[<Row Number>]..MaxValue = <Value>
<Column Name>[<Row Number>]..MinValue = <Value>

Memory column and Check Box column (memory Table control and browsing Table control loaded in memory)

Memory column and Check Box column

In a browsing Table control loaded in memory, you have the ability to create memory columns: these columns are not linked to a data file. These columns can display a calculation for example, ...

The "Check Box" columns in a browsing Table control loaded in memory are specific memory columns. When moving the scrollbar, the boxes that have been checked are automatically kept.

Remark: In a browsing Table control with direct access, the Check Box memory columns (not linked to an item) are not kept when scrolling the rows.

Style of Check Box columns

You can define the style of the check boxes found in the columns: you can choose the image that will be used when the option is selected, for example.

To define the style of Check Box columns:

Open the Table control description window.
In the "Style" tab, select the "Check Box column" element. You can:
- select the checkmark style among one of the preset styles.
- choose a specific image for representing the checkmark ("Checkmark style" option corresponding to "Checkmark image").

Versions 22 and later

Other characteristics of Check Box columns

The Check Box columns also propose the following features:

Popup menu used to check/uncheck the table rows and to filter them. See Popup menu of Check Box columns (AAF) for more details.
Ability not to display the box of unchecked check boxes in a read-only Table control (option "Hide the checkmark if unchecked (read-only)" in the "Details" tab of the description window of column or ..EmptyIfZero).

New in version 22

Other characteristics of Check Box columns

The Check Box columns also propose the following features:

Popup menu used to check/uncheck the table rows and to filter them. See Popup menu of Check Box columns (AAF) for more details.
Ability not to display the box of unchecked check boxes in a read-only Table control (option "Hide the checkmark if unchecked (read-only)" in the "Details" tab of the description window of column or ..EmptyIfZero).

Other characteristics of Check Box columns

The Check Box columns also propose the following features:

Popup menu used to check/uncheck the table rows and to filter them. See Popup menu of Check Box columns (AAF) for more details.
Ability not to display the box of unchecked check boxes in a read-only Table control (option "Hide the checkmark if unchecked (read-only)" in the "Details" tab of the description window of column or ..EmptyIfZero).

Related Examples:

Unit examples (WINDEV): Style for displaying the table cells

[ + ] Modifying the display style of table cells.
The ..BrushStyle property is used to hatch the cells or to create a color gradient with "tube" effect.

Unit examples (WINDEV): Custom Calculations

[ + ] Using a formula entered by the user in a Table control.
The formula is entered in the column and stored in a .INI file in order to be used whenever the table is displayed. The formula can be modified at any time by the user.

Unit examples (WINDEV): The Table/TreeView Table control (Progress Bar columns)

[ + ] Using a Progress Bar column as well as the ..TextProgressBar property in a Table or TreeView Table control