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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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 AdjustmentMode property determines and changes how a Spreadsheet control is adjusted in 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
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
The DisplayedItem property 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 20 and later
HeaderVisible
New in version 20
HeaderVisible
HeaderVisible
The HeaderVisible property 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
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
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 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 21 and later
PrintArea
New in version 21
PrintArea
PrintArea
The PrintArea property is used to get and change the print area of a Spreadsheet control in a report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
Within a report, the PrintedSheet property is used to get and change the sheet of a Spreadsheet control to be printed.
Versions 27 and later
GridlinesVisible
New in version 27
GridlinesVisible
GridlinesVisible
Indique si le quadrillage est visible dans un champ
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 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
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
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.
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 AdjustmentMode property determines and changes how a Spreadsheet control is adjusted in 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
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
The DisplayedItem property 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 20 and later
HeaderVisible
New in version 20
HeaderVisible
HeaderVisible
The HeaderVisible property 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
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
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 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 21 and later
PrintArea
New in version 21
PrintArea
PrintArea
The PrintArea property is used to get and change the print area of a Spreadsheet control in a report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
Within a report, the PrintedSheet property is used to get and change the sheet of a Spreadsheet control to be printed.
Versions 27 and later
GridlinesVisible
New in version 27
GridlinesVisible
GridlinesVisible
Indique si le quadrillage est visible dans un champ
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 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
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
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.
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 AdjustmentMode property determines and changes how a Spreadsheet control is adjusted in 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
DisplayedItem
New in version 09
DisplayedItem
DisplayedItem
The DisplayedItem property 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 20 and later
HeaderVisible
New in version 20
HeaderVisible
HeaderVisible
The HeaderVisible property 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
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
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 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 21 and later
PrintArea
New in version 21
PrintArea
PrintArea
The PrintArea property is used to get and change the print area of a Spreadsheet control in a report.
Versions 21 and later
PrintedSheet
New in version 21
PrintedSheet
PrintedSheet
Within a report, the PrintedSheet property is used to get and change the sheet of a Spreadsheet control to be printed.
Versions 27 and later
GridlinesVisible
New in version 27
GridlinesVisible
GridlinesVisible
Indique si le quadrillage est visible dans un champ
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 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
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
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.
Minimum version required
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment