Ability to hide a sheet in kendo spreadsheet
I want to know the combination keys that generate the paste event Thx,
In my testing of utilizing the spreadsheet component and starting off with for example 100 rows in the configuration options, using insert row typically seems to shift the data down (if you have anything below the cursor). It does not actually increase the number of rows in the sheet.
For example if I initialize the spreadsheet with the following info:
$("#spreadsheet").kendoSpreadsheet({
rows: 100,
columns: 26
});
This will create the spreadsheet with 100 rows and columns A-Z as expected.
Now going anywhere in the sheet (or the end) and inserting a row above/or below will not add row 101, 102, 103, etc. In fact, if you are in the very last row and hit insert row below it will come up with a message regarding a possible loss of data.
A couple things I have tried:
So with that said, is it at all possible to actually add a row to the sheet as one would expect the behavior to be. This obviously still needs to call the internal functions to recalculate the ranges and data throughout the sheet; but somehow re-fresh or re-render the UI component (just calling render again doesn't fix it).
I appreciate your help with this.
We have: Uncaught Error: The toDataURL method can be used only with jsZip 2. Either include jsZip 2 or use the toDataURLAsync method.
and we have:
so i implement a function SpreadSheetOnexcelExport on excelExport event:
$.SpreadSheetOnexcelExport = function(){
var args = arguments[0];
var options = args.sender.options;
var wb = args.workbook;
var wbX = new kendo.ooxml.Workbook(wb)
var dataURL = wbX.toDataURLAsync();
wbX.toDataURLAsync().then(function(dataURL) {
kendo.saveAs({
dataURI: dataURL,
fileName: options.excel.fileName
});
});
args.preventDefault();
}
The problem is that, for fileName, I have no way to use the file name, selected by the user:
The Spreadsheet widget is a good start, here are some additional ideas: 1) Ability to assign specific data columns to a spreadsheet column in DataSource data binding and format them. 2) Control tools that can be visible in the toolbar as well as add custom toolbar items/tabs 3) Enabled/Disable or Show/Hide tabs in tool bar. Alternatively, be able to add custom tabs and toolbar items as well. 4) Events! need more events. Cell selected, Range selected, column selected, etc... 5) Disable/Enable certain commands (such as Cut, Copy, Paste, Delete) based on #4 or other criteria. Useful if I do not want specific cell or column data copied or deleted.