Difference between revisions of "Grid"

From Lianjapedia
Jump to: navigation, search
(→‎Properties)
 
(43 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.
 
Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.
  
−
====Properties====
+
====Description====
 +
Shown below in a standalone [[Form]].  Click the image to see in a [[Custom_Sections_and_Gadgets|Custom Section]] in a Lianja [[Page Attributes|Page]].
  
 +
[[{{ns:file}}:grid_column.png|link={{filepath:grid_column_header_cs.png}}|Grid, Column]]
 +
 +
A grid is a container object that displays data in rows and columns, and is similar in appearance to a Browse window. A grid is also a container object that contains [[Column]] objects. A column can contain a [[Header]] object and controls. Because a grid and its columns, headers, and controls each have their own set of properties, you have complete control over each element of the grid.
 +
 +
====Properties====
 
This class supports the [[:Category:Common_Properties|Common Properties]] plus the following:
 
This class supports the [[:Category:Common_Properties|Common Properties]] plus the following:
  
−
{| class="wikitable" width=100%
+
{| class="wikitable" width="100%"
 
!width="20%"|Property
 
!width="20%"|Property
 
!Access (R/RW)
 
!Access (R/RW)
Line 11: Line 17:
 
!width="50%"|Description
 
!width="50%"|Description
 
|-
 
|-
−
|RowCount
+
|ActionBar
 
|RW
 
|RW
−
|Numeric
+
|Boolean
−
|Number of rows
+
|actionBar visibility
 
|-
 
|-
−
|RowHeight
+
|ActiveColumn
 
|RW
 
|RW
 
|Numeric
 
|Numeric
−
|Row height in pixels
+
|Currently selected [[Column|column]]
 
|-
 
|-
 
|ActiveRow
 
|ActiveRow
Line 26: Line 32:
 
|Currently selected row
 
|Currently selected row
 
|-
 
|-
−
|ActiveColumn
+
|valign="top"|AlternatingRowColors
 +
|valign="top"|RW
 +
|valign="top"|Boolean
 +
|valign="top"|Whether rows have alternating background colors
 +
|-
 +
|valign="top"|AutoPagination
 +
|valign="top"|RW
 +
|valign="top"|Boolean
 +
|valign="top"|Whether grids are paginated over the table size specified in AutoPaginationSize, default is True
 +
|-
 +
|valign="top"|AutoPaginationSize
 +
|valign="top"|RW
 +
|valign="top"|Numeric
 +
|valign="top"|Table size (number of records) over which AutoPagination applies, default is 1000
 +
|-
 +
|AutoResizeColumns
 
|RW
 
|RW
−
|Numeric
+
|Boolean
−
|Currently selected column
+
|Whether grid auto resizes to the maximum width when data is loaded
 
|-
 
|-
 
|ColumnCount
 
|ColumnCount
Line 35: Line 56:
 
|Numeric
 
|Numeric
 
|Number of columns
 
|Number of columns
 +
|-
 +
|valign="top"|ContextMenu
 +
|valign="top"|RW
 +
|valign="top"|Character
 +
|valign="top"|A comma separated string containing menu items, e.g. "Apples,Pears,Bananas".  This works in conjunction with the rightclick event when the grid is Readonly.  When the grid is rightclicked, the context menu is displayed.  When a menu item is selected, the text for the menu item is passed to the rightclick delegate.  Note: for editable grids, the rightclick delegate is only called when the right click happens in the top left 'button' of the grid, not in the body of the grid.
 +
|-
 +
|Filter
 +
|RW
 +
|Character
 +
|Filter expression to restrict data included in the grid
 +
|-
 +
|GridLineColor
 +
|RW
 +
|Numeric
 +
|Color of grid lines
 
|-
 
|-
 
|GridLines
 
|GridLines
Line 41: Line 77:
 
|Whether grid lines are displayed
 
|Whether grid lines are displayed
 
|-
 
|-
−
|valign="top"|AlternatingRowColors
+
|HeaderHeight
 +
|RW
 +
|Numeric
 +
|Column header height in pixels
 +
|-
 +
|valign="top"|KineticScrolling
 
|valign="top"|RW
 
|valign="top"|RW
 
|valign="top"|Boolean
 
|valign="top"|Boolean
−
|valign="top"|Whether rows have alternating background colors
+
|valign="top"|Whether kinetic scrolling is enabled, default is False.  With kinetic scrolling, the user can flick in a given direction and it will continue to scroll in this direction until it is stopped either by the user or by friction.  Setting KineticScrolling to true provides touch scrolling on touch aware devices and left mouse button pressed and moved scrolling on non-touch aware devices.
 +
|-
 +
|valign="top"|Pagination
 +
|valign="top"|RW
 +
|valign="top"|Boolean
 +
|valign="top"|Whether grids are paginated regardless of table size, default is False
 +
|-
 +
|Picture
 +
|RW
 +
|Character
 +
|Filename of background image
 
|-
 
|-
 
|Readonly
 
|Readonly
Line 51: Line 102:
 
|Whether grid is readonly
 
|Whether grid is readonly
 
|-
 
|-
−
|WordWrap
+
|Recno
−
|RW
+
|R
−
|Boolean
+
|Numeric
−
|Whether text is word-wrapped
+
|Current record number
 
|-
 
|-
−
|valign="top"|Scrollbars
+
|valign="top"|RecordMark
 
|valign="top"|RW
 
|valign="top"|RW
 
|valign="top"|Numeric
 
|valign="top"|Numeric
−
|valign="top"|Scrollbars displayed: 0 = none, 1 = horizontal, 2 = vertical
+
|valign="top"|Whether record number column is displayed: 0 (False), 1 (True).  This should be set before populating the grid and cannot be toggled.
 
|-
 
|-
−
|valign="top"|RelativeRow
+
|valign="top"|RecordSource
−
|valign="top"|R
+
|valign="top"|RW
 +
|valign="top"|Character
 +
|valign="top"|Source of data to which the grid is bound
 +
|-
 +
|valign="top"|RecordSourceType
 +
|valign="top"|RW
 
|valign="top"|Numeric
 
|valign="top"|Numeric
−
|valign="top"|Currently selected row relative to the grid display
+
|valign="top"|Data source type: 0 = table, 1 = alias, 4 = SQL statement
 
|-
 
|-
 
|valign="top"|RelativeColumn
 
|valign="top"|RelativeColumn
Line 71: Line 127:
 
|valign="top"|Currently selected column relative to the grid display
 
|valign="top"|Currently selected column relative to the grid display
 
|-
 
|-
−
|HeaderHeight
+
|valign="top"|RelativeRow
 +
|valign="top"|R
 +
|valign="top"|Numeric
 +
|valign="top"|Currently selected row relative to the grid display
 +
|-
 +
|valign="top"|RowColChange
 +
|valign="top"|RW
 +
|valign="top"|Numeric
 +
|valign="top"|Type of cell movement made: 0 = no change, 1 = row change, 2 = column change, 3 = row and column change
 +
|-
 +
|valign="top"|RowColChangeClickEnabled
 +
|valign="top"|RW
 +
|valign="top"|Numeric
 +
|valign="top"|Enable or disable click being called on a row or column change: 0 = disabled, 1 = enabled.  From v6.0.3.
 +
|-
 +
|RowCount
 
|RW
 
|RW
 
|Numeric
 
|Numeric
−
|Column header height in pixels
+
|Number of rows
 
|-
 
|-
−
|GridLineColor
+
|RowHeight
 
|RW
 
|RW
 
|Numeric
 
|Numeric
−
|Color of grid lines
+
|Row height in pixels
 
|-
 
|-
−
|valign="top"|RecordSource
+
|Rowid
−
|valign="top"|RW
+
|R
−
|valign="top"|Character
+
|Numeric
−
|valign="top"|Source of data to which the grid is bound
+
|Current record number
−
|-
+
−
|valign="top"|RecordSourceType
+
−
|valign="top"|RW
+
−
|valign="top"|Numeric
+
−
|valign="top"|Data source type: 0 = table, 1 = alias, 4 = SQL statement
+
 
|-
 
|-
 
|valign="top"|RowSource
 
|valign="top"|RowSource
−
 
 
|valign="top"|RW
 
|valign="top"|RW
 
|valign="top"|Character
 
|valign="top"|Character
Line 100: Line 165:
 
|valign="top"|RW
 
|valign="top"|RW
 
|valign="top"|Numeric
 
|valign="top"|Numeric
−
|valign="top"|Data source type: 0 = table, 1 = alias, 4 = SQL statement
+
|valign="top"|Data source type: 1 = table, 2 = alias, 3 = SQL statement
 
|-
 
|-
−
|valign="top"|RecordMark
+
|valign="top"|Scrollbars
 
|valign="top"|RW
 
|valign="top"|RW
 
|valign="top"|Numeric
 
|valign="top"|Numeric
−
|valign="top"|Whether record number column is displayed: 0 (False), 1 (True)
+
|valign="top"|Scrollbars displayed: 0 = none, 1 = horizontal, 2 = vertical
 
|-
 
|-
−
|valign="top"|RowColChange
+
|StretchLastColumn
−
|valign="top"|RW
+
|RW
−
|valign="top"|Numeric
+
|Boolean
−
|valign="top"|Type of cell movement made: 0 = no change, 1 = row change, 2 = column change, 3 = row and column change
+
|Whether the last grid column is stretched to fill the available space
 
|-
 
|-
 
|valign="top"|ViewMode
 
|valign="top"|ViewMode
 
|valign="top"|RW
 
|valign="top"|RW
−
|valign="top"|Boolean
+
|valign="top"|Numeric
 
|valign="top"|View mode for split grids: 0 = grid view, 1 = form view, 2 = split view
 
|valign="top"|View mode for split grids: 0 = grid view, 1 = form view, 2 = split view
 
|-
 
|-
−
|Relatedform
+
|WordWrap
 
|RW
 
|RW
−
|
+
|Boolean
−
|
+
|Whether text is word-wrapped
−
|-
+
−
|Picture
+
−
|RW
+
−
|Character
+
−
|Filename of background image
+
−
|-
+
−
|Recno
+
−
|R
+
−
|Numeric
+
−
|Current record number
+
−
|-
+
−
|Rowid
+
−
|R
+
−
|Numeric
+
−
|Current record number
+
 
|-
 
|-
 
|}
 
|}
  
 
====Methods====
 
====Methods====
−
 
 
This class supports the [[:Category:Common_Methods|Common Methods]] plus the following:
 
This class supports the [[:Category:Common_Methods|Common Methods]] plus the following:
  
−
{| class="wikitable" width=100%
+
{| class="wikitable" width="100%"
 
!width="20%"|Method
 
!width="20%"|Method
 
!Args
 
!Args
 
!width="50%"|Description
 
!width="50%"|Description
 +
|-
 +
|valign="top"|ActivateCell
 +
|valign="top"|row as Numeric, column as Numeric
 +
|valign="top"|Select the cell at the specified row and column position
 +
|-
 +
|valign="top"|Add
 +
|valign="top"|None
 +
|valign="top"|Add a new record
 
|-
 
|-
 
|valign="top"|AddColumn
 
|valign="top"|AddColumn
Line 152: Line 209:
 
|valign="top"|Add a column at the specified column position
 
|valign="top"|Add a column at the specified column position
 
|-
 
|-
−
|valign="top"|RemoveColumn
+
|valign="top"|AddItem
−
|valign="top"|column as Numeric
+
|valign="top"|data as Character
−
|valign="top"|Remove a column at the specified column position
+
|valign="top"|Add an item
 +
|-
 +
|valign="top"|AddItems
 +
|valign="top"|selectstatement as Character | commalist as Character | pipelist as Character | items as Array [,headers as Array[, headerwidths as Array]]
 +
|valign="top"|Add items based on an SQL SELECT query, a comma-separated list, a pipe-separated list or an array, optionally specifying a second array with column header text and a third with column header widths
 
|-
 
|-
 
|valign="top"|AddObject
 
|valign="top"|AddObject
Line 160: Line 221:
 
|valign="top"|Add an existing object or a new object, in which case the object's class must also be specified and optionally its caption
 
|valign="top"|Add an existing object or a new object, in which case the object's class must also be specified and optionally its caption
 
|-
 
|-
−
|valign="top"|RemoveObject
+
|valign="top"|Autofit
−
|valign="top"|existing as Object
+
|valign="top"|None
−
|valign="top"|Remove the specified object
+
|valign="top"|Resize the columns to fit the grid
 
|-
 
|-
−
|valign="top"|Columns
+
|valign="top"|Cancel
−
|valign="top"|column as Numeric
+
|valign="top"|None
−
|valign="top"|Return an object reference to the specified column
+
|valign="top"|Cancel data changes
 
|-
 
|-
 
|valign="top"|Clear
 
|valign="top"|Clear
Line 172: Line 233:
 
|valign="top"|Clear the grid
 
|valign="top"|Clear the grid
 
|-
 
|-
−
|valign="top"|Autofit
+
|valign="top"|Columns
 +
|valign="top"|column as Numeric
 +
|valign="top"|Return an object reference to the specified [[Column]]
 +
|-
 +
|valign="top"|Delete
 
|valign="top"|None
 
|valign="top"|None
−
|valign="top"|Resize the columns to fit the grid
+
|valign="top"|Delete the current record
 
|-
 
|-
 
|valign="top"|DoScroll
 
|valign="top"|DoScroll
Line 180: Line 245:
 
|valign="top"|Scroll: 0 = up, 1 = down, 2 = page up, 3 = page down, 4 = left, 5 = right, 6 = page left, 7 = page right, 8 = top, 9 = bottom
 
|valign="top"|Scroll: 0 = up, 1 = down, 2 = page up, 3 = page down, 4 = left, 5 = right, 6 = page left, 7 = page right, 8 = top, 9 = bottom
 
|-
 
|-
−
|valign="top"|ActivateCell
+
|valign="top"|First
 +
|valign="top"|None
 +
|valign="top"|Move to the first data record
 +
|-
 +
|valign="top"|GetItemColor
 
|valign="top"|row as Numeric, column as Numeric
 
|valign="top"|row as Numeric, column as Numeric
−
|valign="top"|Select the cell at the specified row and column position
+
|valign="top"|Return a color pair bg,fg for the specified cell.  From v5.3.
 
|-
 
|-
−
|valign="top"|AddItem
+
|valign="top"|GetRowColor
−
|valign="top"|data as Character
+
|valign="top"|row as Numeric
−
|valign="top"|Add an item
+
|valign="top"|Return a | separates list of color pairs bg,fg for the specified row.  From v5.3.
 
|-
 
|-
−
|valign="top"|AddItems
+
|valign="top"|Goto
−
|valign="top"|selectstatement as Character | commalist as Character | pipelist as Character | items as Array [,headers as Array[, headerwidths as Array]]
+
|valign="top"|recordnumber as Numeric [, scroll as Numeric]
−
|valign="top"|Add items based on an SQL SELECT query, a comma-separated list, a pipe-separated list or an array, optionally specifying a second array with column header text and a third with column header widths
+
|valign="top"|Go to the specified record number.<br>Optionally specify the scroll position:<br>0 = scroll to ensure that the item is visible<br>1 = scroll to position the item at the top of the viewport<br>2 = scroll to position the item at the bottom of the viewport<br>3 = scroll to position the item at the center of the viewport.<br>Scroll argument from v5.5.
 
|-
 
|-
−
|valign="top"|Sort
+
|valign="top"|HideAllRows
−
|valign="top"|column as Numeric, direction as Numeric
+
|valign="top"|None
−
|valign="top"|Sort data on the specified column.  Data is sorted in descending order if direction < 0
+
|valign="top"|Hide all rows.  From v6.0.
 +
|-
 +
|valign="top"|HideRow
 +
|valign="top"|row as Numeric
 +
|valign="top"|Hide the specified row.  Rows start from 1.  From v6.0.
 +
|-
 +
|valign="top"|Item
 +
|valign="top"|row as Numeric, column as Numeric [, value as Expression]
 +
|valign="top"|Return the item text from the specified cell.<br>The optional value can be specified to update the item text.
 +
|-
 +
|valign="top"|Last
 +
|valign="top"|None
 +
|valign="top"|Move to the last data record.  For paginated grids, move to the last record on the last page.
 +
|-
 +
|valign="top"|Next
 +
|valign="top"|None
 +
|valign="top"|Move to the next page
 +
|-
 +
|valign="top"|Previous
 +
|valign="top"|None
 +
|valign="top"|Move to the previous page
 +
|-
 +
|valign="top"|RemoveColumn
 +
|valign="top"|column as Numeric
 +
|valign="top"|Remove a column at the specified column position
 +
|-
 +
|valign="top"|RemoveObject
 +
|valign="top"|existing as Object
 +
|valign="top"|Remove the specified object
 +
|-
 +
|valign="top"|Save
 +
|valign="top"|None
 +
|valign="top"|Save data changes
 
|-
 
|-
 
|valign="top"|Search
 
|valign="top"|Search
Line 200: Line 301:
 
|valign="top"|Search for searchstring in the currently selected column
 
|valign="top"|Search for searchstring in the currently selected column
 
|-
 
|-
−
|valign="top"|Goto
+
|valign="top"|SetItemColor
−
|valign="top"|recordnumber as Numeric
+
|valign="top"|row as Numeric, column as Numeric, foregroundcolor as Character, backgroundcolor as Character
−
|valign="top"|Go to the specified record number
+
|valign="top"|Set the foreground and background colors for the specified cell. (From v4.1).
 
|-
 
|-
−
|valign="top"|Item
+
|valign="top"|SetRowColor
−
|valign="top"|row as Numeric, column as Numeric
+
|valign="top"|row as Numeric, foregroundcolor as Character, backgroundcolor as Character
−
|valign="top"|Return the item text from the specified cell
+
|valign="top"|Set the foreground and background colors for the specified row. (From v4.1).
 +
|-
 +
|valign="top"|ShowAllRows
 +
|valign="top"|None
 +
|valign="top"|Show all rows.  From v6.0.
 +
|-
 +
|valign="top"|ShowRow
 +
|valign="top"|row as Numeric
 +
|valign="top"|Show the specified row.  Rows start from 1.  From v6.0.
 +
|-
 +
|valign="top"|Sort
 +
|valign="top"|column as Numeric, direction as Numeric
 +
|valign="top"|Sort data on the specified column.  Data is sorted in descending order if direction < 0.  <br>Note: Column numbers start from 0.
 
|-
 
|-
 
|}
 
|}
  
 
====Events====
 
====Events====
−
 
 
This class supports the [[:Category:Common_Events|Common Events]] plus the following:
 
This class supports the [[:Category:Common_Events|Common Events]] plus the following:
  
−
{| class="wikitable" width=100%
+
{| class="wikitable" width="100%"
 
!width="20%"|Event
 
!width="20%"|Event
 
!Args
 
!Args
 
!width="50%"|Description
 
!width="50%"|Description
 
|-
 
|-
−
|valign="top"|afterRowChange
+
|valign="top"|afterRowColChange
 +
|valign="top"|row as Numeric
 +
|valign="top"|Occurs after moving column in the same row. Row numbers start from 0.
 +
|-
 +
|valign="top"|beforeRowColChange
 
|valign="top"|column as Numeric
 
|valign="top"|column as Numeric
−
|valign="top"|Occurs after the when event on moving row
+
|valign="top"|Occurs after data has changed and before the valid event.  Column numbers start from 0.
−
|-
+
−
|valign="top"|beforeRowChange
+
−
|valign="top"|None
+
−
|valign="top"|Occurs after data has changed and before the valid event
+
 
|-
 
|-
 
|valign="top"|dragDrop
 
|valign="top"|dragDrop
Line 234: Line 346:
 
|valign="top"|source as Object, x as Numeric, y as Numeric, state as Numeric
 
|valign="top"|source as Object, x as Numeric, y as Numeric, state as Numeric
 
|valign="top"|Occurs when an object is dragged over the grid
 
|valign="top"|Occurs when an object is dragged over the grid
 +
|-
 +
|valign="top"|interactiveChange
 +
|valign="top"|None
 +
|valign="top"|Occurs after data has been changed interactively and after the valid event
 
|-
 
|-
 
|}
 
|}

Latest revision as of 07:12, 16 April 2021

Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.

Description

Shown below in a standalone Form. Click the image to see in a Custom Section in a Lianja Page.

Grid, Column

A grid is a container object that displays data in rows and columns, and is similar in appearance to a Browse window. A grid is also a container object that contains Column objects. A column can contain a Header object and controls. Because a grid and its columns, headers, and controls each have their own set of properties, you have complete control over each element of the grid.

Properties

This class supports the Common Properties plus the following:

Property Access (R/RW) Value Description
ActionBar RW Boolean actionBar visibility
ActiveColumn RW Numeric Currently selected column
ActiveRow RW Numeric Currently selected row
AlternatingRowColors RW Boolean Whether rows have alternating background colors
AutoPagination RW Boolean Whether grids are paginated over the table size specified in AutoPaginationSize, default is True
AutoPaginationSize RW Numeric Table size (number of records) over which AutoPagination applies, default is 1000
AutoResizeColumns RW Boolean Whether grid auto resizes to the maximum width when data is loaded
ColumnCount RW Numeric Number of columns
ContextMenu RW Character A comma separated string containing menu items, e.g. "Apples,Pears,Bananas". This works in conjunction with the rightclick event when the grid is Readonly. When the grid is rightclicked, the context menu is displayed. When a menu item is selected, the text for the menu item is passed to the rightclick delegate. Note: for editable grids, the rightclick delegate is only called when the right click happens in the top left 'button' of the grid, not in the body of the grid.
Filter RW Character Filter expression to restrict data included in the grid
GridLineColor RW Numeric Color of grid lines
GridLines RW Boolean Whether grid lines are displayed
HeaderHeight RW Numeric Column header height in pixels
KineticScrolling RW Boolean Whether kinetic scrolling is enabled, default is False. With kinetic scrolling, the user can flick in a given direction and it will continue to scroll in this direction until it is stopped either by the user or by friction. Setting KineticScrolling to true provides touch scrolling on touch aware devices and left mouse button pressed and moved scrolling on non-touch aware devices.
Pagination RW Boolean Whether grids are paginated regardless of table size, default is False
Picture RW Character Filename of background image
Readonly RW Boolean Whether grid is readonly
Recno R Numeric Current record number
RecordMark RW Numeric Whether record number column is displayed: 0 (False), 1 (True). This should be set before populating the grid and cannot be toggled.
RecordSource RW Character Source of data to which the grid is bound
RecordSourceType RW Numeric Data source type: 0 = table, 1 = alias, 4 = SQL statement
RelativeColumn R Numeric Currently selected column relative to the grid display
RelativeRow R Numeric Currently selected row relative to the grid display
RowColChange RW Numeric Type of cell movement made: 0 = no change, 1 = row change, 2 = column change, 3 = row and column change
RowColChangeClickEnabled RW Numeric Enable or disable click being called on a row or column change: 0 = disabled, 1 = enabled. From v6.0.3.
RowCount RW Numeric Number of rows
RowHeight RW Numeric Row height in pixels
Rowid R Numeric Current record number
RowSource RW Character Source of data to which the grid is bound
RowSourceType RW Numeric Data source type: 1 = table, 2 = alias, 3 = SQL statement
Scrollbars RW Numeric Scrollbars displayed: 0 = none, 1 = horizontal, 2 = vertical
StretchLastColumn RW Boolean Whether the last grid column is stretched to fill the available space
ViewMode RW Numeric View mode for split grids: 0 = grid view, 1 = form view, 2 = split view
WordWrap RW Boolean Whether text is word-wrapped

Methods

This class supports the Common Methods plus the following:

Method Args Description
ActivateCell row as Numeric, column as Numeric Select the cell at the specified row and column position
Add None Add a new record
AddColumn column as Numeric Add a column at the specified column position
AddItem data as Character Add an item
AddItems selectstatement as Character | commalist as Character | pipelist as Character | items as Array [,headers as Array[, headerwidths as Array]] Add items based on an SQL SELECT query, a comma-separated list, a pipe-separated list or an array, optionally specifying a second array with column header text and a third with column header widths
AddObject existing as Object | newobject as Character, class as Character Add an existing object or a new object, in which case the object's class must also be specified and optionally its caption
Autofit None Resize the columns to fit the grid
Cancel None Cancel data changes
Clear None Clear the grid
Columns column as Numeric Return an object reference to the specified Column
Delete None Delete the current record
DoScroll scroll as Numeric Scroll: 0 = up, 1 = down, 2 = page up, 3 = page down, 4 = left, 5 = right, 6 = page left, 7 = page right, 8 = top, 9 = bottom
First None Move to the first data record
GetItemColor row as Numeric, column as Numeric Return a color pair bg,fg for the specified cell. From v5.3.
GetRowColor row as Numeric Return a | separates list of color pairs bg,fg for the specified row. From v5.3.
Goto recordnumber as Numeric [, scroll as Numeric] Go to the specified record number.
Optionally specify the scroll position:
0 = scroll to ensure that the item is visible
1 = scroll to position the item at the top of the viewport
2 = scroll to position the item at the bottom of the viewport
3 = scroll to position the item at the center of the viewport.
Scroll argument from v5.5.
HideAllRows None Hide all rows. From v6.0.
HideRow row as Numeric Hide the specified row. Rows start from 1. From v6.0.
Item row as Numeric, column as Numeric [, value as Expression] Return the item text from the specified cell.
The optional value can be specified to update the item text.
Last None Move to the last data record. For paginated grids, move to the last record on the last page.
Next None Move to the next page
Previous None Move to the previous page
RemoveColumn column as Numeric Remove a column at the specified column position
RemoveObject existing as Object Remove the specified object
Save None Save data changes
Search searchstring as Character Search for searchstring in the currently selected column
SetItemColor row as Numeric, column as Numeric, foregroundcolor as Character, backgroundcolor as Character Set the foreground and background colors for the specified cell. (From v4.1).
SetRowColor row as Numeric, foregroundcolor as Character, backgroundcolor as Character Set the foreground and background colors for the specified row. (From v4.1).
ShowAllRows None Show all rows. From v6.0.
ShowRow row as Numeric Show the specified row. Rows start from 1. From v6.0.
Sort column as Numeric, direction as Numeric Sort data on the specified column. Data is sorted in descending order if direction < 0.
Note: Column numbers start from 0.

Events

This class supports the Common Events plus the following:

Event Args Description
afterRowColChange row as Numeric Occurs after moving column in the same row. Row numbers start from 0.
beforeRowColChange column as Numeric Occurs after data has changed and before the valid event. Column numbers start from 0.
dragDrop source as Object, x as Numeric, y as Numeric, state as Numeric Occurs when an object is dropped into the grid
dragOver source as Object, x as Numeric, y as Numeric, state as Numeric Occurs when an object is dragged over the grid
interactiveChange None Occurs after data has been changed interactively and after the valid event
Retrieved from "https://www.lianja.com/doc/index.php?title=Grid&oldid=24506"