How do I set the spreadsheet column filters as active after loading remote data? I'm not applying any filters, only activating the dropdowns on each column.
I've tried setting it when adding a new sheet (commented out), as well as through code (last line), but can't get either method to work.
let ssResults = $("#spreadsheet").kendoSpreadsheet({
rows: 10,
columns: 10,
columnWidth: 192
}).data("kendoSpreadsheet");
let goodData = $.parseJSON(dataResults.d);
//put results in spreadsheet
let columnWidth = Object.keys(goodData[0]).length;//column count
let columnName = getCharFromNumber(columnWidth);//custom function to get excel letter column
ssResults.insertSheet({
rows: goodData.length + 2//, //header + info
//filter: {
// ref: "A2:" + columnName + (goodData.length + 2).toString() // Headers
//},
});
ssResults.activeSheet(ssResults.sheets()[ssResults.sheets().length - 1]);
ssResults.activeSheet().setDataSource(goodData);
ssResults.activeSheet().insertRow(0);
ssResults.activeSheet().range("A1:" + columnName + "1").merge().value(queryInfo).wrap(true);
ssResults.activeSheet().filter.ref = "A2:" + columnName + (goodData.length + 2).toString();
Does the kendo scheduler have an option to export data to excel format?
I currently have 8 columns in the grid and each column has the filter option enabled. I want to add more columns and provide the option to hide columns to the user.
I want to retain the filter option in all columns as it is most often used by the user, but provide the 'hide column' option ONLY in the last column, as in the attached mockup.
Is this possible? If so, how?
Is it like hide columnmenu in all columns except the last one and setting columns.filterable = true for all other columns?
Sorry for not adding any code, I am not a dev!
range.validation({
dataType: "list",
showButton: true,
comparerType: "list",
from: `"Item 1", Item 2, Items 3"`, // Double quotes after Item 1 is required, options: Item 1", Item 2, Item 3.
allowNulls: false,
type: "warning",
messageTemplate: "Invalid."
});
All I am using is treeview -
works fine with kendo.all.min.js (locally and CDN) but that is 3+Mb and slows down my page load
when I only use kendo.treeview.min.js I get " TypeError: window.kendo is undefined"
What are the min js files needed
Please see my sample code here: https://dojo.telerik.com/@bjoler/AKUMUroY
I don't want a verticle scrollbar in the grid, so I set the 'scrollable=false' on the grid.
But that seems to affect the footerTemplate that I want to merge some of the cells.
Is there a way to solve this?
