PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • 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
The Property ModeAdjustment makes it possible to know and modify the adjustment mode of an Spreadsheet control in an report.
Versions 09 and later
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
The Property DisplayTopic allows you 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
The Property GridVisible allows 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
The Property HeaderVisible allows 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
The Property Height allows 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
The Property Name allows you to know:
  • 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
NoteTitle
New in version 09
NoteTitle
NoteTitle
The Property TitleNote allows 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
The Property ZoneImpression makes it possible to know and modify the zone to be printed of an Spreadsheet control present in an report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
The Property PrintedSheet allows to know and modify the sheet to be printed in an Spreadsheet control present in an report.
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
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 Property Visible allows 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 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
The Property Y makes it possible 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
The Property ModeAdjustment makes it possible to know and modify the adjustment mode of an Spreadsheet control in an report.
Versions 09 and later
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
The Property DisplayTopic allows you 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
The Property GridVisible allows 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
The Property HeaderVisible allows 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
The Property Height allows 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
The Property Name allows you to know:
  • 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
NoteTitle
New in version 09
NoteTitle
NoteTitle
The Property TitleNote allows 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
The Property ZoneImpression makes it possible to know and modify the zone to be printed of an Spreadsheet control present in an report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
The Property PrintedSheet allows to know and modify the sheet to be printed in an Spreadsheet control present in an report.
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
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 Property Visible allows 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 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
The Property Y makes it possible 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
The Property ModeAdjustment makes it possible to know and modify the adjustment mode of an Spreadsheet control in an report.
Versions 09 and later
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
The Property DisplayTopic allows you 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
The Property GridVisible allows 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
The Property HeaderVisible allows 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
The Property Height allows 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
The Property Name allows you to know:
  • 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
NoteTitle
New in version 09
NoteTitle
NoteTitle
The Property TitleNote allows 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
The Property ZoneImpression makes it possible to know and modify the zone to be printed of an Spreadsheet control present in an report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
The Property PrintedSheet allows to know and modify the sheet to be printed in an Spreadsheet control present in an report.
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
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 Property Visible allows 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 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
The Property Y makes it possible 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