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.

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

Hello,

We are using Spreadsheet widget in our system and have following questions to meet the demands of our customers:

1. How can the filters be limited to valid choices by type of column? For example a numeric column does not need Filter By Condition options by date or by text containing values.
2. On initial drop down of the filter the Filter by Value section opens, since most of our columns are numeric that isn't useful. How could we collapse the filter by value option on initial opening of the filter?

Currently we use spreadsheet filtering configuration according to this example:

            $("#spreadsheet").kendoSpreadsheet({
                sheets: [
                {
                    name: "OrdersLog",
                    mergedCells: [
                        "A1:G1",
                        "A2:F2"
                    ],
                    filter: {
                        ref: "A3:G49",
                        columns:[]
                    },

Can you please provide us with working examples of configuration (or required code adjustments) that will help us to meet the requrements above?

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.

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.

Spreadsheet import currently handles (keeps) rich text formatting of a cell if the entire cell is formatted, such as a colored row or all bold text in cell. However, if the content of the cell is a mix of plain text and formatted text, the formatting gets dropped on import. If it is possible, it would be nice to keep rich text under this condition.

Currently if you access cells range programmatically, you can set background color, text color etc.
It would be good to have the way to set classes or to get the DOM of the range.
Another option would be to get DOM or set a class to individual cells (e.g. via range.forEachCell).

It would be nice to have text orientation support (at least vertical) like in MS Office.

I have altered the kendo code to add row and column references to the k-spreadsheet-cell dom objects. A sample of this is: 
<div style="color: rgb(81, . . .  class="k-spreadsheet-cell r17c1 row-17 col-1"> . . . .
I have items that I wish to place on top of cells in the spreadsheet.
I can use these classes to identify the dom element corresponding to a spreadsheet cell object. I wish that this thing would let me post images. This is working really well. 
Request: It would be nice if the spreadsheet code to do this out of the box. Further, it would be beneficial to add a 'tag' property to a spreadsheet cell that would be indicated in the cell's dom object. If a cell has a tag, it should be rendered even if it doesn't have non-trivial formatting or a value.

I use data binding data source for spreadsheet
But when I use it, data auto input begins at row 0
I want to insert 2 row (To Write title)

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

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…