Properties associated with the Spreadsheet control

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

Properties associated with the Spreadsheet control

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

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

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

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.