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.
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.
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
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
Please support Excel formulas copy and paste to Kendo Spreadsheet. Now is the copy only the text, not formulas.
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.
add a double line border single or multiple cell.
Currently only the global culture is used to parse dates. This behavior differs from Excel as I can enter 1/1/19 to parse to 1/1/2019. I would like the widget to format using the chosen date culture (mm/dd/yyyy), but parse in an optional way, such as mm/dd/yy.
In percent-formatted cells, Excel will place a '%' as the user types. This allows 50% to be entered as '50'. Steps (excel and kendo): 1. Format a cell as percent 2. Enter 50 Excel shows "50.00%". The actual value is .5 Kendo widget shows "5000.00%". The actual value is 50