Dynamic Image based on value

Suite and Optimus Suite 5
#1

Hi



Is it possible to replace a cell content based on the numeric value at the time of loading at client end?

For example, for



Value <50 - blue.png

Value 50 - 75 - green.png

Value 75 - 85 - yellow.png

Value 85 - 95 - amber.png

value >95 - red.png



Similarly, Is it possible to set background/font color of a cell based on value?



Thanks

S.Sekar

#2

There are two ways to achieve such functionality
a) use custom excell

b) use onCellChanged event ( available in pro version of grid
mygrid.attachEvent(“onCellChanged”,function(id,ind,value){
if (value <50 ) mygrid.cells(id,ind).cell.innerHTML="";
if (value >50 ) mygrid.cells(id,ind).cell.innerHTML="";
…
})

for styles it may look as
mygrid.cells(id,ind).cell.style.backgroundColor=“red”