Table

<< 点击显示目录 >>

主页  mappView帮助助手 > mapp View帮助信息 > Widgets  > Data  > Table  >

Table

Widget "Table" is used to display data in table form. Widget "Table" represents the core of the table and must be added first. Columns/Rows can be added to widget "Table" using widgets "TableItem" and "TableItemImageList".

logo_yoututbe_tutorial

Our YouTube channel includes a tutorial on this topic.

logo_use_case

For this widget, there are various use cases that explain how the widget can be used.

logo_online_tutorial

Our B&R Tutorial Portal includes tutorials on widget "Table" (GER/ENG). (access data)

The following properties cannot be used in compound widget "Mapping":

zIndex, left, top, height, width

Appearance

table_editor

table_browser

Editor

Web browser



Properties

Name

Type

Description

Bindable

Necessary

Default value

columnWidth

Size

Defines the width of the column.

 

 

100

dataOrientation

Direction

Specifies whether data should be listed by row (horizontally) or column (vertically).

 

 

vertical

ellipsis

Boolean

Defines whether a text that is too long should be indicated by an ellipsis, e.g. "This text is..." instead of "This text is too long".

For more information, see here.

 

 

false

enable

Boolean

Defines the usability of the widget. A disabled widget (enable=false) does not react to user interaction and does not trigger events. The "disabled..." style is displayed at runtime. The "enable" behavior is inherited from the container widgets to the child widgets.

check

 

true

multiLine

Boolean

Defines whether the text can be shown in multiple lines. If "wordWrap" has value true, a break is added to the text after a word or at an explicitly defined line break (\n) if necessary. For more information, see here.Defines whether the text can be shown in multiple lines.

If "wordWrap" has value true, a break is added to the text after a word or at an explicitly defined line break (\n) if necessary. For more information, see here.

 

 

false

offsetColumn

Integer

Defines the index of the first visible row.

The top row has index 0.

check

 

0

offsetRow

Integer

Defines the index of the first visible row.

The first row has index 0.

check

 

0

permissionOperate

RoleCollection

Defines the roles that are permitted to use the widget. For roles without sufficient rights, the widget does not react to user interaction and does not trigger events.

 

 

 

permissionView

RoleCollection

Defines the roles that are permitted to see the widget. For roles without sufficient rights, the widget is hidden.

 

 

 

rowHeight

Size

Defines the height of a row.

 

 

30

selectedColumn

Integer

Returns the index of the currently selected column.

check

 

0

selectedRow

Integer

Returns the index of the currently selected row.

check

 

0

selection

Boolean

Specifies whether a row or column can be selected.

(possible to select = true / not possible to select = false)

 

 

true

showHeader

Boolean

Visibility of the header.

If true, the header is visible.

 

 

true

showScrollbars

Boolean

This property controls the visibility of the scrollbar.

 

 

true

style

StyleReference

Reference to a customizable widget style.

check

 

default

filterConfiguration

String

Defines the filter settings.

Can only be modified using the configuration dialog box. A variable that receives the correct settings from the configuration dialog box must be bound. For more information, see here.

The filter function is not available for horizontal tables.

check

 

 

tableConfiguration

String

Specification of the configuration, visibility and usability of the table / table elements:

Example for visibility:

'{ "specRows": [ {"index":0,"visible": false}, {"index":2,"visible": false}, {"index":4,"visible": true} ], "specColumns": [ {"index":0, "visible": false}, {"index":1, "visible": true}, {"index":2,"visible": true} ] }'

Example for usability:

'{ "specRows": [ {"index":0,"disable": false}, {"index":2,"disable": false}, {"index":4,"disable": true} ], "specColumns": [ {"index":0, "disable": false}, {"index":1, "disable": true}, {"index":2,"disable": true} ] }'

Example for usability and visibility:

'{ "specRows": [ {"index":0,"visible":false,"disable": false}, {"index":2,"visible":true,"disable": false}, {"index":4,"visible":true,"disable": true} ], "specColumns": [ {"index":0, "visible":false,"disable": false}, {"index":1,"visible":false, "disable": true}, {"index":2,"visible":true,"disable": true} ] }'

Example for the configuration of entire sections:

'{"specRows": [ {"from":0, "to":10, "disable":true}, {"from":12, "to":12, "visible":false}, {"index":14, "visible":false}, {"from":25, "to":30, "visible":false, "disable":true}]}'

check

 

 

visible

Boolean

Defines the visibility of the widget. The widget can be hidden with visible=false. (visible = true, hidden = false). The "visible" behavior is inherited from the container widget to the child widgets.

check

 

true

wordWrap

Boolean

Defines whether a break will be added to the text after a word if necessary. This option has no effect if "multiLine" is set to value false. For more information, see here.Defines whether a break will be added to the text after a word if necessary.

This option has no effect if "multiLine" is set to value false. For more information, see here.

 

 

false

scrollLinkYRefId

WidgetReference

Defines a reference to another "Table" widget (using its ID), which can be scrolled vertically together with this "Table" widget.

 

 

 

scrollLinkXRefId

WidgetReference

Defines a reference to another "Table" widget (using its ID), which can be scrolled horizontally together with this "Table" widget.

 

 

 

zIndex

UInteger

zIndex determines the z-order of the widget. With overlapping widgets, the zIndex determines which widget is on the top and which one is on the bottom. The widget with the larger zIndex is on top, and the one with the smaller zIndex is on the bottom. The zIndex must be unique within a piece of content or a container widget. The zIndex is automatically assigned by the visual editor and can therefore be changed via the toolbar.

 

check

 

left

Integer

Absolute position measured from the left border of the surrounded element (e.g. container widget or content).

 

 

 

top

Integer

Absolute position measured from the top border of the surrounded element (e.g. container widget or content).

 

 

 

height

Size

Defines the total height of the widget in pixels.

A value in % refers to the height of the surrounding element.

 

 

300

width

Size

Defines the total width of the widget in pixels.

A value in % refers to the width of the surrounding element.

 

 

400

useTableStyling

Boolean

Defines whether the various columns in the table can be styled individually using a theme.

(Individual style = false / Same style = true)

 

 

true

maxHeight

Integer

Defines the maximum height of the table.

If height is greater than maxHeight, then maxHeight has no effect.

 

 

0

tooltip

String

Defines the text that should appear as information when the tooltip indicator is pressed.

A static text or a text from the text system can be used. For more information, see here.

Mode "Tooltip" must be enabled for this. There are two different options for this:

Using action "ShowTooltip"

Using action "Client system" ShowTooltips.

 

 

 

showSortingButton

Boolean

Defines whether the icon for sorting is displayed.

Sorting cannot be used in conjunction with continuously updating variables.

 

 

false

headerSize

UInteger

Defines the width or height of the header depending on the alignment of the widget. If the value is 0, the size is applied from properties rowHeight and columnWidth.

 

 

0

refreshRate

UInteger

Defines the rate (in milliseconds) at which the table is continuously updated with data.

This value should be adjusted with regard to the number of elements, rows/columns and hardware used.

It is recommended to work with a value ≥200. For more information, see here.

 

 

600

stopRefreshAtScroll

Boolean

Defines whether the values of the table are continuously updated while scrolling.

If "stopRefreshAtScroll=true", then table values are not updated while scrolling.

Updating will resume after scrolling.

This is advantageous if a lot of data is used on a low-end target system. For more information, see here.

 

 

false

initRefreshRate

Integer

Defines the rate (in milliseconds) at which the table is restored or refreshed.

This property becomes active through changes, such as disabling widget TableItem, updating tableConfiguration or initial instantiation.

 

 

0

busyIndicatorDelay

Integer

Defines the time (ms) until indicator "Busy" is displayed.

It is displayed immediately at 0.

At 1000, the indicator is only displayed after 1000 ms if it should still be displayed.

If the number is negative, indicator "Busy" is not displayed.

 

 

0

tabIndex

Integer

Property tabIndex is used to manage the tab order during keyboard operation.

For additional information, see Keyboard operation.

ENTER triggers event Click if tabIndex ≥0.

It is not possible to operate the widget with the keyboard.

 

 

-1

Styleable properties

Name

Type

Description

Default value

activeBackColor

Color

Defines the background color of the selected table entry.

#FF8800

activeBackGroundGradient

Gradient

Defines the background color of the selected table entry as a color gradient.

 

activeInputCellTextColor

Color

Defines the text color in a cell during a write operation.

#333333

activeInputCellInnerShadow

Shadow

This property can be used as an inner border.

Example: "0 0 0 5px #B5B5B5"

none

activeInputCellBackColor

Color

Defines the background color for selected input cells.

#FFFFFF

activeInputCellBackgroundGradient

Gradient

Defines the background color of selected input cells as a color gradient.

 

activeTextColor

Color

Defines the color used to display the text of selected entries.

#FFFFFF

backColor

Color

Defines the background color of the widget.

Transparent

backColorEvenColumn

Color

Defines the background color for even-numbered table entries in the column direction.

#EAEAEA

backGroundGradientEvenColumn

Gradient

Defines the background color as a color gradient for even-numbered table entries in the column direction.

 

backColorEvenRow

Color

Defines the background color for even-numbered table entries in the row direction.

#FFFFFF

backGroundGradientEvenRow

Gradient

Defines the background color as a color gradient for even-numbered table entries in the row direction.

 

backColorOddRow

Color

Defines the background color for odd-numbered table entries in the row direction.

#FCFCFC

backGroundGradientOddRow

Gradient

Defines the background color as a color gradient for odd-numbered table entries in the row direction.

 

backColorOddColumn

Color

Defines the background color for odd-numbered table entries in the column direction.

#FCFCFC

backGroundGradientOddColumn

Gradient

Defines the background color as a color gradient for odd-numbered table entries in the column direction.

 

backGroundGradient

Gradient

Defines the background color of the widget as a color gradient.

 

borderColor

Color

Defines the color of the border around the widget.

#C8C8C8

borderStyle

BorderStyle

Defines the style of the border around the widget. Borders can be unbroken, dashed or dotted.

none

borderWidth

PixelValCollection

Defines the width of the border around the widget.

0px

cellAlign

BackgroundPosition

Defines the orientation of the text in a cell.

center center

cellBorderStyle

BorderStyle

Defines the style of the table frame.

solid

cellBorderColor

Color

Defines the border color of a cell.

#C8C8C8

cellBorderWidth

PixelValCollection

Defines the border thickness of a cell.

0px 0px 1px 1px

cellPadding

Padding

Defines the spacing between the outer boundary of the table entry and its content. For more information, see here.

0px

cornerRadius

PixelValCollection

Defines the radius of the table's rounded corners.

0px

disabledActiveTextColor

Color

Defines the color used to display text in even-numbered table entries in the row direction in the disabled state.

#FFFFFF

disabledActiveBackColor

Color

Defines the background color of the selected table entry in the disabled state.

#C7C7C7

disabledActiveBackGroundGradient

Gradient

Defines the background color of the selected table entry in the disabled state as a color gradient.

 

disabledBackColor

Color

Defines the background color of the widget in the disabled state.

Transparent

disabledBackGroundGradient

Gradient

Defines the background color of the widget as a color gradient in the disabled state.

 

disabledBackColorEvenRow

Color

Defines the background color for even-numbered table entries in the row direction in the disabled state.

#EAEAEA

disabledBackColorEvenColumn

Color

Defines the background color for even-numbered table entries in the column direction in the disabled state.

#EAEAEA

disabledBackColorOddRow

Color

Defines the background color for odd-numbered table entries in the row direction in the disabled state.

#FFFFFF

disabledBackColorOddColumn

Color

Defines the background color for odd-numbered table entries in the column direction in the disabled state.

#FFFFFF

disabledBorderColor

Color

Defines the color of the border around the widget in the disabled state.

#C8C8C8

disabledCellBorderColor

Color

Border color of an inactive table.

#C8C8C8

disabledItemBorderColor

Color

Border color of an inactive table entry.

#C8C8C8

disabledHeaderTextColor

Color

Defines the color used to display the text in the header in the disabled state.

#C8C8C8

disabledHeaderBackColor

Color

Defines the background color of the header in the disabled state.

#FCFCFC

disabledHeaderGradient

Gradient

Defines the background color of the header as a color gradient in the disabled state.

 

disabledTextColor

Color

Defines the color of the text in the disabled state.

#C8C8C8

fontName

FontName

Defines the font used for the text shown.

Arial

fontSize

PixelVal

Defines the size of the font used to display the text.

14px

inputCellTextColor

Color

Defines the color used to display the text of the input cells.

#333333

inputCellInnerShadow

Shadow

This property can be used as an inner border for a cell.

Example: "0 0 0 5px #B5B5B5"

none

inputCellBackColor

Color

Defines the background color for input cells.

#FFFFFF

inputCellBackgroundGradient

Gradient

Defines the background color of input cells as a color gradient.

 

headerBackColor

Color

Defines the background color of the header.

#FCFCFC

headerGradient

Gradient

Defines the background color of the header as a color gradient.

 

headerTextColor

Color

Defines the color used to display the text in the header.

#333333

headerFontSize

PixelVal

Defines the size of the font used to display the text in the header.

14px

headerCellPadding

Padding

Defines the spacing between the outer boundary of the header entry and its contents. For more information, see here.

0px

textColor

Color

Defines the color used to display the text.

#333333

bold

Boolean

Defines whether the text is shown in bold.

false

italic

Boolean

Defines whether the text is shown in italics.

false

opacity

Opacity

Defines the transparency of the widget. The lower the value, the more transparent the widget.

1

shadow

Shadow

Defines the shadow of the widget.

none

sortingButtonColor

Color

Defines the color used to display the icons for sorting when not applied.

#ECECEC

sortingButtonActiveColor

Color

Defines the color used to display the icon for sorting when applied.

#5F8DD3

mouseDownBackColor

Color

Defines the background color of the table row only as long as it is pressed.

A selected row is not displayed in color mouseDown but in color backColor instead. If the "selected" properties are set, the mouseDown settings are not applied.

transparent

mouseDownBackGroundGradient

Gradient

Defines the background color of the line as a color gradient only as long as it is pressed.

A selected row is not displayed in the mouseDown color but in the backColor color instead. If the "selected" properties are set, the mouseDown settings are not applied.

 

 

mouseDownTextColor

Color

Defines the text color in the table row only as long as it is pressed.

A selected row is not displayed in the mouseDown color but in the backColor color instead. If the "selected" properties are set, the mouseDown settings are not applied.

transparent

Topics in this section:

Actions and events