jQWidgets jqxPivotGrid cellsRenderer Property

Last Updated : 28 Dec, 2021

jQWidgets is a JavaScript framework for making web-based applications for PC and mobile devices. It is a very powerful, optimized, platform-independent, and widely supported framework. The jqxPivotGrid is a powerful and lightweight data visualization widget that is entirely written in JavaScript language. This widget is offering many advanced features and is highly customizable for different needs.

The cellsRenderer property is used for setting or getting the cellsRenderer function for the specified jqxPivotGrid widget that is used for rendering the pivot cells. The function should return a valid HTML string.

Syntax:

For setting the cellsRenderer property:

$('Selector').jqxPivotGrid({cellsRenderer: function (pivotCell) {
    var BG_Color = 'red';
    var cell_Text = pivotCell.formattedValue;
    return "<div style='background: "
        + BG_Color
        + "; width: 100%-8px; height: 270px; padding: 4px;'>"
        + cell_Text
        + "</div>";
});

For getting the cellsRenderer property:

$('#jqx_Pivot_Grid').jqxPivotGrid('cellsRenderer');

Linked Files: Download jQWidgets from the given link. In the HTML file, locate the script files in the downloaded folder.

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxsortable.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxmenu.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxpivot.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxpivotgrid.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqx-all.js”></script>

Example: The below example illustrates the jQWidgets jqxPivotGrid cellsRenderer property.

HTML

<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" 
          href="jqwidgets/styles/jqx.base.css" 
          type="text/css" /> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxmenu.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxpivot.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxpivotgrid.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqx-all.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxPivotGrid cellsRenderer Property 
        </h3> 
        <div id="jqx_Pivot_Grid" style="height: 160px;  
                                        width: 270px;"> 
        </div> 
        <script type="text/javascript"> 
            $(document).ready(function () { 
                var data = new Array(); 
                var i = 0; 
                while (i <= 2) { 
                    var Column = ["Company"]; 
                    var Domain = ["Progamming", 
                        "CS subjects", 
                        "GATE preparation"]; 
                    var Rank = ["Ranking"]; 
                    var row = {}; 
                    row["Domain"] = Domain[i]; 
                    row["Column"] = "Company"; 
                    row["Rank"] = "Domain"; 
                    data.push(row); 
                    i++; 
                } 
                var dataAdapter = new $.jqx.dataAdapter({ 
                    localdata: data, 
                    datafields: 
                        [ 
                            { name: 'Rank', type: 'string' }, 
                            { name: 'Domain', type: 'string' }, 
                            { name: 'Column', type: 'string' }, 
                        ] 
                }); 
                var pivotDataSource = new $.jqx.pivot( 
                    dataAdapter, 
                    { 
                        values: [ 
                            { text: 'GeeksforGeeks' } 
                        ], 
                        columns: [{ dataField: 'Column' }], 
                        rows: [{ dataField: 'Rank' }, 
                        { dataField: 'Domain' }], 
                    } 
                ); 
                $('#jqx_Pivot_Grid').jqxPivotGrid({ 
                    source: pivotDataSource, 
                    cellsRenderer: function (pivotCell) { 
                        var BG_Color = 'red'; 
                        var cell_Text = pivotCell.formattedValue; 
                        return "<div style='background: " 
                            + BG_Color 
                            + "; width: 100%-8px; height: 270px; padding: 4px;'>" 
                            + cell_Text 
                            + "</div>"; 
                    } 
                }); 
            }); 
        </script> 
    </center> 
</body> 
  
</html>