manualColumnFreeze Not Working with Pro 2.0.0

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.

Hi @mac.spinks

I’ve used your settings to create a demo at Handsontable example - JSFiddle - Code Playground
Do you only have a single column in your dataset? I would like to test fixing but with one column it is not easy. Can you add to the demo all needed code to replicate the issue?

I can’t include the actual code due to some sensitivity. The only difference between the code I posted and the actual code is the number of columns. I believe I may have gotten the post wrong because I cannot duplicate it today. I was messing around with different CDNs when testing and may have been using a different one when getting the manualFreezeColumn to work. However, the CDNs in this post are the ones I am using today. In my code and in your example the manualFreezeColumn still will not work. How can you make your example have the manual fixing of the columns? I believe that will solve my issue.

The demo above was missing a contextMenu option. Here’s an updated example http://jsfiddle.net/f7oskoqz/

Now you can freeze and unfreeze columns via context menu. Is that something that you were looking for @mac.spinks?

1 Like

Ah, thank you. I was clicking the dropdown arrow and looking for “Freeze Column.” I didn’t know to right click on the column header to see the option. Thank you for your help.

I did find one issue. I updated that example to show 3 three columns and cut down the width (to simulate horizontal scroll). No matter what column you click on to freeze it always starts with the first column. For example, clicking on column 2 and selecting freeze column will Freeze Column 1. If you select column 2 again and select Freeze Column it then freezes column 2. It works in reverse order when unfreezing. Let’s say column 1 and 2 are frozen and you click on column 1 to unfreeze it. It will first unfreeze column 2. Then you will have column 1 again and select Unfreeze for column 1 to unfreeze. I can work around for now but it seems to be a slight bug in stacking the frozen columns beginning with 0 no matter what column you click on. http://jsfiddle.net/f7oskoqz/1/

Thank you for investigating this issue @mac.spinks

I belive that it’s originated here https://github.com/handsontable/handsontable/issues/4455

I believe that we can close the topic as there is no demo or reply for a long time now.