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…
Custom editors are great! But often when you have a custom editor, you want to restrict data entry to only use that editor, and not free-form typing in the cell. You can prevent free-form typing in the cell by disabling the cell, but then the custom editor button is no longer available. Suggestion is to still show custom editor button even if cell is disabled, perhaps with an additional setting; so that you could optionally not show the custom editor if the cell is disabled, since often a disabled cell should prevent any kind of modification.
2. Open attached MultipleSheetsRowHeightIssue.xlsx
3. Please notice there are 3 sheets with default row height 20, 30, 40 respectively (you can check in MS Excel)
4. Now Click export, and open the exported file again
5. Now we have an issue here - all sheets set to default row height to 40. (It seems that it is setting the last sheet's default row height to all sheets)
Its severe issue, please share a fix or at least provide some workaround.
When using the bottom right corner of a cell to batch copy values across a range by dragging the corner, an error popup appears if a disabled cell is found inside the range that was dragged into. It is possible to reproduce this with this demo: https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells 1. Set the quantity column to disabled. 2. Select B3. 3. Drag the bottom right corner of B3 to D3. 4. See error: "Destination range contains disabled cells." There should be an option to allow that to copy into any enabled cells in that range and ignore the disabled ones.
Additional functionality for: -- Conditional Formatting -- coloring of cells, for example based upon a value and then be able to import from excel, and export back out. -- Data Validation (dropdowns). Also be able to import and export back out.
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.
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
add a double line border single or multiple cell.
Allow additional control over what a user can undo/redo, or a clearer way to control the undo/redo stack. Right now, users cannot undo more complex custom logic - i.e. a user deletes the content of a single cell which triggers code for us to clear the content of every cell in that row. When a user then attempts a single undo via keyboard shortcut, it cannot undo this more complex chain of events.
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.