Demo - Frozen Rows and Columns

by Joel Parks

HTML

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.grapecity.com/wijmo/5.latest/styles/wijmo.min.css">
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.min.js"></script>
<script src="https://cdn.grapecity.com/wijmo/5.latest/controls/wijmo.grid.min.js"></script>
<div class="container">

  <h1>
    Frozen Rows and Columns</h1>
  <p>
    You can freeze rows and columns by setting the grid's 
    <b>frozenRows</b> and <b>frozenColumns</b> properties.</p>
  <p>
    Frozen cells do not scroll but are selectable/editable
    like regular cells:</p>
  <div id="theGrid"></div>

  <button id="btnFreezeRows" class="btn btn-default">
    Toggle Frozen Rows
  </button>
  <button id="btnFreezeCols" class="btn btn-default">
    Toggle Frozen Columns
  </button>
</div>

CSS

.wj-flexgrid {
  max-height: 250px; 
  margin: 10px 0;
}
body {
  margin-bottom: 20px;
}

/* style frozen cells */
.wj-cell.wj-frozen:not(.wj-header):not(.wj-group):not(.wj-state-selected):not(.wj-state-multi-selected),
.wj-cell.wj-frozen.wj-alt:not(.wj-header):not(.wj-group):not(.wj-state-selected):not(.wj-state-multi-selected) {
  background: rgb(255,255,125);
}

JavaScript

onload = function () {

  // generate some random data
  var countries = 'US,Germany,UK,Japan,Italy,Greece'.split(','),
      data = [];
  for (var i = 0; i < 200; i++) {
    data.push({
    	id: i,
      country: countries[i % countries.length],
      downloads: Math.round(Math.random() * 20000),
      sales: Math.random() * 10000,
      expenses: Math.random() * 5000,
      num1: Math.random() * 5000,
      num2: Math.random() * 5000,
      num3: Math.random() * 5000,
      num4: Math.random() * 5000,
      num5: Math.random() * 5000,
    });
  }

	// default behavior: allow column reordering
  var theGrid = new wijmo.grid.FlexGrid('#theGrid', {
    itemsSource: data,
    frozenRows: 2,
    frozenColumns: 8
  });
  
  // toggle frozen rows
  document.getElementById('btnFreezeRows').addEventListener('click', function() {
  	theGrid.frozenRows = theGrid.frozenRows > 0 ? 0 : 2;
  });
  document.getElementById('btnFreezeCols').addEventListener('click', function() {
  	theGrid.frozenColumns = theGrid.frozenColumns > 0 ? 0 : 1;
  });
}