Freezing Rows

The staticRowIndex option of the wijgrid widget allows you to keep particular rows static while scrolling vertically through the grid. You can set the index of row using this option to keep the rows static.

Note that all the rows before the static row will also be considered static.

For example, the script below sets the staticRowIndex to 2. Therefore, row 0 and 1 also remain static while scrolling.

Live Widget
Script

Script	Copy Code
<script id="scriptInit" type="text/javascript"> require(["wijmo.wijgrid"], function () { $(document).ready(function () { $("#wijgrid").height(300).wijgrid({ cellClicked: function (e, args) { alert(args.cell.value()); }, allowSorting: true, rowHeight: 50, scrollMode: "vertical", staticRowIndex: 2, //sets index for static rows allowVirtualScrolling: true, data: [ [27, 'Canada', 'Adams, Craig', 'RW'], [43, 'Germany', 'Boucher, Philippe', 'D', 'R'], [24, 'Canada', 'Cooke, Matt', 'LW', 'L'], [87, 'Canada', 'Crosby, Sidney (C)', 'C', 'L'], [1, 'United States', 'Curry, John', 'G', 'L'], [37, 'Canada', 'John, Craig', 'RW'], [23, 'United Kingdom', 'Boucher, Mathew', 'D', 'R'], [44, 'Canada', 'Brooke, Matt', 'LW', 'L'], [97, 'Japan', 'Crosby', 'Sidney (C)', 'C', 'L'], [2, 'United States', 'Curry', 'John', 'G', 'L'], [57, 'Canada', 'Glenda', 'James ', 'RW'], [23, 'Canada', 'James', 'Garrett ', 'D', 'R'], [74, 'United Kingdom', 'Wilfred, Henry ', 'LW', 'L'], [37, 'Canada', 'Crosby', 'Sidney (C)', 'C', 'L'], [16, 'United States', 'Denise', 'Love ', 'G', 'L'], [22, 'Canada', 'Tyrone', 'Yates ', 'RW'], [13, 'Japan', 'Boucher', 'Philippe', 'D', 'R'], [25, 'Canada', 'Cooke', 'Matt', 'LW', 'L'], [77, 'United Kingdom', 'Crosby, Sidney (C)', 'C', 'L'], [19, 'United States', 'Curry', 'John', 'G', 'L'], [47, 'Canada', 'Adams', 'Craig', 'RW'], [63, 'Germany', 'Boucher', 'Philippe', 'D', 'R'], [24, 'Canada', 'Cooke', 'Matt', 'LW', 'L'], [87, 'Canada', 'Douglas, Kelly (C)', 'C', 'L'], [18, 'United States', 'Curry, John', 'G', 'L'], [27, 'Canada', 'Adams', 'Craig', 'RW'], [33, 'Japan', 'Ida', 'Ortiz ', 'D', 'R'], [54, 'Germany', 'Cooke', 'Matt', 'LW', 'L'], [27, 'Canada', 'Crosby', 'Sidney (C)', 'C', 'L'], [14, 'United States', 'Darren', 'Miller ', 'G', 'L'] ], columns: [ { headerText: "Number",dataType:'number'}, { headerText: " Country",dataType:'string'}, {headerText: "Player", dataType:'string'}, {headerText: " Position", dataType:'string'}, ] }); }); }); </script>

Script

Copy Code

<script id="scriptInit" type="text/javascript">
    require(["wijmo.wijgrid"], function () {
        $(document).ready(function () {
            $("#wijgrid").height(300).wijgrid({
                cellClicked: function (e, args) {
                    alert(args.cell.value());
                },
                allowSorting: true,
                rowHeight: 50,
                scrollMode: "vertical", 
                staticRowIndex: 2, //sets index for static rows
                allowVirtualScrolling: true,
                data: [
                    [27, 'Canada', 'Adams, Craig', 'RW'],
                    [43, 'Germany', 'Boucher, Philippe', 'D', 'R'],
                    [24, 'Canada', 'Cooke, Matt', 'LW', 'L'],
                    [87, 'Canada', 'Crosby, Sidney (C)', 'C', 'L'],
                    [1, 'United States', 'Curry, John', 'G', 'L'],
                    [37, 'Canada', 'John, Craig', 'RW'],
                    [23, 'United Kingdom', 'Boucher, Mathew', 'D', 'R'],
                    [44, 'Canada', 'Brooke, Matt', 'LW', 'L'],
                    [97, 'Japan', 'Crosby', 'Sidney (C)', 'C', 'L'],
                    [2, 'United States', 'Curry', 'John', 'G', 'L'],
                    [57, 'Canada', 'Glenda', 'James ', 'RW'],
                    [23, 'Canada', 'James', 'Garrett ', 'D', 'R'],
                    [74, 'United Kingdom', 'Wilfred, Henry ', 'LW', 'L'],
                    [37, 'Canada', 'Crosby', 'Sidney (C)', 'C', 'L'],
                    [16, 'United States', 'Denise', 'Love ', 'G', 'L'],
                    [22, 'Canada', 'Tyrone', 'Yates ', 'RW'],
                    [13, 'Japan', 'Boucher', 'Philippe', 'D', 'R'],
                    [25, 'Canada', 'Cooke', 'Matt', 'LW', 'L'],
                    [77, 'United Kingdom', 'Crosby, Sidney (C)', 'C', 'L'],
                    [19, 'United States', 'Curry', 'John', 'G', 'L'],
                    [47, 'Canada', 'Adams', 'Craig', 'RW'],
                    [63, 'Germany', 'Boucher', 'Philippe', 'D', 'R'],
                    [24, 'Canada', 'Cooke', 'Matt', 'LW', 'L'],
                    [87, 'Canada', 'Douglas, Kelly  (C)', 'C', 'L'],
                    [18, 'United States', 'Curry, John', 'G', 'L'],
                    [27, 'Canada', 'Adams', 'Craig', 'RW'],
                    [33, 'Japan', 'Ida', 'Ortiz ', 'D', 'R'],
                    [54, 'Germany', 'Cooke', 'Matt', 'LW', 'L'],
                    [27, 'Canada', 'Crosby', 'Sidney (C)', 'C', 'L'],
                    [14, 'United States', 'Darren', 'Miller ', 'G', 'L']
              
                    ],

                columns: [
                      
                       { headerText: "Number",dataType:'number'}, 
                       { headerText: " Country",dataType:'string'},
                       {headerText:  "Player", dataType:'string'},
                       {headerText: " Position", dataType:'string'},
      
                ]
            });
        });
    });
</script>