I am unable to get the manualFreezeColumn option to work with filters. With the contextMenu option the filters do not work. Without the contextMenu option the manualFreezeColumn doesn’t work. Here is the CDN I’m using:
<script src="https://docs.handsontable.com/pro/2.0.0/bower_components/handsontable-pro/dist/handsontable.full.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://docs.handsontable.com/pro/2.0.0/bower_components/handsontable-pro/dist/handsontable.full.min.css">
Here are the settings with manualFreezeColumn working:
var hotSettings = {
data: dataObject,
licenseKey: '*****-*****-*****-*****-*****', //License key is correct in actual code
columns: [
{
data: 'IDNumber',
type: 'numeric'
//,width: 40
}
],
stretchH: 'all',
autoWrapRow: true,
height: 350,
rowHeaders: true,
colHeaders: [
'ID'
],
contextMenu:true,
manualColumnFreeze: true,
columnSorting: true,
sortIndicator: true,
autoColumnSize: true,
manualRowResize: true,
manualColumnResize: true,
filters: true,
fillHandle: false,
dropdownMenu: true,
afterSelection: function (r, c) {
loadObject(dataObject[r]);
}
};
var hot = new Handsontable(hotElement, hotSettings);
Here is what the running table looks like:
Here are the settings where Filters are working:
var hotSettings = {
data: dataObject,
licenseKey: '*****-*****-*****-*****-*****', //License key is correct in actual code
columns: [
{
data: 'IDNumber',
type: 'numeric'
//,width: 40
}
],
stretchH: 'all',
autoWrapRow: true,
height: 350,
rowHeaders: true,
colHeaders: [
'ID'
],
manualColumnFreeze: true,
columnSorting: true,
sortIndicator: true,
autoColumnSize: true,
manualRowResize: true,
manualColumnResize: true,
filters: true,
fillHandle: false,
dropdownMenu: true,
afterSelection: function (r, c) {
loadObject(dataObject[r]);
}
};
var hot = new Handsontable(hotElement, hotSettings);
And here is what it looks like running:
Please help as I need both of these working at the same time.