It would be great if there is a cell (and column) type that lets you choose from a defined list (manually defined list or based on a cell-range). It should be possible to make multple selections and the output should be put into the cell separated with semi-colons.
When pasting content to a Spreadsheet that has only one column(columns: 1), the data is not pasted in the targeted cell and a JS error appears in the browser's console.
The issue appears only in scenarios where the columns configuration is set to 1.
No data is pasted in the selected cell and the below error appears in the console:
The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.
Has anyone at Kendo ever thought of putting an OnBlur event on a Spreadsheet Cell. The purpose of the event (at least in my case) would be to cancel navigation to another cell. The Change and Changing events are close, but from what I can tell there is no way to cancel the navigation when either of these events fire. If you navigate to another cell and the data has changed, the Changing event fires before the Select event, but there is no way to stop the select event from firing once the Changing even is complete. I tried using Select from with the Changing event to set navigate back to the same cell, but there is currently an open bug in respect to that, as it does not navigate properly.
To hopefully state it more clearly, It would be nice if the Spreadsheet cell had an OnBlur Event that allows you to cancel navigation and remain in the same cell. Ideally it would word for all forms of navigation. Mouse Click on new cell or Scroll with Arrows.
Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource
And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve
The first added cell value (or row) is removed when the user deletes an empty row.
If the ID is entered, the result is even stranger:
https://www.screencast.com/t/osmVOiY7al
It should behave and function like Excel. I think with local/static binding there are no issues.
The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.
Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.
If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.
When cells of the Spreadsheet that contain data are merged data loss occurs.
To prevent inappropriate merges we need to be able to handle an Merge/Unmerge event of the Component that should be preventable.
Thank you.
Hi Team,
I'd like to request the functionality to allow cell configurations to be populated by database values by default. For example, I'd like to have a value from the database populate the specific link configuration.
Thank you!
When the select() method is used in the Spreadsheet changing event wrong cell is selected.
Changing event is fired, but the 'B3' cell is selected instead of the 'B2'
The correct cell should be selected when using the select method inside the Spreadsheet event handlers.
Hello,
We are using Spreadsheet widget in our system and have following questions to meet the demands of our customers:
Currently we use spreadsheet filtering configuration according to this example:
$("#spreadsheet").kendoSpreadsheet({ sheets: [ { name: "OrdersLog", mergedCells: [ "A1:G1", "A2:F2" ], filter: { ref: "A3:G49", columns:[] },
Can you please provide us with working examples of configuration (or required code adjustments) that will help us to meet the requrements above?
The sheets bar should be configurable with some configuration options to control the ability to..
1. Add sheets
2. Remove sheets
3. Rename sheets
4. Reorder sheets
1. The top tab section (with the Home, Insert, Data, Undo, Redo) button of the toolbar should be configurable to be hidden, i.e. "single toolbar" configuration should be supported. Since it is possible to configure the toolbar to show custom items, it should also be possible to hide other tabs and the undo/redo button and only have a single toolbar as the configuration.
/* Style hack to hide the "Home/Insert/Data" tabstrip at the top of the spreadsheet. */
.k-spreadsheet-tabstrip.k-tabstrip {
& > ul {
display: none;
}
& .k-content {
border-top: 0px;
}
}
/**
* Style hack to hide the undo/redo buttons in the quick-access toolbar.
*/
.k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
display: none;
}
Hello there,
I am developing a Web application using Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.
For example:
I have the following numbers on a Excel sheet:
1 | 0.5 | 0.333333333 | 0.25 | 0.2 | 0.166667 | 0.142857 | 0.125 | 0.111111 | 0.1 | 0.090909 | 0.083333 | 0.076923 | 0.071429 | 0.066667 | 0.0625 | 0.058824 | 0.055556 | 0.052632 |
Then, I copy them to the Kendo spreadsheet and I got the following:
100.00% | 50.00% | 33.33% | 25.00% | 20.00% | 16.67% | 14.29% | 12.50% | 11.11% | 10.00% | 9.09% | 8.33% | 7.69% | 7.14% | 6.67% | 6.25% | 5.88% | 5.56% | 5.26% |
But when I copy them back to Excel I got this:
1 | 0.5 | 0.3333 | 0.25 | 0.2 | 0.1667 | 0.1429 | 0.125 | 0.1111 | 0.1 | 0.0909 | 0.0833 | 0.0769 | 0.0714 | 0.0667 | 0.0625 | 0.0588 | 0.0556 | 0.0526 |
Losing many decimals affecting the results of my computation and calculation.
Can you tell me why is this happening?
Thank you some much.
When we use custom validation for a cell using below method kendo.spreadsheet.defineFunction("CUSTOM_VALIDATION", function(num){}); its triggered for each cell. Let say i have applied this validation method for 100 cells. If i changed any one cell then this method got invoked 100 times. Instead it should execute single time i.e, for that changed cell only. We cant keep 100 different methods for 100 cells. This will impact more on performance. Please look it on this and fix accordingly. This feature will be helpful for complex usage.
Hello
We are trying to use the Kendo Jquery spreadsheet but are running across some issues in terms of setting up for printing and/or exporting to PDF.
Currently, we let the user modify the spreadsheet to suit their needs. The problem is there is no way to see page breaks at this time...that we know of. The users stretch columns and row to suit their needs but the only way to see if they 'broke' across a page is to export to pdf to see...
We would like one or two options...
1. We know what our page size is - 8 1/2 x 11. Is there a way to fix the max size of the spreadsheet so it's 1 page wide? If the user inserts columns then the other columns just get smaller and smaller - proportionally - but ultimately the sheet is as only as wide as 1 page...
2. The ability to see where the page breaks are so they can set up the sheet correctly.
Please let me know if one of these options is feasible or are we stuck?
Thank you
Jeffrey Suffet
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.
It would be great to be able to put buttons inside a cell or merged cell for atomic functionality. Actually I would really need it for a project we are working on at our company.
Hi Progress - just some quick feedback: 1. Telerik Control Panel updates - it feels like a lot of the time, when the TCP needs updating the user has to manually uninstall the old version and the install the new one using the .exe installer. If the TCP could automatically handle this process, that would be appreciated. 2. The various Telerik Spread Processing libraries (and other document processing libraries) can only be installed as an included component of the Telerik "UI for X" library installations. It would be great if there was an option in the TCP to do a standalone installation of just the Spread Processing libraries. Thanks and kind regards, - Lawrence
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: