PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Overview
  • Characteristics of columns found in a Table control in a window
  • Image of column title
  • Movable column
  • Sortable column
  • Magnifier (Filter)
  • Adjustable 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)
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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.
Versions 20 and later
Android The Table control (and its columns) is now available for Android applications.
iPhone/iPad The Table control (and its columns) is now available for iPhone/iPad applications.
New in version 20
Android The Table control (and its columns) is now available for Android applications.
iPhone/iPad The Table control (and its columns) is now available for iPhone/iPad applications.
Android The Table control (and its columns) is now available for Android applications.
iPhone/iPad The Table control (and its columns) is now available for 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
  • Numeric
  • Date
  • Static
  • Check Box
    AndroidiPhone/iPad Not available.
  • Duration
    Android Not available.
  • Container
    (not available in Java and in WINDEV Mobile)
Remark: To call gImage in a column, use a Text column.
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.
Characteristics of columns

Image of column title

This option allows you to define the image that will be used as the background image of the column title.
AndroidiPhone/iPad Table control columns cannot have an image in the column title.

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).
Ascending sort and Descending sort allow you to know the sort direction of the column at any time.
You have the ability to customize the images used. For more details, see Configuring the titles of the columns found in a Table control.
Programming: The sort can also be performed through 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).

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.
AndroidiPhone/iPad The user clicks the column header to open the context menu.
  • In the context menu, the user selects the maginfier:
    Search magnifier
  • In the input area that is displayed at the top of the Table control, the user types the sought word.
    Edit the search
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).
Programming: This feature can be performed through 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.

Adjustable column

The user will be able to resize the columns.
Programming: The columns can be resized through programming with TableAdjust.
Fixed column, anchored column
Progress Bar column
AndroidiPhone/iPad

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, ...
AndroidiPhone/iPad

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 the MaxValue property 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>
AndroidiPhone/iPad

Properties that can be used on a Progress Bar cell

You can use the MaxValue and MinValue properties on the Progress Bar cells 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)
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
See also
Minimum version required
  • 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
25 Jun. 2018