PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Overview
  • Properties available in a window
  • Properties that can be used on the pivot table
  • Properties that can be used on a row, a column or a filter
  • Properties that can be used on a value displayed in a cell
  • Properties available in a report
  • Properties that can be used on the pivot table
  • Properties that can be used on a value displayed in a cell
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
A Pivot Table control can be handled in WLanguage:
  • in a window.
  • Versions 21 and later
    in a report.
    New in version 21
    in a report.
    in a report.
Properties available in a window

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:
Versions 09 and later
Anchor
New in version 09
Anchor
Anchor
The Anchor property is used to set the anchors of a control in a window, page or report.
Versions 09 and later
AnchorRateBottom
New in version 09
AnchorRateBottom
AnchorRateBottom
The AnchorRateBottom property is used to:
  • Find out the anchor rate when a control moves on the vertical axis.
  • Modify the anchor rate when a control moves on the vertical axis.
Versions 09 and later
AnchorRateHeight
New in version 09
AnchorRateHeight
AnchorRateHeight
The AnchorRateHeight property is used to:
  • Find out the vertical anchor rate of a control.
  • Modify the vertical anchor rate of a control.
Versions 09 and later
AnchorRateRight
New in version 09
AnchorRateRight
AnchorRateRight
The AnchorRateRight property is used to:
  • Find out the anchor rate when a control moves on the horizontal axis.
  • Modify the anchor rate when a control moves on the horizontal axis.
Versions 09 and later
AnchorRateWidth
New in version 09
AnchorRateWidth
AnchorRateWidth
The AnchorRateWidth property is used to:
  • Find out the anchor rate when a control (or a table column) stretches on the horizontal axis.
  • Modify the anchor rate when a control (or a table column) stretches on the horizontal axis.
Versions 21 and later
AutoLineWrap
New in version 21
AutoLineWrap
AutoLineWrap
The AutoLineWrap property is used to:
  • find out whether the line wrap is automatically supported in a multiline edit control or in a column found in a table (or in a treeview table).
  • indicate the line wrap management mode in a multiline edit control or in a column in a table (or in a treeview table)
Versions 15 and later
AutomaticTooltip
New in version 15
AutomaticTooltip
AutomaticTooltip
The AutomaticTooltip property is used enable or disable automatic tooltips on List Box, Table and TreeView Table controls.
Versions 09 and later
BackgroundColor
New in version 09
BackgroundColor
BackgroundColor
The BackgroundColor property is used to set the background color of a control, window, page or block of a report.
Versions 14 and later
BackgroundImageLine
New in version 14
BackgroundImageLine
BackgroundImageLine
The BackgroundImageLine property is used to get and change the background image of each row:
  • of a Table control,
  • of a TreeView Table control,
  • of a Looper control.
Versions 14 and later
Border
New in version 14
Border
Border
The Border property is used to get and change the characteristics of the borders:
  • for a report control or block.
  • for a window control.
  • for a cell of a Table control.
Versions 09 and later
BrowsedFile
New in version 09
BrowsedFile
BrowsedFile
The BrowsedFile property is used to get and change the data source used to display records in controls based on a data file.
Versions 09 and later
Caption
New in version 09
Caption
Caption
In a database, the Caption property is used to:
  • Find out the caption associated with a file item.
  • Find out the caption associated with a data file.
  • Find out and modify the connection caption.
In a report, the Caption property is used to:
  • Find out the text displayed in a Static or Link control.
  • Modify the text displayed in a Static or Link control.
In a window or page, the Caption property is also used to:
  • Find out and modify the caption of a control in a window or in a page.
  • Find out and modify the caption of a menu option.
  • Find out and modify the title of a window or page.
  • Find out the content of a Breadcrumb control.
Versions 09 and later
Color
New in version 09
Color
Color
The Color property is used to get or change the font color for:
  • a font variable.
  • a text displayed in a Static control or in a calculated control of a report.
  • a text displayed in a window control.
  • a text displayed in a page control.
Versions 12 and later
Count
New in version 12
Count
Count
The Count property returns the number of elements in a given set.
Versions 09 and later
DisplayEnabled
New in version 09
DisplayEnabled
DisplayEnabled
The DisplayEnabled property is used to:
  • find out whether the display of a control or window is enabled or not. If the display is enabled, the content of the control is refreshed on a regular basis.
  • enable (or not) the display of a control or window.
Versions 09 and later
DndSource
New in version 09
DndSource
DndSource
The DndSource property is used to determine and change a control's drag-and-drop behavior.
Versions 09 and later
DndTarget
New in version 09
DndTarget
DndTarget
DndTarget is used to find out and modify the behavior of a control during "Drag and Drop".
Versions 09 and later
DoubleClick
New in version 09
DoubleClick
DoubleClick
The DoubleClick property is used to get and change the name of the Button control that will be executed when a control is double-clicked.
Versions 09 and later
Empty
New in version 09
Empty
Empty
Empty is used to find out whether:
  • a Looper, Table, List Box or Combo Box control is empty. The control can be a browsing control or a memory control.
  • a Chart control contains no series.
  • a report control is empty (control linked to an item).
  • an array (or an associative array) contains no element.
  • an element of an associative array exists or not.
  • a queue, a list or a stack contains no element.
Versions 16 and later
FocusOnClick
New in version 16
FocusOnClick
FocusOnClick
The FocusOnClick property is used to:
  • Find out whether a control gains focus during a click.
  • Modify the effect for taking focus during the click on a control.
Versions 09 and later
FontCharset
New in version 09
FontCharset
FontCharset
The FontCharset property is used to:
  • Find out the character set used by the screen fonts of a control.
  • Modify the character set used by the screen fonts of a control.
Versions 09 and later
FullName
New in version 09
FullName
FullName
The FullName property is used to find out the full name:
  • of a control.
  • of a window.
  • of a menu option.
  • of a table column.
Versions 17 and later
Grayed
New in version 17
Grayed
Grayed
The Grayed property is used to:
  • Determine if a control (or a group of controls) is grayed out.
  • Gray out or ungray a control, a group of controls or a window.
Versions 09 and later
Group
New in version 09
Group
Group
The Group property is used to:
  • find out whether the control belongs to a group of controls. If the control belongs to one or more groups, the Group property can be used to identify these groups of controls.
  • associate a control with a group of controls.
Versions 09 and later
Height
New in version 09
Height
Height
The Height property is used to get and change the height:
  • of a control or block in a report.
  • of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control.
  • of a control (in a page), break header or footer in a Table or Looper control. The control can be overlayable or not.
Versions 09 and later
HelpNumber
New in version 09
HelpNumber
HelpNumber
The HelpNumber property is used to identify and modify the help number associated with a control.
Versions 27 and later
HideWhileScrolling
New in version 27
HideWhileScrolling
HideWhileScrolling
The HideWhileScrolling property is used to:
  • Determine if the pinned control is hidden while scrolling,
  • Show or hide the pinned control while scrolling.
Versions 09 and later
InitialHeight
New in version 09
InitialHeight
InitialHeight
The InitialHeight property is used to:
  • Find out the creation height of a control or window.
  • Modify the base height used to anchor the controls "in height".
  • Find out the creation height of a block or control in a report.
Versions 09 and later
InitialState
New in version 09
InitialState
InitialState
The InitialState property is used to get the initial state of a control.
Versions 09 and later
InitialVisible
New in version 09
InitialVisible
InitialVisible
The InitialVisible property is used to determine if:
  • a control was visible during the first display of the associated window or page.
  • a window was visible during its first display.
Versions 09 and later
InitialWidth
New in version 09
InitialWidth
InitialWidth
The InitialWidth property is used to:
  • Find out the initial width of a control or window.
  • Modify the base width used to anchor the controls in "width".
  • Find out the initial width of a report control.
Versions 11 and later
LeftIndent
New in version 11
LeftIndent
LeftIndent
The LeftIndent property is used to get and change the space to the left of the text in:
  • the columns of Table and TreeView Table controls (between the beginning of column and the beginning of text).
  • the edit controls.
  • the Combo Box and List Box controls.
  • the Button controls.
  • the Ribbon controls.
  • the Tab controls.
  • Static controls.
Versions 09 and later
LineHeight
New in version 09
LineHeight
LineHeight
The LineHeight property is used to get and change the height of the rows:
  • in a List Box control,
  • in a ListView control (standard display mode only),
  • in a Table control,
  • in a Combo Box control,
  • in a Looper control (height of the row),
  • in an Organizer control.
Versions 09 and later
MaxHeight
New in version 09
MaxHeight
MaxHeight
The MaxHeight property is used to get and change the maximum height of a control or window.
Versions 09 and later
MaxWidth
New in version 09
MaxWidth
MaxWidth
The MaxWidth property is used to get and change the maximum width of a control or window.
Versions 11 and later
Message
New in version 11
Message
Message
The Message property is used to:
  • Find out the help message associated with a control or with a menu option (in a window).
  • Modify the help message associated with a control or with a menu option (in a window).
Versions 09 and later
MinHeight
New in version 09
MinHeight
MinHeight
The MinHeight property is used to get and change the minimum height of a control or window.
Versions 09 and later
MinWidth
New in version 09
MinWidth
MinWidth
The MinWidth property is used to get and change the minimum width of a control or window.
Versions 09 and later
MouseCursor
New in version 09
MouseCursor
MouseCursor
The MouseCursor property is used to identify and change the hover cursor defined for a control, window or page.
Versions 12 and later
Multi-selection
New in version 12
Multi-selection
Multi-selection
The Multiselection property is used to get and change the selection mode:
  • of a Table (and TreeView Table) control.
  • of a Pivot Table control.
  • of a List Box (and ListView) control.
  • of a Looper control.
  • of a Calendar control.
  • of files in an Upload control.
Versions 09 and later
Name
New in version 09
Name
Name
The Name property is used to get:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page.
Versions 09 and later
NewLine
New in version 09
NewLine
NewLine
The New property is used to determine:
  • in a Table control, whether the current row was created by TableAddXXX or TableInsertXXX.
  • in a Looper control, whether the current row was created by LooperAddXXX or LooperInsertXXX.
  • in an Organizer control, whether an appointment was created via the popup menu.
  • in a Scheduler control, whether an appointment was created via the popup menu.
Versions 09 and later
Note
New in version 09
Note
Note
The Note property is used to:
  • Find out the notes associated with a control, a window, a page or a report.
  • Modify the notes associated with a control, a window a page or a report.
Versions 09 and later
NoteTitle
New in version 09
NoteTitle
NoteTitle
The NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
Versions 09 and later
NumberColumn
New in version 09
NumberColumn
NumberColumn
NumberColumn is used to:
  • Find out the number of columns in a control containing columns (Table, Check Box, Radio Button controls, etc.).
  • Modify the number of columns in a multi-column List Box control.
Versions 09 and later
Opacity
New in version 09
Opacity
Opacity
The Opacity property is used to get and define the opacity percentage for a window, or for controls in a window or page.
Versions 19 and later
Pane
New in version 19
Pane
Pane
The Pane property is used to:
  • Find out the pane tabs associated with a control.
  • Define the pane tabs associated with a control.
Versions 21 and later
ParallaxRateHeight
New in version 21
ParallaxRateHeight
ParallaxRateHeight
The ParallaxRateHeight property is used to determine and specify how fast a control is reduced when the scrollbar in the window, internal window or page moves.
Versions 21 and later
ParallaxRateY
New in version 21
ParallaxRateY
ParallaxRateY
The ParallaxRateY property is used to determine and specify how fast a control moves when the scrollbar in the window, internal window or page moves.
Versions 27 and later
Pinned
New in version 27
Pinned
Pinned
The Pinned property is used to:
  • Pin a control: the position of the pinned control will be relative to the visible area of its container and not to the content area.
  • Determine if a control is pinned.
Versions 09 and later
Plane
New in version 09
Plane
Plane
Plane is used to:
  • Get:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Change:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
Versions 09 and later
PopupMenu
New in version 09
PopupMenu
PopupMenu
The PopupMenu property is used to:
  • Find out the custom context menu associated with a control or window.
  • Modify the context menu associated with a control or window (associate another context menu with the control or window).
  • Customize the system menus of controls by adding options.
Versions 19 and later
Process
New in version 19
Process
Process
The Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
Versions 18 and later
ProgressBar
New in version 18
ProgressBar
ProgressBar
The ProgressBar property is used to identify and change the Progress Bar control used when calculating a Pivot Table control (PVTCalculateAll and PVTCalculateUpdate functions).
Versions 09 and later
RightClick
New in version 09
RightClick
RightClick
The RightClick property is used to get and change the name of the Button control that will be executed when an object is right-clicked.
Versions 12 and later
RightToLeft
New in version 12
RightToLeft
RightToLeft
The RightToLeft property is used to get the writing direction on a control, column, window or report.
Versions 09 and later
State
New in version 09
State
State
The State property is used to get and change the state of an element.
Versions 20 and later
Style
New in version 20
Style
Style
The Style property is used to retrieve and assign the entire style of a control (including the overrides).
Versions 09 and later
TABOrder
New in version 09
TABOrder
TABOrder
The TABOrder property is used to get and change the position of a control in the tab order of a window.
Versions 15 and later
TextDirection
New in version 15
TextDirection
TextDirection
The TextDirection property is used to determine and change the writing direction in a window, report or control (useful for languages such as Arabic or Hebrew).
Versions 09 and later
ToolTip
New in version 09
ToolTip
ToolTip
The ToolTip property is used to get and change the text displayed in the tooltip associated with a window or page control.
Versions 09 and later
TotalsEnabled
New in version 09
TotalsEnabled
TotalsEnabled
The TotalsEnabled property enables you to:
  • Find out the operating mode of column calculations (automatic or custom) for a Table or TreeView Table control,
  • Temporarily forbid or force the column calculations (automatic or custom) in a Table or TreeView Table control.
Versions 09 and later
Type
New in version 09
Type
Type
The Type property is used to get:
  • the type of element described through programming (file or item description) or not (file or item defined in the data model editor, view or query).
  • the type of object.
  • the type of value stored in a variant.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
Versions 26 and later
VisibleWithAnimation
New in version 26
VisibleWithAnimation
VisibleWithAnimation
The VisibleWithAnimation property is used to make a control visible or invisible via the "Appear/Disappear" animation.
Versions 15 and later
VisualEffect
New in version 15
VisualEffect
VisualEffect
The VisualEffect property allows you to apply a visual effect on a control or group of controls in a window.
Versions 09 and later
Width
New in version 09
Width
Width
Width is used to find out and modify the width:
  • of a control or block in a report.
  • of a control (found in a window), window, column found in a table or column found in a list box (including listview).
  • of a control (found in a page), column found in a table or column found in a list box. The control can be overlayable or not.
Versions 21 and later
WinEditAllowed
New in version 21
WinEditAllowed
WinEditAllowed
The WinEditAllowed property is used to determine and configure the actions allowed on a control when the window switches to "UI modification by end user" mode.
Versions 09 and later
X
New in version 09
X
X
The X property is used to:
  • Get the X-coordinate of a control, Table control column or window (position on the X-axis).
  • Get the X-coordinate of a control or window (position on the X-axis).
Versions 09 and later
XInitial
New in version 09
XInitial
XInitial
The XInitial property is used to:
  • Get the X-coordinate:
    • of a control (position on the X-axis) when opening the window or the page.
    • of a window (position on X-axis) when opening the window.
  • Change the X-coordinate of a control anchored "to the right" (position on the X-axis) when opening the window.
  • Get the X-coordinate of a control in relation to its block (position in millimeters on the X-axis) when opening the report.
Versions 09 and later
Y
New in version 09
Y
Y
The Y property is used to:
  • Find out the Y-coordinate of a control or window (position on Y-axis).
  • Modify the Y-coordinate of a control or window.
Versions 09 and later
YInitial
New in version 09
YInitial
YInitial
The YInitial property is used to:
  • Find out the Y-coordinate:
    • of a control (position on Y axis) when opening the window or the page.
    • of a window (position on Y axis) when opening the window.
  • Modify the Y-coordinate of a control anchored "to bottom" (position on the vertical axis) when opening the window.
  • Find out the Y-coordinate of a control in relation to its block (position in millimeters on the vertical axis) when opening the report.
Versions 12 and later
Zoom
New in version 12
Zoom
Zoom
The Zoom property is used to get or change the zoom value:
  • in an Image control.
  • in a Map control.
  • in an Organization Chart control.
  • in a Table, TreeView Table, Pivot Table, Spreadsheet or List Box control.
  • in a Word Processing control.
  • in a PDF Reader control.
  • in a Camera control.
  • in a window.
Versions 09 and later
ZOrder
New in version 09
ZOrder
ZOrder
The ZOrder property is used to manage the z-order of an element.

Properties that can be used on a row, a column or a filter

The following properties are associated with the rows, columns or filters found in a Pivot Table control:
Versions 09 and later
Caption
New in version 09
Caption
Caption
In a database, the Caption property is used to:
  • Find out the caption associated with a file item.
  • Find out the caption associated with a data file.
  • Find out and modify the connection caption.
In a report, the Caption property is used to:
  • Find out the text displayed in a Static or Link control.
  • Modify the text displayed in a Static or Link control.
In a window or page, the Caption property is also used to:
  • Find out and modify the caption of a control in a window or in a page.
  • Find out and modify the caption of a menu option.
  • Find out and modify the title of a window or page.
  • Find out the content of a Breadcrumb control.
Versions 18 and later
Cumulated
New in version 18
Cumulated
Cumulated
The Cumulated property is used to determine if the value of a column or row in Pivot Table control corresponds to a total (total at the end of a row or column).
Versions 20 and later
DisplayEvenIfNull
New in version 20
DisplayEvenIfNull
DisplayEvenIfNull
The DisplayEvenIfNull property is used to:
  • Find out whether a row or a column in a Pivot Table control is displayed even if it contains no value.
  • Configure a row or a column found in a Pivot Table control so that it is displayed (or not) even if it contains no value.
Versions 17 and later
DisplayMask
New in version 17
DisplayMask
DisplayMask
The DisplayMask property is used to:
  • Find out the display mask.
  • Modify the display mask.
This display mask is displayed when the control is in read-only or when the control does not have focus.
Versions 18 and later
DisplayOrphan
New in version 18
DisplayOrphan
DisplayOrphan
The DisplayOrphan property is used to:
  • Find out whether a row or a column found in a Pivot Table control is displayed when it has no parent.
  • Modify the display mode of a row or column in a Pivot Table control when it has no parent.
Versions 18 and later
FilterProcedure
New in version 18
FilterProcedure
FilterProcedure
The FilterProcedure property allows you to get and modify the procedure used to apply a filter on a row or column header when calculating a Pivot Table control.
Versions 09 and later
MaxValue
New in version 09
MaxValue
MaxValue
The MaxValue property is used to:
  • find out and modify the upper bound of a report based on a data file.
  • find out the upper bound defined for the current filter.
  • find out the maximum value of a chart series.
  • find out and modify the maximum value for some types of controls.
Versions 09 and later
MinValue
New in version 09
MinValue
MinValue
The MinValue property is used to:
  • find out and modify the lower bound of a report based on a data file.
  • find out the lower bound defined for the current filter.
  • find out the minimum value of a chart series.
  • find out and modify the minimum value for some types of controls.
Versions 09 and later
Name
New in version 09
Name
Name
The Name property is used to get:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page.
Versions 19 and later
Pane
New in version 19
Pane
Pane
The Pane property is used to:
  • Find out the pane tabs associated with a control.
  • Define the pane tabs associated with a control.
Versions 21 and later
ParallaxRateHeight
New in version 21
ParallaxRateHeight
ParallaxRateHeight
The ParallaxRateHeight property is used to determine and specify how fast a control is reduced when the scrollbar in the window, internal window or page moves.
Versions 21 and later
ParallaxRateY
New in version 21
ParallaxRateY
ParallaxRateY
The ParallaxRateY property is used to determine and specify how fast a control moves when the scrollbar in the window, internal window or page moves.
Versions 19 and later
Process
New in version 19
Process
Process
The Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 21 and later
WinEditAllowed
New in version 21
WinEditAllowed
WinEditAllowed
The WinEditAllowed property is used to determine and configure the actions allowed on a control when the window switches to "UI modification by end user" mode.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:
Versions 12 and later
AutomaticErase
New in version 12
AutomaticErase
AutomaticErase
The AutomaticErase property is used to:
  • find out whether an edit control is in "Automatic erase" mode.
  • modify the "Automatic erase" characteristic of an edit control.
Versions 09 and later
BackgroundColor
New in version 09
BackgroundColor
BackgroundColor
The BackgroundColor property is used to set the background color of a control, window, page or block of a report.
Versions 11 and later
BackgroundStyle
New in version 11
BackgroundStyle
BackgroundStyle
The BackgroundStyle property is used to get and modify the background style of cells in tables and/or treeview tables.
Versions 09 and later
Caption
New in version 09
Caption
Caption
In a database, the Caption property is used to:
  • Find out the caption associated with a file item.
  • Find out the caption associated with a data file.
  • Find out and modify the connection caption.
In a report, the Caption property is used to:
  • Find out the text displayed in a Static or Link control.
  • Modify the text displayed in a Static or Link control.
In a window or page, the Caption property is also used to:
  • Find out and modify the caption of a control in a window or in a page.
  • Find out and modify the caption of a menu option.
  • Find out and modify the title of a window or page.
  • Find out the content of a Breadcrumb control.
Versions 09 and later
Color
New in version 09
Color
Color
The Color property is used to get or change the font color for:
  • a font variable.
  • a text displayed in a Static control or in a calculated control of a report.
  • a text displayed in a window control.
  • a text displayed in a page control.
Versions 18 and later
Cumulated
New in version 18
Cumulated
Cumulated
The Cumulated property is used to determine if the value of a column or row in Pivot Table control corresponds to a total (total at the end of a row or column).
Versions 09 and later
DisplayCurrency
New in version 09
DisplayCurrency
DisplayCurrency
The DisplayCurrency property is used to get and change the currency used when entering or displaying values in a "Currency + Euro" control.
Versions 09 and later
DisplayedValue
New in version 09
DisplayedValue
DisplayedValue
The DisplayedValue property returns the value currently displayed in the control of a window or page.
Versions 17 and later
DisplayMask
New in version 17
DisplayMask
DisplayMask
The DisplayMask property is used to:
  • Find out the display mask.
  • Modify the display mask.
This display mask is displayed when the control is in read-only or when the control does not have focus.
Versions 09 and later
Ellipsis
New in version 09
Ellipsis
Ellipsis
The Ellipsis property is used to determine and change the truncation mode with ellipses in:
  • a window control (Static, edit control, List box, Button, Combo box or Static table column).
  • a Static control in a report.
Versions 18 and later
EmptyIfZero
New in version 18
EmptyIfZero
EmptyIfZero
The EmptyIfZero property is used to:
  • Find out the management mode of zero value in a control.
  • Modify the management mode of zero value in a control
Versions 09 and later
Font
New in version 09
Font
Font
The Font property is used to
  • Get the identifier of the font used in a control in a report, page or window.
  • Change the font used in a control in a report, page or window.
Versions 09 and later
FontBold
New in version 09
FontBold
FontBold
FontBold is used to:
  • Determine if the text is bold.
  • Change the weight of the text.
Versions 09 and later
FontCharset
New in version 09
FontCharset
FontCharset
The FontCharset property is used to:
  • Find out the character set used by the screen fonts of a control.
  • Modify the character set used by the screen fonts of a control.
Versions 09 and later
FontCondensed
New in version 09
FontCondensed
FontCondensed
The FontCondensed property is used to:
  • Find out whether the characters in a text are condensed or not.
  • Condense (or not) the characters in a text.
Versions 09 and later
FontExtended
New in version 09
FontExtended
FontExtended
The FontExtended property is used to:
  • Find out whether the spacing between characters in a text is increased.
  • Increase the spacing between characters in a text.
Versions 09 and later
FontItalic
New in version 09
FontItalic
FontItalic
FontItalic is used to:
  • Determine if the text is italicized.
  • Apply or remove italic formatting from the text.
Versions 09 and later
FontLarge
New in version 09
FontLarge
FontLarge
FontLarge is used to:
  • Find out whether the characters in a text are enlarged or not.
  • Enlarge (or not) the characters in a text.
Versions 09 and later
FontName
New in version 09
FontName
FontName
The FontName property is used to:
  • Identify the font used in a control.
  • Change the font used in a control.
Versions 09 and later
FontSize
New in version 09
FontSize
FontSize
The FontSize property is used to:
  • Identify the size of the font used in a control.
  • Change the size of the font used in a control.
Versions 09 and later
FontStrikeOut
New in version 09
FontStrikeOut
FontStrikeOut
The FontStrikeOut property is used to:
  • Determine if the text displayed is struck through.
  • Apply strikethrough formatting (or not) the text displayed in a control.
Versions 09 and later
FontUnderlined
New in version 09
FontUnderlined
FontUnderlined
FontUnderlined is used to:
  • Find out whether a text is underlined or not.
  • Underline (or not) a text.
Versions 09 and later
FullName
New in version 09
FullName
FullName
The FullName property is used to find out the full name:
  • of a control.
  • of a window.
  • of a menu option.
  • of a table column.
Versions 17 and later
Grayed
New in version 17
Grayed
Grayed
The Grayed property is used to:
  • Determine if a control (or a group of controls) is grayed out.
  • Gray out or ungray a control, a group of controls or a window.
Versions 09 and later
Group
New in version 09
Group
Group
The Group property is used to:
  • find out whether the control belongs to a group of controls. If the control belongs to one or more groups, the Group property can be used to identify these groups of controls.
  • associate a control with a group of controls.
Versions 09 and later
Height
New in version 09
Height
Height
The Height property is used to get and change the height:
  • of a control or block in a report.
  • of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control.
  • of a control (in a page), break header or footer in a Table or Looper control. The control can be overlayable or not.
Versions 09 and later
HelpNumber
New in version 09
HelpNumber
HelpNumber
The HelpNumber property is used to identify and modify the help number associated with a control.
Versions 09 and later
HorizontalAlignment
New in version 09
HorizontalAlignment
HorizontalAlignment
The HorizontalAlignment property is used to get and change the horizontal alignment of a control.
Versions 09 and later
InitialHeight
New in version 09
InitialHeight
InitialHeight
The InitialHeight property is used to:
  • Find out the creation height of a control or window.
  • Modify the base height used to anchor the controls "in height".
  • Find out the creation height of a block or control in a report.
Versions 09 and later
InitialState
New in version 09
InitialState
InitialState
The InitialState property is used to get the initial state of a control.
Versions 09 and later
InitialVisible
New in version 09
InitialVisible
InitialVisible
The InitialVisible property is used to determine if:
  • a control was visible during the first display of the associated window or page.
  • a window was visible during its first display.
Versions 09 and later
InitialWidth
New in version 09
InitialWidth
InitialWidth
The InitialWidth property is used to:
  • Find out the initial width of a control or window.
  • Modify the base width used to anchor the controls in "width".
  • Find out the initial width of a report control.
Versions 09 and later
InputMask
New in version 09
InputMask
InputMask
The InputMask property is used to:
  • find out the input mask.
  • modify the input mask (among the available masks for the type).
Versions 09 and later
InputType
New in version 09
InputType
InputType
The InputType property is used to identify or change the type of input supported by a control: Duration, Date, Numeric, etc.
Versions 10 and later
InterpretAmpersand
New in version 10
InterpretAmpersand
InterpretAmpersand
The InterpretAmpersand property is used to determine and change how the '&' character is interpreted in:
  • the caption of a Static control.
  • the elements of a List Box control.
  • the elements of a Combo Box control.
  • the values of a column in a Table control.
Versions 11 and later
LeftIndent
New in version 11
LeftIndent
LeftIndent
The LeftIndent property is used to get and change the space to the left of the text in:
  • the columns of Table and TreeView Table controls (between the beginning of column and the beginning of text).
  • the edit controls.
  • the Combo Box and List Box controls.
  • the Button controls.
  • the Ribbon controls.
  • the Tab controls.
  • Static controls.
Versions 09 and later
MemoryCurrency
New in version 09
MemoryCurrency
MemoryCurrency
The MemoryCurrency property is used to get and change the currency used when manipulating a "Currency + Euro" control programmatically.
Versions 09 and later
MemoryFormat
New in version 09
MemoryFormat
MemoryFormat
The MemoryFormat property is used to get and change the format of the value returned for:
  • Date or Time edit controls.
  • Date or Time table columns.
  • Calendar controls.
  • Static controls.
  • editable combo boxes.
  • table columns displayed by combo boxes.
Versions 09 and later
MinWidth
New in version 09
MinWidth
MinWidth
The MinWidth property is used to get and change the minimum width of a control or window.
Versions 09 and later
MouseCursor
New in version 09
MouseCursor
MouseCursor
The MouseCursor property is used to identify and change the hover cursor defined for a control, window or page.
Versions 09 and later
Name
New in version 09
Name
Name
The Name property is used to get:
  • the name of the font associated with a Font variable.
  • the name of a control, report or report block.
  • the name of a control, group of controls or window.
  • the name of a control, group of controls or page.
Versions 09 and later
Note
New in version 09
Note
Note
The Note property is used to:
  • Find out the notes associated with a control, a window, a page or a report.
  • Modify the notes associated with a control, a window a page or a report.
Versions 09 and later
NoteTitle
New in version 09
NoteTitle
NoteTitle
The NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
Versions 21 and later
ParallaxRateHeight
New in version 21
ParallaxRateHeight
ParallaxRateHeight
The ParallaxRateHeight property is used to determine and specify how fast a control is reduced when the scrollbar in the window, internal window or page moves.
Versions 21 and later
ParallaxRateY
New in version 21
ParallaxRateY
ParallaxRateY
The ParallaxRateY property is used to determine and specify how fast a control moves when the scrollbar in the window, internal window or page moves.
Versions 09 and later
PopupMenu
New in version 09
PopupMenu
PopupMenu
The PopupMenu property is used to:
  • Find out the custom context menu associated with a control or window.
  • Modify the context menu associated with a control or window (associate another context menu with the control or window).
  • Customize the system menus of controls by adding options.
Versions 19 and later
Process
New in version 19
Process
Process
The Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc.
Versions 09 and later
Selected
New in version 09
Selected
Selected
The Selected property is used to select a row and to determine if a row is selected (in a List Box, ListView or Table control).
Versions 11 and later
Size
New in version 11
Size
Size
The Size property is used to determine and change the size of an element.
Versions 09 and later
State
New in version 09
State
State
The State property is used to get and change the state of an element.
Versions 15 and later
TextDirection
New in version 15
TextDirection
TextDirection
The TextDirection property is used to determine and change the writing direction in a window, report or control (useful for languages such as Arabic or Hebrew).
Versions 09 and later
ToolTipTitle
New in version 09
ToolTipTitle
ToolTipTitle
The ToolTipTitle property is used to get and change the text displayed as tooltip of a column title in a Table control. This tooltip only appears when the Table control column title is hovered over.
Versions 09 and later
Type
New in version 09
Type
Type
The Type property is used to get:
  • the type of element described through programming (file or item description) or not (file or item defined in the data model editor, view or query).
  • the type of object.
  • the type of value stored in a variant.
Versions 12 and later
Unicode
New in version 12
Unicode
Unicode
The Unicode property is used to:
  • Determine if the value of a control is a Unicode string.
  • Specify whether the value of a control is a Unicode string.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
VerticalAlignment
New in version 09
VerticalAlignment
VerticalAlignment
The VerticalAlignment property is used to get and change the vertical alignment of a control.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
Versions 09 and later
Width
New in version 09
Width
Width
Width is used to find out and modify the width:
  • of a control or block in a report.
  • of a control (found in a window), window, column found in a table or column found in a list box (including listview).
  • of a control (found in a page), column found in a table or column found in a list box. The control can be overlayable or not.
Versions 21 and later
WinEditAllowed
New in version 21
WinEditAllowed
WinEditAllowed
The WinEditAllowed property is used to determine and configure the actions allowed on a control when the window switches to "UI modification by end user" mode.
Versions 21 and later
Properties available in a report

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:
Versions 27 and later
BlurLevel
New in version 27
BlurLevel
BlurLevel
The BlurLevel property gets and changes the percentage of blur applied to a control in a report.
Versions 11 and later
Collapsed
New in version 11
Collapsed
Collapsed
The Collapsed property is used to:
  • get or define the state (collapsed or expanded) that will be used when rows are added to a TreeView Table control.
  • find out or modify the collapsed/expanded status for:
    • the breaks of a Table control,
    • the breaks of a Looper control,
    • a Drawer control,
    • a Ribbon control,
    • a Navigation Bar control.
    • a Pivot Table control in a report.
Versions 09 and later
Height
New in version 09
Height
Height
The Height property is used to get and change the height:
  • of a control or block in a report.
  • of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control.
  • of a control (in a page), break header or footer in a Table or Looper control. The control can be overlayable or not.
Versions 27 and later
Hidden
New in version 27
Hidden
Hidden
The Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
Versions 09 and later
Note
New in version 09
Note
Note
The Note property is used to:
  • Find out the notes associated with a control, a window, a page or a report.
  • Modify the notes associated with a control, a window a page or a report.
Versions 09 and later
NoteTitle
New in version 09
NoteTitle
NoteTitle
The NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
Versions 09 and later
Plane
New in version 09
Plane
Plane
Plane is used to:
  • Get:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Change:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:
Versions 09 and later
BackgroundColor
New in version 09
BackgroundColor
BackgroundColor
The BackgroundColor property is used to set the background color of a control, window, page or block of a report.
Versions 27 and later
BlurLevel
New in version 27
BlurLevel
BlurLevel
The BlurLevel property gets and changes the percentage of blur applied to a control in a report.
Versions 09 and later
Color
New in version 09
Color
Color
The Color property is used to get or change the font color for:
  • a font variable.
  • a text displayed in a Static control or in a calculated control of a report.
  • a text displayed in a window control.
  • a text displayed in a page control.
Versions 09 and later
Font
New in version 09
Font
Font
The Font property is used to
  • Get the identifier of the font used in a control in a report, page or window.
  • Change the font used in a control in a report, page or window.
Versions 27 and later
Hidden
New in version 27
Hidden
Hidden
The Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
New in version 21
Properties available in a report

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:
Versions 27 and later
BlurLevel
New in version 27
BlurLevel
BlurLevel
The BlurLevel property gets and changes the percentage of blur applied to a control in a report.
Versions 11 and later
Collapsed
New in version 11
Collapsed
Collapsed
The Collapsed property is used to:
  • get or define the state (collapsed or expanded) that will be used when rows are added to a TreeView Table control.
  • find out or modify the collapsed/expanded status for:
    • the breaks of a Table control,
    • the breaks of a Looper control,
    • a Drawer control,
    • a Ribbon control,
    • a Navigation Bar control.
    • a Pivot Table control in a report.
Versions 09 and later
Height
New in version 09
Height
Height
The Height property is used to get and change the height:
  • of a control or block in a report.
  • of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control.
  • of a control (in a page), break header or footer in a Table or Looper control. The control can be overlayable or not.
Versions 27 and later
Hidden
New in version 27
Hidden
Hidden
The Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
Versions 09 and later
Note
New in version 09
Note
Note
The Note property is used to:
  • Find out the notes associated with a control, a window, a page or a report.
  • Modify the notes associated with a control, a window a page or a report.
Versions 09 and later
NoteTitle
New in version 09
NoteTitle
NoteTitle
The NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
Versions 09 and later
Plane
New in version 09
Plane
Plane
Plane is used to:
  • Get:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Change:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:
Versions 09 and later
BackgroundColor
New in version 09
BackgroundColor
BackgroundColor
The BackgroundColor property is used to set the background color of a control, window, page or block of a report.
Versions 27 and later
BlurLevel
New in version 27
BlurLevel
BlurLevel
The BlurLevel property gets and changes the percentage of blur applied to a control in a report.
Versions 09 and later
Color
New in version 09
Color
Color
The Color property is used to get or change the font color for:
  • a font variable.
  • a text displayed in a Static control or in a calculated control of a report.
  • a text displayed in a window control.
  • a text displayed in a page control.
Versions 09 and later
Font
New in version 09
Font
Font
The Font property is used to
  • Get the identifier of the font used in a control in a report, page or window.
  • Change the font used in a control in a report, page or window.
Versions 27 and later
Hidden
New in version 27
Hidden
Hidden
The Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
Properties available in a report

Properties that can be used on the pivot table

The following properties are associated with the Pivot Table controls:
Versions 27 and later
BlurLevel
New in version 27
BlurLevel
BlurLevel
The BlurLevel property gets and changes the percentage of blur applied to a control in a report.
Versions 11 and later
Collapsed
New in version 11
Collapsed
Collapsed
The Collapsed property is used to:
  • get or define the state (collapsed or expanded) that will be used when rows are added to a TreeView Table control.
  • find out or modify the collapsed/expanded status for:
    • the breaks of a Table control,
    • the breaks of a Looper control,
    • a Drawer control,
    • a Ribbon control,
    • a Navigation Bar control.
    • a Pivot Table control in a report.
Versions 09 and later
Height
New in version 09
Height
Height
The Height property is used to get and change the height:
  • of a control or block in a report.
  • of a control (in a window), window, row of a Table, List Box or ListView control, option of a Radio Button or Check Box control, break header or footer of a Table or Looper control.
  • of a control (in a page), break header or footer in a Table or Looper control. The control can be overlayable or not.
Versions 27 and later
Hidden
New in version 27
Hidden
Hidden
The Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
Versions 09 and later
Note
New in version 09
Note
Note
The Note property is used to:
  • Find out the notes associated with a control, a window, a page or a report.
  • Modify the notes associated with a control, a window a page or a report.
Versions 09 and later
NoteTitle
New in version 09
NoteTitle
NoteTitle
The NoteTitle property is used to:
  • Get the title of the notes used in the technical documentation of a control, window, page or report.
  • Change the title of the notes used in the technical documentation of a control, window, page or report.
Versions 09 and later
Plane
New in version 09
Plane
Plane
Plane is used to:
  • Get:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Change:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.

Properties that can be used on a value displayed in a cell

The following properties are associated with the values displayed in a Pivot Table control:
Versions 09 and later
BackgroundColor
New in version 09
BackgroundColor
BackgroundColor
The BackgroundColor property is used to set the background color of a control, window, page or block of a report.
Versions 27 and later
BlurLevel
New in version 27
BlurLevel
BlurLevel
The BlurLevel property gets and changes the percentage of blur applied to a control in a report.
Versions 09 and later
Color
New in version 09
Color
Color
The Color property is used to get or change the font color for:
  • a font variable.
  • a text displayed in a Static control or in a calculated control of a report.
  • a text displayed in a window control.
  • a text displayed in a page control.
Versions 09 and later
Font
New in version 09
Font
Font
The Font property is used to
  • Get the identifier of the font used in a control in a report, page or window.
  • Change the font used in a control in a report, page or window.
Versions 27 and later
Hidden
New in version 27
Hidden
Hidden
The Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
Versions 09 and later
Value
New in version 09
Value
Value
The Value property is used to:
  • Find out and modify the value of a report control.
  • Find out and modify the value of a control or the title of a window.
  • Find out the identifier of a stream.
  • Find out and modify the value of a control or the title of a page.
Versions 09 and later
Visible
New in version 09
Visible
Visible
The Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment