Promotic
WikipediaLinkedInYoutubeTwitterFacebook

CellForeColor - property of object PmTable

Description:
Text color of table cell (eventually whole columns and rows).

This property is obsolete (but functional) and is replaced by SetCellForeColor and GetCellForeColor methods.

Syntax:
CellForeColor(Row As Long, Col As Long) As String
Calling:
oTable.CellForeColor(row, col) = "#000000" 'color setting by RGB String
sColor = oTable.CellForeColor(row, col) 'in sColor is a RGB String in the form "#RRGGBB"
Parameters:
Row(Long) If the value is greater or equal 0 then it is a index of the row (zero-based index, counted including the fixed part).
Value -2 means the last row.
Value -3 sets the value to all rows (counted including the fixed part).
Col(Long) If the value is greater or equal 0 then it is a index of the column (zero-based index, counted including the fixed part).
Value -2 means the last column.
Value -3 sets the value to all columns (counted including the fixed part).
Note:
Property access for read and write. The property returns/sets the RGB String in the form "#RRGGBB".

This property is not functional for Web panels in JavaScript language.

Example1:
Sets the color of the first row
VBScriptSelect and copy to clipboard

Dim oTable
Set oTable = pMe.Acx
oTable.CellForeColor(0, -3) = "#ff0000"  'Red
oTable.Draw
Example2:
Sets the color of the cell in the 2nd row and the 3rd column
VBScriptSelect and copy to clipboard

Dim oTable
Set oTable = pMe.Acx
oTable.CellForeColor(1, 2) = "#0000d0"  'Blue
oTable.Draw
PROMOTIC 8.3.22 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice