Handsontable - Incorrect value of the columnsRenderCalculator

by Aleksandra Maria Budnik

HTML

<h2>Handsontable - Incorrect value of the columnsRenderCalculator</h2>

<p>
To trigger the error, grab the horizontal scroll bar at the bottom of the table and repeatedly drag it from side to side.
</p>

<div id="sheet"></div>

		<!-- Load Handsontable v8.1.0 -->
		<script src="https://cdn.jsdelivr.net/npm/handsontable@8.1.0/dist/handsontable.full.min.js" integrity="sha256-g9pORzLbbgXYGWw/dP/ZUbx93IxoAtQS9iF9zFZwUrM=" crossorigin="anonymous"></script>
		<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@8.1.0/dist/handsontable.full.min.css" integrity="sha256-6DtubF3BgGQWQwxrHfJq5fpD1t9rDFfIFGfXkIMyAu0=" crossorigin="anonymous" media="screen">

CSS

body {
  margin: 20px 30px;
  font-size: 13px;
  font-family: 'Open Sans', Helvetica, Arial;
}

#sheet {
  overflow: hidden;
  width: 50vw;
  height: 50vh;
}

JavaScript

let hot;
let container = document.getElementById('sheet');
let columnDefs = new Array(27).fill({});
let data = null;
 
hot = new Handsontable(container, {
  rowHeaders: true,
  //data: Handsontable.helper.createSpreadsheetData(50, 27),
  columns: columnDefs,
  hiddenColumns: { indicators: false, columns: [0, 1, 2] },
  nestedHeaders: [
    	[
        {label: 'Group 1', colspan: 3},
        {label: 'Group 2', colspan: 3},
        {label: 'Group 3', colspan: 3},
        {label: 'Group 4', colspan: 3},
        {label: 'Group 5', colspan: 3},
        {label: 'Group 6', colspan: 3},
        {label: 'Group 7', colspan: 3},
        {label: 'Group 8', colspan: 3},
        {label: 'Group 9', colspan: 3}
      ],
    	['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA']
 		],
  minRows: 50,
  minCols: 28,
 	licenseKey: 'non-commercial-and-evaluation',
});