Speed up the autoFitColumn() ?

[Daniel]

How can i speed up a autoFitColumn() on multi-headers grid?

In the screenshot you can see that each column fitting make Recalculate Styles. Is it possible to cache width of the fitted column without firing up CSS and then after all columns width are calculated use grid.setOptions() to set columns width with new fitted width?

Also i need to use dirty hack:   hideColumn();showColumn() becouse footer isn't fitted to columns.

Table.prototype.fitColumns = function(){
    var self = this;
    var count = 0;
    var col;
    var selected = this.grid.select().data('uid');
    for (var i = 0; i < this.grid.columns.length; i++) {
        var multi = this.grid.columns[i].columns;
        if (multi){
            _.forEach(multi, function(el, j){
                if (el.columns){
                    _.forEach(el.columns, function(el2, k){
                        col = multi[j].columns[k];
                        if (!col.attributes || (col.attributes && !col.attributes.noFit)) self.grid.autoFitColumn(col);
                    });
                }
                else {
                    col = multi[j];
                    if (!col.attributes || (col.attributes && !col.attributes.noFit)) self.grid.autoFitColumn(col);
                }
            });
        } else {
            col = self.grid.columns[i];
            if (!col.attributes || (col.attributes && !col.attributes.noFit)) self.grid.autoFitColumn(col);
        }
    }
    this.grid.refresh();
    this.fitted = true;
    if (selected) this.grid.select("tr[data-uid='" + selected + "']");
    this.grid.hideColumn(1);
    this.grid.showColumn(1);
};

[Viktor Tachev]

Hello Daniel,

Note that if you auto resize all columns this will likely result in having white space on the right of the Grid. Also, resizing the columns one by one is an "expensive" operation from performance perspective. This will become more noticeable with larger number of rows.

Thus, if you you would like to have the columns of the Grid auto resized I would recommend to disable scrolling for the Grid and ensure that it is using automatic table layout.

• http://docs.telerik.com/kendo-ui/controls/data-management/grid/appearance#column-widths

Regards,
Viktor Tachev
Telerik by Progress

[Daniel]

Ok, but then when i set overflow to grid container and scrolling it headers are not frozen :/

[Viktor Tachev]

Hello Daniel,

In order for the frozen columns to work as expected you need to ensure that the conditions listed in the following article are met.

• http://docs.telerik.com/kendo-ui/controls/data-management/grid/appearance#locked-columns

Regards,
Viktor Tachev
Telerik by Progress