DefaultCellStyle property in spreadsheet has a field “Wrap”, but doesn’t have a field “Format”. For example, if I need to process all cells as text, I must set the field “Format” on a client side: sheet.range("A1:AX200").wrap(true).format("@"); It works. But the initialization of the range ("A1:AX200") takes time… It is not very fast… It would be better to have the field “Format” in the DefaultCellStyle property in spreadsheet…
IF any custom validation available for spreadsheet cells, then while exporting the sheet, those validation error messages or formats not getting exported. So here it will be helpful if its exports validations too. So user can see error in both UI and Exported file. In the below example, user can see the error messages in ui but cant see on the exported file. https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/validation-to-column
It should be possible to define cell types (or types that are valid for the entire column) like: - Booleans (which will result in showing check boxes inside the cells)
Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.
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.
I am working on a project where i am using KendoUI components. I have to show a financial sheet. All formulas are working fine like SUM,INDIRECT etc. but IRR not working as expected. Tested IRR formula outside my project and the same happened.
I need the way to get a user the opportunity to set the columns headers. Moreover, the columns headers should be saved separately from the main spreadsheet data. Of course, the possible variant is to have two spreadsheets: the one – for the data, the second (with one row) – for the headers. But the better way is to get a user the opportunity to set the spreadsheet columns headers. It would be ideally if a user could change “A”, “B”, “C” for “ID”, “Product”, “Quantity” … Not to have a first row for headers, but change the spreadsheet columns headers! Moreover, we have the context menu on the columns headers and it is possible to add one more item “Edit” in it.
It would be useful if copy and paste the data have the option of fill the series or copy the value for the date format. Furthermore, copy from multiple column value and allow to paste multiple copied value from the spreadsheet will be added advantage. Thanks.
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.