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 the Spreadsheet control
Properties available for the cells of Spreadsheet control
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

Properties available for the Spreadsheet control

The following properties are associated with the Spreadsheet controls:


Versions 09 and later Anchor New in version 09 Anchor Anchor	..Anchor is used to manage the anchor of a control in a window or report.
Versions 09 and later AnchorRateBottom New in version 09 AnchorRateBottom AnchorRateBottom	..AnchorRateBottom is used to: Find out the anchor rate when a control moves on the vertical axis. Modify the anchor rate when a control moves on the vertical axis.
Versions 09 and later AnchorRateHeight New in version 09 AnchorRateHeight AnchorRateHeight	..AnchorRateHeight is used to: Find out the anchor rate in height of a control. Modify the anchor rate in height of a control.
Versions 09 and later AnchorRateRight New in version 09 AnchorRateRight AnchorRateRight	..AnchorRateRight is used to: Find out the anchor rate when a control moves on the horizontal axis. Modify the anchor rate when a control moves on the horizontal axis.
Versions 09 and later AnchorRateWidth New in version 09 AnchorRateWidth AnchorRateWidth	..AnchorRateWidth is used to: Find out the anchor rate when a control (or a table column) stretches on the horizontal axis. Modify the anchor rate when a control (or a table column) stretches on the horizontal axis.
Versions 09 and later BackgroundColor New in version 09 BackgroundColor BackgroundColor	..BackgroundColor is used to manage the background color of a control, window, page or report block.
Versions 14 and later BackgroundImageLine New in version 14 BackgroundImageLine BackgroundImageLine	..BackgroundImageLine is used to find out and modify the background image used for each row: of a Table control, of a TreeView Table control, of a Looper control.
Versions 14 and later Border New in version 14 Border Border	..Border is used to find out and modify the border characteristics: for a report control or for a report block. for a window control. for a cell of a Table control.
Versions 09 and later Caption New in version 09 Caption Caption	In a database, ..Caption is used to: Find out the caption associated with a file item. Find out the caption associated with a data file. Find out and modify the connection caption. In a report, ..Caption is used to: Find out the text displayed in a Static or Link control. Modify the text displayed in a Static or Link control. In a window or in a page, ..Caption is used to: Find out and modify the caption of a control in a window or in a page. Find out and modify the caption of a menu option. Find out and modify the title of a window or page. Find out the content of a site map path.
Versions 09 and later Color New in version 09 Color Color	..Color is used to find out and modify the font color for: a font variable. a text displayed in a Static control or in a calculated control of a report. a text displayed in a window control. a text displayed in a page control.
Versions 14 and later Content New in version 14 Content Content	..Content is used to read or write the content of a control: Memory List Box, Memory Combo Box, Spreadsheet.
Versions 12 and later Count New in version 12 Count Count	..Count is used to find out the number of elements in a set.
Versions 20 and later CurrentWorksheet New in version 20 CurrentWorksheet CurrentWorksheet	..CurrentWorksheet is used to find out and modify the current worksheet in a Spreadsheet control.
Versions 09 and later DisplayEnabled New in version 09 DisplayEnabled DisplayEnabled	..DisplayEnabled is used to: find out whether the display of a control or window is enabled or not. If the display is enabled, the content of the control is refreshed on a regular basis. enable (or not) the display of a control or window.
Versions 09 and later DoubleClick New in version 09 DoubleClick DoubleClick	..DoubleClick allows you to know and modify the name of the Button control that will be executed when double-clicking on a control.
Versions 09 and later Empty New in version 09 Empty Empty	..Empty is used to find out whether: a Looper, Table, List Box or Combo Box control is empty. The control can be a browsing control or a memory control. a Chart control contains no series. a report control is empty (control linked to an item). an array (or an associative array) contains no element. an element of an associative array exists or not. a queue, a list or a stack contains no element.
Versions 09 and later FileLink New in version 09 FileLink FileLink	..FileLink is used to find out and modify the link between a control: and an item found in a data file. and a variable. and several variables.
Versions 23 and later FilePath New in version 23 FilePath FilePath	..FilePath is used to find out: the name of xlsx file associated with a Spreadsheet control. This name is initialized by SpreadsheetLoad and SpreadsheetSave. the name of file associated with an Image Editor control. This name is initialized by PicOpen and PicSave. the name of PDF file associated with a PDF Reader control. This name is initialized by PDFReaderOpen. the name of DOCX file associated with a Word Processing control. This name is initialized by DocOpen and DocSave.
Versions 14 and later FillType New in version 14 FillType FillType	..FillType is used to find out the type of source used to fill the Table, List Box, ListView, Combo Box and Looper controls.
Versions 16 and later FocusOnClick New in version 16 FocusOnClick FocusOnClick	..FocusOnClick is used to: Find out whether a control gains focus during a click. Modify the effect for taking focus during the click on a control.
Versions 09 and later Font New in version 09 Font Font	..Font is used to: Find out the identifier of the font used in a control found in a report, in a page or in a window. Modify the font used in a control found in a report, in a page or in a window.
Versions 09 and later FontCharset New in version 09 FontCharset FontCharset	..FontCharset is used to: Find out the character set used by the screen fonts of a control. Modify the character set used by the screen fonts of a control.
Versions 20 and later FormulaBarVisible New in version 20 FormulaBarVisible FormulaBarVisible	..FormulaBarVisible is used to: Find out whether a formula bar is displayed in a Spreadsheet control. Display (or not) a formula bar in a Spreadsheet control.
Versions 09 and later FullName New in version 09 FullName FullName	..FullName is used to find out the full name: of a control. of a window. of a menu option. of a table column.
Versions 17 and later Grayed New in version 17 Grayed Grayed	..Grayed is used to: Find out whether a control (or a group of controls) is grayed or not. Gray or ungray a control or a group of controls.
Versions 23 and later GridlinesVisible New in version 23 GridlinesVisible GridlinesVisible	..GridlinesVisible is used to: Find out whether the gridlines are visible or not in a Spreadsheet control. Modify the visibility of gridlines in a Spreadsheet control.
Versions 09 and later Group New in version 09 Group Group	..Group is used to: find out whether the control belongs to a group of controls. If the control belongs to one or more groups, ..Group is used to identify these groups of controls. associate a control with a group of controls.
Versions 20 and later HeaderVisible New in version 20 HeaderVisible HeaderVisible	..HeaderVisible 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	..Height is used 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 HelpNumber New in version 09 HelpNumber HelpNumber	..HelpNumber is used to find out and modify the help number associated with a control.
Versions 09 and later InitialContent New in version 09 InitialContent InitialContent	..InitialContent is used to find out and modify the initial content: of a memory List Box control. of a memory Combo Box control. of a "List of values" column found in a Table control. in a Spreadsheet control.
Versions 09 and later InitialHeight New in version 09 InitialHeight InitialHeight	..InitialHeight is used to: Find out the creation height of a control or window. Modify the base height used to anchor the controls "in height". Find out the creation height of a block or control in a report.
Versions 09 and later InitialState New in version 09 InitialState InitialState	..InitialState is used to find out the initial status of a control.
Versions 09 and later InitialValue New in version 09 InitialValue InitialValue	..InitialValue is used to find out the initial value of a control found in a window or in a page.
Versions 09 and later InitialVisible New in version 09 InitialVisible InitialVisible	..InitialVisible is used to find out whether: a control was visible during the first display of the associated window or page. a window was visible during its first display.
Versions 09 and later InitialWidth New in version 09 InitialWidth InitialWidth	..InitialWidth is used to: Find out the initial width of a control or window. Modify the base width used to anchor the controls in "width". Find out the initial width of a report control.
Versions 17 and later InputEnabled New in version 17 InputEnabled InputEnabled	..InputEnabled is used to: Find out whether a control or a group of controls is editable or read-only. Modify the input options for a control or for a group of controls.
Versions 20 and later InputFormula New in version 20 InputFormula InputFormula	..InputFormula is used to: find out whether the end user can enter or modify formulas in a Spreadsheet control. allow (or not) the end user to enter or modify formulas in a Spreadsheet control.
Versions 20 and later InputValue New in version 20 InputValue InputValue	..InputValue is used to: find out whether the end user can enter or modify values in a Spreadsheet control. allow or not the end user to enter or modify values in a Spreadsheet control.
Versions 09 and later LineHeight New in version 09 LineHeight LineHeight	..LineHeight is used to find out and modify the height of rows: in a List Box control, in a ListView control (standard display mode only), in a Table control, in a Combo Box control, in a Looper control (height of the row), in an Organizer control.
Versions 09 and later MaxHeight New in version 09 MaxHeight MaxHeight	..MaxHeight is used to find out and modify the maximum height of a control or window.
Versions 09 and later MaxLineHeight New in version 09 MaxLineHeight MaxLineHeight	..MaxLineHeight is used to find out and modify the maximum height of: the rows in a Table control (case of multiline rows with automatic resizing). the rows in a Treeview Table control. the rows in a Looper control.
Versions 09 and later MaxWidth New in version 09 MaxWidth MaxWidth	..MaxWidth is used to find out and modify the maximum width of a control or window.
Versions 11 and later Message New in version 11 Message Message	..Message is used to: Find out the help message associated with a control or with a menu option (in a window). Modify the help message associated with a control or with a menu option (in a window).
Versions 09 and later MinHeight New in version 09 MinHeight MinHeight	..MinHeight is used to find out and modify the minimum height of a control or window.
Versions 09 and later MinWidth New in version 09 MinWidth MinWidth	..MinWidth is used to find out and modify the minimum width of a control or window.
Versions 09 and later Modified New in version 09 Modified Modified	..Modified is used to find out whether a control (or a group of controls) was modified by the user (with the keyboard or with the mouse.
Versions 09 and later MouseCursor New in version 09 MouseCursor MouseCursor	..MouseCursor is used to find out and modify the rollover cursor defined for a control, a window or a page.
Versions 20 and later MultiWorksheet New in version 20 MultiWorksheet MultiWorksheet	..MultiWorksheet is used to: Find out whether a Spreadsheet control manages several worksheets. Modify the mode for managing the worksheets in a Spreadsheet control.
Versions 09 and later Name New in version 09 Name Name	..Name is used to find out: 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 20 and later NbWorksheet New in version 20 NbWorksheet NbWorksheet	..NbWorksheet is used to find out the number of worksheets in a Spreadsheet control.
Versions 09 and later NewLine New in version 09 NewLine NewLine	..NewLine is used to find out: in a Table control, whether the current row was created by TableAddXXX or TableInsertXXX. in a Looper control, whether the current row was created by LooperAddXXX or LooperInsertXXX. in an Organizer control, whether an appointment was created via the popup menu. in a Scheduler control, whether an appointment was created via the popup menu.
Versions 09 and later NoteTitle New in version 09 NoteTitle NoteTitle	..NoteTitle is used 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 NumberColumn New in version 09 NumberColumn NumberColumn	..NumberColumn is used to: Find out the number of columns in a control containing columns (Table, Check Box, Radio Button controls, etc.). Modify the number of columns in a multi-column List Box control.
Versions 20 and later NumberRow New in version 20 NumberRow NumberRow	..NumberRow returns the maximum number of rows containing data in a Spreadsheet control. These rows contain data, a formula, formatting or a non-standard height.
Versions 09 and later Opacity New in version 09 Opacity Opacity	..Opacity is used to find out and define the percentage of opacity for a window or for the controls found in a window or in a page.
Versions 19 and later Pane New in version 19 Pane Pane	..Pane is used to: Find out the pane tabs associated with a control. Define the pane tabs associated with a control.
Versions 21 and later ParallaxRateHeight New in version 21 ParallaxRateHeight ParallaxRateHeight	..ParallaxRateHeight is used to find out and specify the speed at which a control is reduced when the scrollbar found in the window, the internal window or the page moves.
Versions 21 and later ParallaxRateY New in version 21 ParallaxRateY ParallaxRateY	..ParallaxRateY is used to find out and specify the speed at which a control moves when the scrollbar found in the window, the internal window or the page moves.
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 09 and later PopupMenu New in version 09 PopupMenu PopupMenu	..PopupMenu is used to: Find out the custom popup menu associated with a control or window. Modify the popup menu associated with a control or window (associate another popup menu with the control or window). Customize the system menus of controls by adding options.
Versions 19 and later Process New in version 19 Process Process	..Process is used to modify the processes that must be run by the events available on a control, window, page, report, etc.
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 24 and later Ribbon New in version 24 Ribbon Ribbon	The ..Ribbon property is used to access the Ribbon control of the associated control (Word Processing, PDF Reader, Spreadsheet or Image Editor controls).
Versions 09 and later RightClick New in version 09 RightClick RightClick	..RightClick is used to find out and modify the name of the button that will be run when a right click is performed on an object.
Versions 12 and later RightToLeft New in version 12 RightToLeft RightToLeft	..RightToLeft is used to find out the actual writing direction, effective on a control, a column, a window or a report.
Versions 22 and later Selection New in version 22 Selection Selection	..Selection is used to find out the characteristics of the selection (or cursor): in the Word Processing control. Remark: This selection is located in the section currently edited in the control (body, header or footer). in the Spreadsheet control.
Versions 11 and later Size New in version 11 Size Size	..Size is used to find out and modify the size of an element.
Versions 09 and later State New in version 09 State State	..State is used to find out and modify the display state of an element.
Versions 20 and later Style New in version 20 Style Style	..Style is used to find out and assign the entire style of a control (including the overrides).
Versions 09 and later TABOrder New in version 09 TABOrder TABOrder	..TABOrder is used to find out and modify the position of a control in the tab order of a window.
Versions 15 and later TextDirection New in version 15 TextDirection TextDirection	..TextDirection is used to find out and modify the writing direction used in a window, in a report or in a control (useful for managing languages such as Arabic or Hebrew).
Versions 19 and later TitleHeight New in version 19 TitleHeight TitleHeight	..TitleHeight is used to find out and modify : the height of the title for the columns of a Table or TreeView Table control. the height of the title bar of a Dockable Panel control.
Versions 20 and later ToolbarVisible New in version 20 ToolbarVisible ToolbarVisible	..ToolbarVisible is used to: Find out whether the control ribbon is displayed. Display (or not) a ribbon for the control.
Versions 09 and later ToolTip New in version 09 ToolTip ToolTip	..ToolTip is used to find out and modify the text displayed in the tooltip associated with a control found in a window or in a page.
Versions 09 and later Type New in version 09 Type Type	..Type is used to find out: the type of element described by programming (file or item description) or not (file or item defined in the data model editor, view or query). the type of object. the type of value stored in a variant.
Versions 09 and later Value New in version 09 Value Value	..Value 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	..Visible is used to: Find out whether an element is visible. Make an element visible or invisible.
Versions 15 and later VisualEffect New in version 15 VisualEffect VisualEffect	..VisualEffect is used to manage a visual effect on a control or on a group of controls found in a window.
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 21 and later WinEditAllowed New in version 21 WinEditAllowed WinEditAllowed	..WinEditAllowed is used to find out and modify the operations allowed on a control when the window switches to the mode "Modification of UI by the end user".
Versions 20 and later WorksheetName New in version 20 WorksheetName WorksheetName	..WorksheetName is used to find out and modify the name of the current worksheet in a Spreadsheet control.
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 XInitial New in version 09 XInitial XInitial	..XInitial is used to: Find out the X coordinate: of a control (position on X axis) when opening the window or the page. of a window (position on X axis) when opening the window. Modify the X coordinate of a control anchored "to right" (position on X axis) when opening the window. Find out the X coordinate of a control in relation to its block (position in millimeters on X axis) when opening the report.
Versions 09 and later Y New in version 09 Y Y	..Y 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.
Versions 09 and later YInitial New in version 09 YInitial YInitial	..YInitial is used to: Find out the Y coordinate: of a control (position on Y axis) when opening the window or the page. of a window (position on Y axis) when opening the window. Modify the Y coordinate of a control anchored "to bottom" (position on the vertical axis) when opening the window. Find out the Y coordinate of a control in relation to its block (position in millimeters on the vertical axis) when opening the report.
Versions 12 and later Zoom New in version 12 Zoom Zoom	..Zoom allows you to find out and modify the zoom value used: in an Image control. in a Map control. in an Organization Chart control. in a Table, TreeView Table, Pivot Table, Spreadsheet or List Box control. in a Word Processing control. in a PDF Reader control. in a window.
Versions 09 and later ZOrder New in version 09 ZOrder ZOrder	..ZOrder is used to manage the z-order position of a control.

Properties available for the cells of Spreadsheet control

The following properties are associated with the cells of Spreadsheet control:


Versions 09 and later BackgroundColor New in version 09 BackgroundColor BackgroundColor	..BackgroundColor is used to manage the background color of a control, window, page or report block.
Versions 09 and later Color New in version 09 Color Color	..Color is used to find out and modify the font color for: a font variable. a text displayed in a Static control or in a calculated control of a report. a text displayed in a window control. a text displayed in a page control.
Versions 25 and later Comment New in version 25 Comment Comment	Représenté un commentaire dans une feuille XLS ou un champ Tableur
Versions 09 and later DisplayedValue New in version 09 DisplayedValue DisplayedValue	..DisplayedValue is used to find out the value currently displayed on the screen in a window control or in a page control.
Versions 09 and later Font New in version 09 Font Font	..Font is used to: Find out the identifier of the font used in a control found in a report, in a page or in a window. Modify the font used in a control found in a report, in a page or in a window.
Versions 09 and later FontBold New in version 09 FontBold FontBold	..FontBold is used to: Find out whether a text is bold or not. Modify the weight of a text.
Versions 09 and later FontCharset New in version 09 FontCharset FontCharset	..FontCharset is used to: Find out the character set used by the screen fonts of a control. Modify the character set used by the screen fonts of a control.
Versions 09 and later FontCondensed New in version 09 FontCondensed FontCondensed	..FontCondensed is used to: Find out whether the characters in a text are condensed or not. Condense (or not) the characters in a text.
Versions 09 and later FontExtended New in version 09 FontExtended FontExtended	..FontExtended is used to: Find out whether the characters in a text are extended or not. Extend (or not) the characters displayed in a text.
Versions 09 and later FontItalic New in version 09 FontItalic FontItalic	..FontItalic is used to: Find out whether the italic attribute is assigned to a text. Modify the italic attribute of a text.
Versions 09 and later FontLarge New in version 09 FontLarge FontLarge	..FontLarge is used to: Find out whether the characters in a text are enlarged or not. Enlarge (or not) the characters in a text.
Versions 09 and later FontName New in version 09 FontName FontName	..FontName is used to: Find out the font used in a control. Modify the font used in a control.
Versions 09 and later FontSize New in version 09 FontSize FontSize	..FontSize is used to: Find out the size of the font used in a control. Modify the size of the font used in a control.
Versions 09 and later FontStrikeOut New in version 09 FontStrikeOut FontStrikeOut	..FontStrikeOut is used to: Find out whether a text is struck out or not. Strike out (or not) the text displayed in a control.
Versions 09 and later FontUnderlined New in version 09 FontUnderlined FontUnderlined	..FontUnderlined is used to: Find out whether a text is underlined or not. Underline (or not) a text.
Versions 09 and later FullName New in version 09 FullName FullName	..FullName is used to find out the full name: of a control. of a window. of a menu option. of a table column.
Versions 09 and later Height New in version 09 Height Height	..Height is used 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 InputMask New in version 09 InputMask InputMask	..InputMask is used to: find out the input mask. modify the input mask (among the available masks for the type).
Versions 12 and later Merge New in version 12 Merge Merge	..Merge is used to merge the cells found in a Table or TreeView Table control.
Versions 09 and later Name New in version 09 Name Name	..Name is used to find out: 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 21 and later ParallaxRateHeight New in version 21 ParallaxRateHeight ParallaxRateHeight	..ParallaxRateHeight is used to find out and specify the speed at which a control is reduced when the scrollbar found in the window, the internal window or the page moves.
Versions 21 and later ParallaxRateY New in version 21 ParallaxRateY ParallaxRateY	..ParallaxRateY is used to find out and specify the speed at which a control moves when the scrollbar found in the window, the internal window or the page moves.
Versions 09 and later Selected New in version 09 Selected Selected	..Selected is used to find out whether a row is selected (in a List Box control, a ListView control or a Table control) and to select a row (in a List Box control, a ListView control or a Table control).
Versions 09 and later Type New in version 09 Type Type	..Type is used to find out: the type of element described by programming (file or item description) or not (file or item defined in the data model editor, view or query). the type of object. the type of value stored in a variant.
Versions 09 and later Value New in version 09 Value Value	..Value 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 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 21 and later WinEditAllowed New in version 21 WinEditAllowed WinEditAllowed	..WinEditAllowed is used to find out and modify the operations allowed on a control when the window switches to the mode "Modification of UI by the end user".

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	..AdjustmentMode is used to find out and modify the adjustment mode of a Spreadsheet control in a report.
Versions 09 and later DisplayedItem New in version 09 DisplayedItem DisplayedItem	..DisplayedItem 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 23 and later GridlinesVisible New in version 23 GridlinesVisible GridlinesVisible	..GridlinesVisible is used 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	..HeaderVisible 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	..Height is used 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	..Name is used to find out: 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	..NoteTitle is used 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	..PrintArea is used find out and modify the area to print for a Spreadsheet control found in a report.
Versions 21 and later PrintedSheet New in version 21 PrintedSheet PrintedSheet	..PrintedSheet is used find out and modify the sheet to print for a Spreadsheet control found in a 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	..Value 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	..Visible 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	..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	..Y 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

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	..AdjustmentMode is used to find out and modify the adjustment mode of a Spreadsheet control in a report.
Versions 09 and later DisplayedItem New in version 09 DisplayedItem DisplayedItem	..DisplayedItem 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 23 and later GridlinesVisible New in version 23 GridlinesVisible GridlinesVisible	..GridlinesVisible is used 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	..HeaderVisible 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	..Height is used 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	..Name is used to find out: 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	..NoteTitle is used 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	..PrintArea is used find out and modify the area to print for a Spreadsheet control found in a report.
Versions 21 and later PrintedSheet New in version 21 PrintedSheet PrintedSheet	..PrintedSheet is used find out and modify the sheet to print for a Spreadsheet control found in a 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	..Value 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	..Visible 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	..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	..Y 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

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	..AdjustmentMode is used to find out and modify the adjustment mode of a Spreadsheet control in a report.
Versions 09 and later DisplayedItem New in version 09 DisplayedItem DisplayedItem	..DisplayedItem 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 23 and later GridlinesVisible New in version 23 GridlinesVisible GridlinesVisible	..GridlinesVisible is used 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	..HeaderVisible 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	..Height is used 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	..Name is used to find out: 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	..NoteTitle is used 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	..PrintArea is used find out and modify the area to print for a Spreadsheet control found in a report.
Versions 21 and later PrintedSheet New in version 21 PrintedSheet PrintedSheet	..PrintedSheet is used find out and modify the sheet to print for a Spreadsheet control found in a 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	..Value 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	..Visible 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	..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	..Y 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.