Hi,
Need to figure out the proper way to attach a new sheet. to the kendoSpreadsheet's option: sheets. I tried the below code:
$(document).ready(function () {
//render and initialize kendoSpreadsheet:
$("#spreadsheet").kendoSpreadsheet({
columns: 20,
rows: 200,
toolbar: true,
sheetsbar: true,
sheets: mySheets,
width: "100%"
});
//render and initialize kendoButton:
$("#load-new-sheet-btn").kendoButton({
icon: "forward",
themeColor: "primary",
click: swapSheets // want to render new set of sheets. Is this possible?
});
});
//assign a different JavaScript object to the sheets: option parameter (this doesn't seem to refresh the spreadsheet component/control:
function swapSheets()
{
var currSpreadSheet = $("#spreadsheet").data("kendoSpreadsheet");
console.log("BEFORE clearing sheets: currentSpreadSheet contents: ", currSpreadSheet.options.sheets)
currSpreadSheet.options.sheets = mySheetsTwo;
console.log("AFTER clearing sheets: currentSpreadSheet contents: ", currSpreadSheet.options.sheets);
currSpreadSheet.refresh();
}
You can see the whole code in action here in the Dojo:
Spreadsheet Demo Swapping Sheets | Kendo UI Dojo (telerik.com)
Also, my requirements want to load a stylized formatted sheet (ergo probably a sheet object), and X number of sheets with raw data…with a different dataSource associated to those raw data sheets.
The ultimate goal is to load data into a sheet object in from an API without rerendering the entire page or destroying the current spreadsheet component (and creating a new one). Most importantly, or we can constrain the question to how to point sheets: to a new JSON sheet structure.
Here is a screen shot of what is happening:
It seems like I can re-assign the sheets object, but refreshing or binding the new sheets object is not being done successfully.
Hope this all makes sense,
George
Hi,
In the jQuery Spreadsheet Widget, it is possible to add a comment to a cell. When the comment contains a newline character '\n', then the comment tooltip of the spreadsheet does not show the newline.
How can we allow newlines in a comment tooltip of a Spreadsheet Cell?
( I think that the js kendo version 2022 contained that functionality)
Kind regards!
I'd like to highlight cells, in a range.forEachCell method, but each cell has to have a different highlight (background colour) based on some rules. It's quite slow. Is there a way to do this quicker?
Thanks,
Marc
$("#spreadsheet").kendoSpreadsheet({
sheets: sheets,
toolbar: {
home: [
{
type: "button",
text: "Full Screen",
showText: "overflow",
icon: "k-icon k-i-full-screen",
click: function () {
if (document.fullscreenElement) {
document.exitFullscreen();
} else {
$('#spreadsheet').get(0).requestFullscreen();
}
}
}
]
}
});
Hi,
Kendo version 2023.3.1010 installed via nuget package manager downloads corrupt excel spreadsheet files on export.
The workaround for it was to manually download jszip.min.js from the following cdn: https://kendo.cdn.telerik.com/2023.3.1010/js/jszip.min.js
and to replace the one in the nuget installed package.
Please verify your jszip that you're shipping with nuget package manager,
Thanks
Hello,
I'm making an application that uses SpreadSheet. I've added kendo.spreadsheet.min.js to the list of scripts, but I get an error in the console that says "Uncaught TypeError: B is undefined".
I would like to know which scirpts are mandatory to run SpreadSheet.
Thanks
Is there a spreadsheet for Angular, if not, what to use with Angular?
I had feedbacks that Spreadsheet for JQuery in Angular does not behave wery well, poor performances. Is there a way to use the Spreadsheet properly with Angular?
Hello,
I need to disable the button that selects the entire sheet in SpreadSheet. I tried to hide it with CSS but the button remains active.
I have highlighted in yellow the button I am talking about in the screenshot below.
Thanks.
I'm trying to paint the spreadsheet with data of 3500 rows * 250 columns and I'm having few loops to prepare the data before the below code and trying to set it all at once. The below code took ~ 2 min
Is there any way improve this ?
I'm having an issue in some areas of my application where some spreadsheet functionality is not working. It works as expected elsewhere in the app.
The issue is that some mouse actions are not working:
No errors are shown and the spreadsheet works otherwise so I have thus far been unable to debug it.
Do you have any ideas as to things that could cause this to happen, and/or how to debug this issue?