Handsontable expand

handsontable not working with hidden table

by restika

HTML

<input type="button" id="button2" value="Show Columns" />
<div id="example"></div>
<script src="https://cdn.jsdelivr.net/npm/handsontable@latest/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@latest/dist/handsontable.full.min.css">

JavaScript 1.7

var example = document.getElementById('example');
var hot1 = new Handsontable(example, {
licenseKey: 'non-commercial-and-evaluation',
  data: Handsontable.helper.createSpreadsheetData(100, 20),
  rowHeaders: true,
  colHeaders: true,
  fixedColumnsLeft: 1,
  hiddenColumns: {
    indicators: false,
    columns: []
  },
  collapsibleColumns :true,
  nestedHeaders: [
    ['A', {
      label: 'B',
      colspan: 9
    }, {
      label: 'C',
      colspan: 10
    }],
    ['A1', 'B1', 'B2', 'B3', 'B4', 'B5', 'B6', 'B7', 'B8', 'B9',
      'C1', 'C2', 'C3', 'C4', 'C5', 'C6', 'C7', 'C8', 'C9', 'C10'
    ]
  ]
});

var plugincollaps = hot1.getPlugin('collapsibleColumns'); 
plugincollaps.collapseAll();

var showColumns = function() {
  var plugin = hot1.getPlugin('hiddenColumns');
  plugin.showColumns([2, 3, 4, 5, 6, 7,13]);
  hot1.render();
  plugincollaps.expandAll();
}

hot1.addHook('afterColumnExpand', function (currentCollapsedColumns, destinationCollapsedColumns) {
 //hideColumns
 var hiddenColumns = hot1.getPlugin('hiddenColumns');
 //var hiddencolumnsarr = hiddenColumns.getHiddenColumns()
 //hiddenColumns.showColumns(hiddencolumnsarr);
 //hiddenColumns.hideColumns([]);
 hiddenColumns.hideColumns([2, 3, 4, 5, 6, 7]);
 hot1.render();
 });

$('#button2').click(showColumns);