Promotic
WikipediaLinkedInYoutubeTwitterFacebook

SetCellBackColor - method of object PmTable

Description:
Sets background color of the cell (eventually the whole columns and rows).
Syntax:
SetCellBackColor(Row As Long, Col As Long, Value As String)
Calling:
oTable.SetCellBackColor row, col, "#000000" 'color setting by RGB String
Parameters:
Row(Long) If the value is >=0 then it is a index of the row (zero-based index).
Value -2 means the last row.
Value -3 sets the value to all rows.
Col(Long) If the value is >=0 then it is a index of the column (zero-based index).
Value -2 means the last column.
Value -3 sets the value to all columns.
Value(String) The new value to be written.
Note:
RGB String representing a color is written in the form of "#RRGGBB".

It is not possible to set the value -3 in both parameters Row and Col; if the value is set in one parameter, then it cannot be used in the other.

 
The method can also be called in the graphic item events for Web Panels.
Example:
Sets the background color of the second row
Dim oTable
Set oTable = pMe.Items("/Ax0").Acx
oTable.SetCellBackColor 1, -3, "#ff0000" 'Red
oTable.Draw
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice