Hello, we have situations in which we have to show a huge number of columns (i.e. 10.000 columns). In this case I have observed that the vertically scrolling is quit slow. Can you please give me an advice how to improve my implementation ?
Best regards, Hilger
function getRowCount(){
return 3;
}
function getColumnNames(){
var columnDefs = ["Row","driver_up","driver_down","passenger_up","passenger_down","obstacle_position:in","window_position:in","position_endstop_top","auto_up_time","auto_down_time","emergency_down_time"];
for(var i=columnDefs.length;i<10000;i++){
columnDefs[i] = "Signal_" + i;
}
return columnDefs;
}
function getRowValues(i){
var rowValues = [i];
for(var i=rowValues.length;i<10000;i++){
rowValues[i] = "";
}
return rowValues;
}
// main function
function configureHandson() {
var columnDefs = [];
var nRows;
var nColumns;
var rowData = [];
try {
nRows = getRowCount();
columnDefs = getColumnNames();
nColumns = columnDefs.length;
for (i = 0; i < nRows; i++) {
rowData[i] = [];
}
var nLastEnd = 3;
for (i = 0; i < nLastEnd; i++) {
rowValues = getRowValues(i);
rowData[i] = rowValues;
}
} catch (err) {
document.getElementById("demo").innerHTML = err.message;
}
var hotElement = document.querySelector('#hot');
var hotElementContainer = hotElement.parentNode;
function colHeaderRenderer(col) {
var name = columnDefs[col];
return '<div class="headerRotate">' + name + '</div>';
}
settings_demo = {
startRows: nRows,
startCols: nColumns,
rowHeaders: true,
colHeaders: columnDefs,
columnHeaderHeight: 150,
data: rowData,
autoRowSize: false,
autoColSize: false,
hiddenRows: {
rows:[],
indicators: true
},
hiddenColumns : {
columns:[],
indicators: true
},
colHeaders: colHeaderRenderer
};
hot = new Handsontable(hotElement, settings_demo);
}