ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or site / 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
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
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 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.
  • 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:
  • 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.
PrintAreaThe PrintArea property is used to get and change 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.
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: 05/23/2023

Send a report | Local help