Grid cell dynamic background color

[George Rossopoulos]

Hi

I have a field that contains an RGB value in Numeric (int) field which is the background color.

How can I change the field's background color to this value.

I can also change the field to string containing a color value like "#ffffff"

Thank you in advance for the help

George

[Saravanan Arunachalam]

Hi George, 

Thanks for contacting Syncfusion’s support. 

We have analyzed your requirement and achieved it by using query-cell-info event of Grid control. In that event, we have used an algorithm which change the rgb color code to hex color code and based on the hex color code we have changed the background color of the cell. Please refer to the below code example and api reference link. 

<ej-grid id="FlatGrid" datasource="ViewBag.datasource" allow-paging="true" query-cell-info="onQuerycellInfo"> 

    

    <e-columns> 

           . . . 

        <e-column field="RGB" header-text="RGB" text-align="Left" width="75"></e-column> 

    </e-columns> 

</ej-grid> 

 <script type="text/javascript"> 

     function onQuerycellInfo(args) { 

         if (args.column.field == "RGB") { 

             var val = args.text.split(","); 

             var str = "#" + componentToHex(parseInt(val[0])) + componentToHex(parseInt(val[1])) + componentToHex(parseInt(val[2])); 

             args.cell.bgColor = str; //change the background color based on hex code 

             $(args.cell).css("color", "white"); 

         } 

     } 

     function componentToHex(c) { 

         //Algorithm to convert rgb value to hex code. 

         var hex = c.toString(16); 

         return hex.length == 1 ? "0" + hex : hex; 

     } 

 </script> 

  

https://help.syncfusion.com/api/js/ejgrid#events:querycellinfo  

And also we have created a sample that can be download from the below link. 

http://www.syncfusion.com/downloads/support/forum/132771/ze/F132771-995640542  

Regards, 

Saravanan A. 

[George Rossopoulos]

Thank you for the prompt reply. As usual superb support!!!!

Thank you

George

[Saravanan Arunachalam]

Hi George,  

Thanks for your update.            

We are happy that the provided information helped you. 

Regards, 

Saravanan A.