PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Characteristics of columns found in a Table control in a window
  • Movable column
  • Sortable column
  • Magnifier (Filter)
  • Adjustable column
  • Export and print
  • Limitations
  • Fixed column, anchored column
  • Fixed column
  • Anchored column
  • Progress Bar column
  • Description
  • Progress bar with a different upper bound for each row of the Table control
  • Properties that can be used on a Progress Bar cell
  • Memory column and Check Box column (memory Table control and browsing Table control loaded in memory)
  • Memory column and Check Box column
  • Style of Check Box columns
  • Other characteristics of Check Box columns
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
The columns are used to display information in a Table control. The same type of information is displayed in the same column.
WINDEVWindows Note: The columns found in the TreeView Table controls have the same characteristics as the columns found in the Table controls.
Versions 20 and later
Android The Table control (and its columns) is now available for the Android applications.
iPhone/iPad The Table control (and its columns) is now available for the iPhone/iPad applications.
New in version 20
Android The Table control (and its columns) is now available for the Android applications.
iPhone/iPad The Table control (and its columns) is now available for the iPhone/iPad applications.
Android The Table control (and its columns) is now available for the Android applications.
iPhone/iPad 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
    AndroidiPhone/iPad Not available.
  • Image
  • Progress bar
    Java Not available.
  • Numeric
  • Date
  • Static
  • Check box
    AndroidiPhone/iPad Not available.
  • Duration
    Android Not available.
  • Container
    (not available in Java and in WINDEV Mobile)
Note: To call gImage in a column, use a Text column.
WINDEVWindows MobileJava 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.
AndroidiPhone/iPad 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).
WINDEVWindows Mobile The "Sort options" button is used to define the characteristics of the sort on the Text columns.
and are used to find out the sort direction of the column.
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:
TableSortUsed to sort the content of a Table or TreeView Table control on one or more columns
TableSortChildUsed to sort a branch of a TreeView Table control on one or more columns (lexicographical sort).
WINDEVWindows Mobile An optional process 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.
WINDEVWindows MobileJava 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.
AndroidiPhone/iPad 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 the 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).
WINDEVWindows MobileJava 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:
TableSeekSeeks a value in a column of a memory Table, browsing Table or TreeView Table.
TableSeekChildSeeks a value in a column of a TreeView Table control, in a specified branch.
WINDEVWindows Mobile An optional process 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
WINDEV

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.
Note: 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
WINDEV

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.
Note: 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.
WINDEV

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.
Note: 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.
WINDEVWindowsWindows Mobile

Limitations

If a multiline column is used with the Ellipsis mode, the multiline mode will be disabled in this column.
Fixed column, anchored column
WINDEVWindowsWindows Mobile

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.
WINDEV Mobile This feature is not available in WINDEV Mobile.
WINDEVWindowsWindows 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 "GUI" tab of the description window of the column.
Progress Bar column
WINDEVWindowsAndroidiPhone/iPadWindows Mobile

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 the 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, ...
WINDEVWindowsAndroidiPhone/iPadWindows Mobile

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:
  1. Assign ..MaxValue to 100 for the column.
  2. In the display code of the row, perform the requested calculation:
    <NameProgressBarColumn> = <Value of Progress Bar>*100/<Max Value>
WINDEVWindowsAndroidiPhone/iPadWindows Mobile

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)
WINDEVWindowsWindows Mobile

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.
Note: 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.
WINDEVWindowsWindows Mobile

Style of Check Box columns

You have the ability to 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:
  1. Display the description window of Table control.
  2. 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
WINDEVWindowsWindows Mobile

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 ("Hide the checkmark if unchecked (read-only)" option in the "Details" tab of the description window of column or ..EmptyIfZero).
New in version 22
WINDEVWindowsWindows Mobile

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 ("Hide the checkmark if unchecked (read-only)" option in the "Details" tab of the description window of column or ..EmptyIfZero).
WINDEVWindowsWindows Mobile

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 ("Hide the checkmark if unchecked (read-only)" option in the "Details" tab of the description window of column or ..EmptyIfZero).
Related Examples:
Style for displaying the table cells 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.
Custom Calculations 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.
The Table/TreeView Table control (Progress Bar columns) 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
Minimum required version
  • Version 12
This page is also available for…
Comments
Table with create columns runtime
FiltraUsuarios("")

//AlteraNomeColunasQuery("TABLE_usuario","QRY_Select_All_Usuarios")

//usando a estrutura da query
sColuna is string = pTableNameControl+".COL_Column"
ItemList is string = HListItem( {pQueryName,indFile} , hLstDetail)
CountCampos is int = StringCount(ItemList,CRLF)

//c is int
//
//loop (CountCampos)
// c+=1
//
// //TableInsertColumn /// windev
//
//END


ItemList = Replace(ItemList,CRLF,";")
ItemList = Replace(ItemList,TAB,";")
x is int = 6
y is int = 0
VARTEXT is string
LOOP(CountCampos)
y+= 1
VARTEXT = ExtractString(ItemList,x,";",FromBeginning)
{sColuna+y,indControl}..Caption = VARTEXT
{sColuna+y,indControl}..Visible = True
x+= 6
END
BOLLER
Jun. 25 2018