PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • Properties available for a Spreadsheet control found in a window
  • Properties available for a Spreadsheet control found in a report
  • Properties available for the Spreadsheet control
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
A Spreadsheet control and its cells can be handled in a window or in a report by the following WLanguage properties.
Properties available for a Spreadsheet control found in a window
Versions 21 and later
Properties available for a Spreadsheet control found in a report
WEBDEV - Server code

Properties available for the Spreadsheet control

The following properties are associated with the Spreadsheet controls:
Versions 21 and later
AdjustmentMode
New in version 21
AdjustmentMode
AdjustmentMode
..AdjustmentMode is used to find out and modify the adjustment mode of a Spreadsheet control in a report.
Versions 09 and later
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
..DisplayedItem is used to:
  • Find out the item or the variable displayed by the control.
  • Modify the item or the variable displayed by the control.
Versions 23 and later
GridlinesVisible
New in version 23
GridlinesVisible
GridlinesVisible
..GridlinesVisible is used to:
  • Find out whether the gridlines are visible or not in a Spreadsheet control.
  • Modify the visibility of gridlines in a Spreadsheet control.
Versions 20 and later
HeaderVisible
New in version 20
HeaderVisible
HeaderVisible
..HeaderVisible is used to:
  • Find out whether the row and column headers are displayed in a Spreadsheet control.
  • Display (or not) the row and column headers in a Spreadsheet control.
Versions 09 and later
Height
New in version 09
Height
Height
..Height is used to know and modify 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 Looper control. The control can be overlayable or not.
Versions 09 and later
Name
New in version 09
Name
Name
..Name is used to find out:
  • 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
..Note 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
..NoteTitle is used to:
  • Find out the title of the notes used in the program documentation of a control, window, page or report.
  • Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 09 and later
Plane
New in version 09
Plane
Plane
..Plane is used to:
  • Find out:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Modify:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
Versions 21 and later
PrintArea
New in version 21
PrintArea
PrintArea
..PrintArea is used find out and modify the area to print for a Spreadsheet control found in a report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
..PrintedSheet is used find out and modify the sheet to print for a Spreadsheet control found in a report.
Versions 09 and later
Value
New in version 09
Value
Value
..Value 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
..Visible 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 stackable or not.
Versions 09 and later
X
New in version 09
X
X
..X is used to:
  • Find out the X coordinate of a control, of a Table control column or of a window (position on X axis).
  • Modify the X coordinate of a control or window (position on X axis).
Versions 09 and later
Y
New in version 09
Y
Y
..Y 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.
New in version 21
Properties available for a Spreadsheet control found in a report
WEBDEV - Server code

Properties available for the Spreadsheet control

The following properties are associated with the Spreadsheet controls:
Versions 21 and later
AdjustmentMode
New in version 21
AdjustmentMode
AdjustmentMode
..AdjustmentMode is used to find out and modify the adjustment mode of a Spreadsheet control in a report.
Versions 09 and later
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
..DisplayedItem is used to:
  • Find out the item or the variable displayed by the control.
  • Modify the item or the variable displayed by the control.
Versions 23 and later
GridlinesVisible
New in version 23
GridlinesVisible
GridlinesVisible
..GridlinesVisible is used to:
  • Find out whether the gridlines are visible or not in a Spreadsheet control.
  • Modify the visibility of gridlines in a Spreadsheet control.
Versions 20 and later
HeaderVisible
New in version 20
HeaderVisible
HeaderVisible
..HeaderVisible is used to:
  • Find out whether the row and column headers are displayed in a Spreadsheet control.
  • Display (or not) the row and column headers in a Spreadsheet control.
Versions 09 and later
Height
New in version 09
Height
Height
..Height is used to know and modify 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 Looper control. The control can be overlayable or not.
Versions 09 and later
Name
New in version 09
Name
Name
..Name is used to find out:
  • 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
..Note 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
..NoteTitle is used to:
  • Find out the title of the notes used in the program documentation of a control, window, page or report.
  • Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 09 and later
Plane
New in version 09
Plane
Plane
..Plane is used to:
  • Find out:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Modify:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
Versions 21 and later
PrintArea
New in version 21
PrintArea
PrintArea
..PrintArea is used find out and modify the area to print for a Spreadsheet control found in a report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
..PrintedSheet is used find out and modify the sheet to print for a Spreadsheet control found in a report.
Versions 09 and later
Value
New in version 09
Value
Value
..Value 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
..Visible 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 stackable or not.
Versions 09 and later
X
New in version 09
X
X
..X is used to:
  • Find out the X coordinate of a control, of a Table control column or of a window (position on X axis).
  • Modify the X coordinate of a control or window (position on X axis).
Versions 09 and later
Y
New in version 09
Y
Y
..Y 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.
Properties available for a Spreadsheet control found in a report
WEBDEV - Server code

Properties available for the Spreadsheet control

The following properties are associated with the Spreadsheet controls:
Versions 21 and later
AdjustmentMode
New in version 21
AdjustmentMode
AdjustmentMode
..AdjustmentMode is used to find out and modify the adjustment mode of a Spreadsheet control in a report.
Versions 09 and later
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
..DisplayedItem is used to:
  • Find out the item or the variable displayed by the control.
  • Modify the item or the variable displayed by the control.
Versions 23 and later
GridlinesVisible
New in version 23
GridlinesVisible
GridlinesVisible
..GridlinesVisible is used to:
  • Find out whether the gridlines are visible or not in a Spreadsheet control.
  • Modify the visibility of gridlines in a Spreadsheet control.
Versions 20 and later
HeaderVisible
New in version 20
HeaderVisible
HeaderVisible
..HeaderVisible is used to:
  • Find out whether the row and column headers are displayed in a Spreadsheet control.
  • Display (or not) the row and column headers in a Spreadsheet control.
Versions 09 and later
Height
New in version 09
Height
Height
..Height is used to know and modify 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 Looper control. The control can be overlayable or not.
Versions 09 and later
Name
New in version 09
Name
Name
..Name is used to find out:
  • 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
..Note 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
..NoteTitle is used to:
  • Find out the title of the notes used in the program documentation of a control, window, page or report.
  • Modify the title of the notes used in the program documentation of a control, window, page or report.
Versions 09 and later
Plane
New in version 09
Plane
Plane
..Plane is used to:
  • Find out:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Modify:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
Versions 21 and later
PrintArea
New in version 21
PrintArea
PrintArea
..PrintArea is used find out and modify the area to print for a Spreadsheet control found in a report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
..PrintedSheet is used find out and modify the sheet to print for a Spreadsheet control found in a report.
Versions 09 and later
Value
New in version 09
Value
Value
..Value 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
..Visible 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 stackable or not.
Versions 09 and later
X
New in version 09
X
X
..X is used to:
  • Find out the X coordinate of a control, of a Table control column or of a window (position on X axis).
  • Modify the X coordinate of a control or window (position on X axis).
Versions 09 and later
Y
New in version 09
Y
Y
..Y 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.
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment