PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Properties available for a Spreadsheet control found in a window
  • Properties available for the Spreadsheet control
  • Properties available for the cells of the Spreadsheet control
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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
WINDEV

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 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 table cell
Versions 09 and later
BrushColor
New in version 09
BrushColor
BrushColor
..BrushColor is used to manage the background color of a control, window, page or report block.
Versions 09 and later
Caption
New in version 09
Caption
Caption
In a database, ..Caption is used to:
  • Find out the caption associated with an item of a data file
  • Find out the caption associated with a data file
  • Find out and modify the caption of a connection
In a report, ..Caption is used to:
  • Find out the text displayed in a Static control or in a link control.
  • Modify the text displayed in a Static control or in a 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 color of the font 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 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 is used to find out and modify the name of the button that will be run when a double click is performed 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 takes 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 find out and modify the height:
  • of a control or block in a report.
  • of a control (found in a window), window, row found in a table, in a list box or in a listview, option found in a radio button or in a check box, break header or break footer found in a table or in a looper.
  • of a control (found in a page), break header or break footer found in a table or in a looper. The control can be stackable 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.
  • 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
Note
New in version 09
Note
Note
..Note is used to:
  • Find out the notes associated with a control, a window or a page.
  • Modify the notes associated with a control, a window or a 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 window, control or page
  • Modify the title of the notes used in the program documentation of a control, window or page
Versions 09 and later
NumberColumn
New in version 09
NumberColumn
NumberColumn
..NumberColumn is used to:
  • Find out the number of columns found in a control containing columns (Table, Check box, Radio button, ...)
  • Modify the number of columns found in a multicolumn list box
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 12 and later
Occurrence
New in version 12
Occurrence
Occurrence
..Occurrence is used to find out the number of elements found in a set.
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, ...
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 and modify the characteristics of selection (or cursor) in the Word Processing 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 status 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 overloads).
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
Versions 20 and later
ToolbarVisible
New in version 20
ToolbarVisible
ToolbarVisible
..ToolbarVisible is used to
  • in a Spreadsheet control
    • Find out whether the toolbar is displayed
    • Display (or not) the toolbar.
  • in a Word Processing control
    • Find out whether the ribbon is displayed
    • Display (or not) a ribbon.
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 stackable 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 "Edit by the end user" mode.
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 the X axis).
  • Modify the X coordinate of a control or window (position on the 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 or 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 the 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 or window (position on the Y axis) when the window is opened.
  • Modify the Y coordinate of a control anchored "to the bottom" (position on the vertical axis) when the window is opened.
  • Find out the Y coordinate of a control in relation to its block (position in millimeters on the vertical axis) when the report is opened.
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 window.
Versions 09 and later
ZOrder
New in version 09
ZOrder
ZOrder
..ZOrder is used to manage the z-order position of a control.
WINDEV

Properties available for the cells of the Spreadsheet control

The following properties are associated with the cells of the Spreadsheet control:
Versions 09 and later
BrushColor
New in version 09
BrushColor
BrushColor
..BrushColor 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 color of the font 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 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 find out and modify the height:
  • of a control or block in a report.
  • of a control (found in a window), window, row found in a table, in a list box or in a listview, option found in a radio button or in a check box, break header or break footer found in a table or in a looper.
  • of a control (found in a page), break header or break footer found in a table or in a looper. The control can be stackable 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 stackable 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 "Edit by the end user" mode.
Versions 21 and later
Properties available for a Spreadsheet control found in a report
WINDEVWEBDEV - Server code

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 find out and modify the height:
  • of a control or block in a report.
  • of a control (found in a window), window, row found in a table, in a list box or in a listview, option found in a radio button or in a check box, break header or break footer found in a table or in a looper.
  • of a control (found in a page), break header or break footer found in a table or in a looper. The control can be stackable 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
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
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 stackable 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 the X axis).
  • Modify the X coordinate of a control or window (position on the 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 the 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
WINDEVWEBDEV - Server code

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 find out and modify the height:
  • of a control or block in a report.
  • of a control (found in a window), window, row found in a table, in a list box or in a listview, option found in a radio button or in a check box, break header or break footer found in a table or in a looper.
  • of a control (found in a page), break header or break footer found in a table or in a looper. The control can be stackable 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
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
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 stackable 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 the X axis).
  • Modify the X coordinate of a control or window (position on the 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 the Y axis).
  • Modify the Y coordinate of a control or window
Properties available for a Spreadsheet control found in a report
WINDEVWEBDEV - Server code

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 find out and modify the height:
  • of a control or block in a report.
  • of a control (found in a window), window, row found in a table, in a list box or in a listview, option found in a radio button or in a check box, break header or break footer found in a table or in a looper.
  • of a control (found in a page), break header or break footer found in a table or in a looper. The control can be stackable 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
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
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 stackable 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 the X axis).
  • Modify the X coordinate of a control or window (position on the 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 the Y axis).
  • Modify the Y coordinate of a control or window
Minimum required version
  • Version 20
This page is also available for…
Comments
Click [Add] to post a comment