Spreadsheet control properties

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

Spreadsheet control properties

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

Properties available for the Spreadsheet control

The following properties are associated with Spreadsheet controls:


AdjustmentMode	The AdjustmentMode property determines and changes how a Spreadsheet control is adjusted in a report.
BlurLevel	The BlurLevel property gets and sets the percentage of blur applied to a control in a report.
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.
GridlinesVisible	The GridlinesVisible property is used to: Determine whether or not gridlines are visible in a control. Show or hide gridlines in a control.
HeaderVisible	The 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.
Height	The 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.
Hidden	The Hidden is used to: Determine if a control in a report is hidden. Redact or blur a control in a report.
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.
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.
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.
Plane	The 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.
PrintArea	The PrintArea property gets and sets the print area of a Spreadsheet control in a report.
PrintedSheet	Within a report, the PrintedSheet property is used to get and change the sheet of a Spreadsheet control to be printed.
ToolTip	The 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.
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.
Visible	The Visible property is used to: Find out whether an element is visible. Make an element visible or invisible.
Width	The 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.
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).
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.