Dear Concerned,

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

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.

 

Make Spreadsheet xlsx import failure more user friendly. Currently, when xlsx import fails, the UI thread is blocked and the user needs to reload the page in the browser. The import operation instead could process the file in the background and could return meaningful message without blocking the UI.

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.

add indent property to spreadsheet cells to closer match excel

Show/Hide Column & Row Header

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.

In Kendo UI spreadsheet when wrap cell text it currently split text in middle of word. Change so that splits on white space

Ability to dynamically bound the DropDown editor to an array of objects 

like this: http://docs.handsontable.com/0.18.0/demo-grouping-and-ungrouping.html

Can we have a facility to copy a cell and paste it to a selection. (i.e paste to multiple cells)

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.

Be able to edit an spreadsheet by several users at the same time, reflecting the changes from one user to the others and viceversa.

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.

We'd need support for checkboxes columns in the new Spreadsheet control.

Define by Settings or via API Calls custom context Menu for any Cell,
like change current by Event BeforeContextMenu(ref ContextMenuElement)