getCellValue( row, col )



This method returns the value or contents of a grid cell. Ā The cell must be visible when this method is called.

Using "load fields into widgets" property

When using a database-driven grid with the "load fields into widgets" property enabled, getDataValue() will need to be used instead, as the data is no longer loaded directly onto the grid.



Parameters:

  • row - the row number to retrieve the value from; when using events such as onrowclick, onrowdblclick, onrowmouseover, and onrowmouseout, the row variable is automatically passed into the event and can be used as the parameter to this method; row numbers start with row 1

  • col - the column number to retrieve the value from; the column numbers are zero-based (i.e. the first column* is column 0, the second column is column 1, etc.)


*Column 0 refers to the first column as established during design-time (in Visual Designer). If movable columns is true, then the user could change the column order; getCellValue(row, 0) retrieves the value in the first column, even if the user has moved that column.

Example:

The following expression can be assigned to the onrowclick event of a grid with an id of "subfile" to start a Google search using the value in the first column of the row being clicked:

window.open("http://www.google.com/search?q=" + encodeURIComponent(getObj("subfile").grid.getCellValue(row, 0));

Alternatively, an expression such as "handleRowClick(row)" can be assigned to the event, and the following function can be placed into an external JavaScript file:

function handleRowClick(row) { var value = getObj("subfile").grid.getCellValue(row, 0); window.open("http://www.google.com/search?q=" + encodeURIComponent(value)); }