Need a default cell format, in addition to rowHeight and columnWidth including: - font size, - font-family, - font weight - (see other toolbar options) Default cell format would set the default values for all cells and toolbar options.
Enable Cut/Copy cell values and can Paste it in mutiple selected values
On excel, you can filter merged rows. On the kendo spreadsheet widget, filtering on merged rows is not possible. It would be a very useful feature for us. Also worth noting is that if you convert an excel file to JSON using Telerik RadSpreadProcessing, and load the kendo widget with the JSON, the widget displays a filter icon but clicking it loads a non-functioning filter. Wouldn't it make more sense to load with a message along the lines of 'You loaded a spreadsheet with filters applied to merged rows, which is not supported in this widget'. Otherwise it's quite confusing to our users.
E.g. italian culture uses ";" as parameter separator in formulae. Our client will adopt spreadsheet component on a global basis and users need to be able to e.g. copy/paste from excel to spreadsheet component using their culture
Currently if I set column border width large, it has multiple problems: 1. it will overlay on columns next to it; 2. when copy the cell with thick border and paste somewhere else, the thick border get copied as well; 3. when select cell with thick border, the border will block part of editor;
Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.
Use case: My app doesn't know how many rows of data the excel spreadsheet will be prior to upload. I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others. The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition. As a workaround, I'm destroying and reloading the widget instance after the initial load.
This will help doing data entry in column for scenarios like entering tax details for different years in columns and also user can keep on entering new year info in rew-row right most column.
1. Save Excel workbook to folder on server (the Excel file can be re-purposed in many ways) 2. Better ways to send sheet data back to controller ... more JSON serialization options, csv, etc.
We'd need support for checkboxes columns in the new Spreadsheet control.
I would like to be able to do conditional formatting against other columns and not just the existing conditional formatting. For example: Column 1 = 1.2 Column 2 = 1.5 If the value of Column 2 is greater than the value of Column 1, I want the color to be green. If the value of Column 2 is less than the value of Column 1, I want the color to be red. If the value of Column 2 is equal to the value of Column 1, I want the color to be black.