ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Spreadsheet control
  • 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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
You can manipulate a Spreadsheet controls and their cells in a window or report using the following WLanguage properties.
Properties available for a Spreadsheet control found in a 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 Spreadsheet controls:
AdjustmentModeThe AdjustmentMode property determines and changes how a Spreadsheet control is adjusted in a report.
BlurLevelThe BlurLevel property gets and sets the percentage of blur applied to a control in a report.
DisplayedItemThe 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.
GridlinesVisibleThe GridlinesVisible property is used to:
  • Determine whether or not gridlines are visible in a control.
  • Show or hide gridlines in a control.
HeaderVisibleThe HeaderVisible property is used to:
  • Determine if the row and column headers are displayed in a Spreadsheet control.
  • Show or hide the row and column headers in a Spreadsheet control.
HeightThe Height property gets and sets 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.
  • of a break cell in a Table or Looper control.
HiddenThe Hidden is used to:
  • Determine if a control in a report is hidden.
  • Redact or blur a control in a report.
NameThe 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.
NoteThe 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.
NoteTitleThe 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.
PlaneThe Plane property is used to:
  • Know:
    • the active plane of a window (or report) or the plane to which a control belongs.
    • the active plane of a WEBDEV element.
  • Edit:
    • the active plane of a window (or report) or associate a control with another plane.
    • the active plane of a WEBDEV element.
PrintAreaThe PrintArea property gets and sets the print area of a Spreadsheet control in a report.
PrintedSheetWithin a report, the PrintedSheet property is used to get and change the sheet of a Spreadsheet control to be printed.
ToolTipThe ToolTip property gets and sets the text displayed in a tooltip. This tooltip can be associated with:
  • a control in a window or page,
  • New in SaaS
    a control in a report. In this case, the tooltip will only be visible in the report viewer.
    Note: This feature is only available from WINDEV Suite SaaS 2025 Update 3.
ValueThe 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.
VisibleThe Visible property is used to:
  • Find out whether an element is visible.
  • Make an element visible or invisible.
WidthThe Width property gets and changes 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.
XThe 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).
YThe 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

Last update: 06/16/2025

Send a report | Local help