We are using the Kendo UI spreadsheet in a real-world website. We have a design team who are providing a visual design which fits in with our company's corporate standards.

HTML5 aims at separating styling from the layout design, which enables different teams to build the syle, with very little development experience, but more artistic experience.

For some reason, the Spreadsheet control can only be styled via the API (javascript code)! This means our design team needs to write their style in javascript, which is completely unrealistic.

It should be a fairly simple change to allow a range object to have a CSS class associated, and let HTML work like it should.

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. 

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.

Add ability to add group multiple columns and add a group header for those columns.

Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown

1. Formula selection dragging

2. Formula selection resize

Details: While using cell references in formulas in a cell, user should be able to drag and resize the referenced cell selection.

Refer the video present here for details.
<https://drive.google.com/file/d/0B2aXCYXjjcD9RDZpd0lScEV3UUk/view?usp=sharing>

The spreadsheet doesn't provide any configuration options for the font size unit; it is always in pixels. I need to be able to specify other CSS units, such as points or ems.

WorksheetPageSetup would be a dialog in the kendo ui spreadsheet and persist when the work book is downloaded as Excel or pdf. 
The setup values would also be used to prepopulate the settings in the download dialog.

WorksheetPageSetup would be maintained when a server-side generated Telerik.Windows.Documents.Spreadsheet.Model.Workbook is converted to a Telerik.Web.Spreadsheet.Workbook by method FromDocument().

Page setup maintains settings for printing: orientation, scaling, margins, paper size, grid lines, column headings etc...

The spreadsheet widget should be able to take an imported .xlsx file, such as a preconstructed template, and update bound database tables if the fields match.

total row count should display on footer like in excel , row count should change after each filter , also option for to add "action link" to the columns so that we can navigate/popup to other pages..

type =IF( "a"="A" ; 1 ; 0 ) and =IF( EXACT("a";"A") ; 1 ; 0 )
into Kendo Spreadsheet and Google Spreadsheet and MS Excel.
There is a special EXACT function (which is also available in Kendo) to enforce case-sensitivity. By default it should be off.

It would be great to be able to put buttons inside a cell or merged cell for atomic functionality. 
Actually I would really need it for a project we are working on at our company.

When we use custom validation for a cell using below method
kendo.spreadsheet.defineFunction("CUSTOM_VALIDATION", function(num){});
its triggered for each cell. Let say i have applied this validation method for 100 cells. If i changed any one cell then this method got invoked 100 times. Instead it should execute single time i.e, for that changed cell only. We cant keep 100 different methods for 100 cells. This will impact more on performance. Please look it on this and fix accordingly. 
This feature will be helpful for complex usage.

Please see Demo https://dojo.telerik.com/UNOPUvaB/2

In first data row (Row 3) I create a range of numeric values from a , middle and maximum value.
Validation works perfectly, e.g. when manipulating the Middle value, I cannot go below minimum cell value and not above maximum cell value, until adjusted.

I want to accomplish the same with dates in second data row (Row 4 when I reference another "C4", it looks like validation works as expected, but the Date Picker is broken.

Hi,

 

I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).

When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.

Editing an empty row above this new row will modify one of the records created in this process.

The sheets bar should be configurable with some configuration options to control the ability to..

1. Add sheets

2. Remove sheets

3. Rename sheets

4. Reorder sheets