Completed
Last Updated: 22 Jul 2019 13:48 by ADMIN
In MS Excel when you type a number you can easily go to other cells by using the arrow keys and type in another number, thus allowing for fast editing of the spreadsheet. This does not work in the spreadsheet component.
this functionality only needs to work when not creating a formula.
Unplanned
Last Updated: 25 Feb 2020 15:02 by ADMIN
Created by: Geoffrey
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
add indent property to spreadsheet cells to closer match excel
Unplanned
Last Updated: 25 Feb 2020 14:04 by ADMIN
Created by: Doron Naveh
Comments: 0
Category: Spreadsheet
Type: Feature Request
12
 add search functionality to the Spreadsheet.
Declined
Last Updated: 25 Feb 2020 14:49 by ADMIN
Created by: Jeffrey
Comments: 1
Category: Spreadsheet
Type: Feature Request
5
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.
Unplanned
Last Updated: 25 Feb 2020 15:10 by ADMIN
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.
Under Review
Last Updated: 26 Feb 2020 13:45 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Allowing custom editors to be inline would be very helpful. In particular, inline editors using other Kendo controls (e.g. masked textbox, numeric textbox) should be possible.
Declined
Last Updated: 25 Feb 2020 15:33 by ADMIN
Created by: Doug
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
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.
Unplanned
Last Updated: 06 Feb 2020 08:32 by ADMIN
Created by: Christopher
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Currently the spreadsheet dynamically creates the FilterMenu for a range, that is, it's not created until someone clicks the filter dropdown, and it's destroyed if they switched tabs.

There is no event that is fired when these things happen, which makes it hard to attach to, and customize, the FilterMenu without setting up some crazy listening code (setTimeout, etc.). 

It would be great if either (or both:
- You could specify a template for the filter menu.
- You could listen for a "FilterMenu Initialized" event and capture the menu there and customize it.
Unplanned
Last Updated: 26 Feb 2020 14:48 by ADMIN
Created by: Ashvinkumar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Add ability to add group multiple columns and add a group header for those columns.
Duplicated
Last Updated: 25 Feb 2020 14:22 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
8
Can we have a facility to copy a cell and paste it to a selection. (i.e paste to multiple cells)
Unplanned
Last Updated: 25 Feb 2020 15:19 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
By default the items in filter are in random order. Can we sort the items in ascending order by default.
Completed
Last Updated: 22 Jul 2019 14:08 by ADMIN
ADMIN
Created by: Marin Bratanov
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.
Under Review
Last Updated: 26 Feb 2020 13:44 by ADMIN
We have clients with large spreadsheets that print out across multiple pages, which can mean losing track of which column refers to what on new pages after a page break, so they want to be able to assign a row of column headers to be printed on new pages above each column to keep track
Declined
Last Updated: 25 Feb 2020 15:56 by ADMIN
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).
Under Review
Last Updated: 26 Feb 2020 14:50 by ADMIN
Presently in Spreadsheet tooltip is not working for filter applied range 
so tooltip should display for each cell in which the range of filter is applied
Completed
Last Updated: 26 Feb 2020 14:52 by ADMIN
Created by: Nikos
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Completed
Last Updated: 22 Jul 2019 13:44 by ADMIN
I know that Kendo Spreadsheet works like most popular Spreadsheets (Excel and Google Spreadsheet) where, if you copy or drag and paste values from cells, you will copy also the styles, validations, etc from that cell to the new one (unless you select "paste values only" in a context menu or ctrl + shift + v). 

It would be awesome if we can set how this works by configuring a property in the Spreadsheet configuration, something like pasteValuesOnly: false/true or even more complex with an object where you can choose if paste values, validations, formulas, styles or whatever. Also you could attach this functionalities to a context menu (as Google Spreadsheet does) and be able to paste everything, values only, format only, formulas or data validation.
Declined
Last Updated: 25 Feb 2020 15:28 by ADMIN
Can the Spreadsheet widget be updated to initialize a sheet that is bound to a datasource when the datasource is an empty object?  

Generally, when a sheet is bound to a datasource, it is for the purpose of editing data, creating new rows and updating/deleting existing rows.  If a datasource comes back empty, the sheet isn't initialized.  So there are no column headers, which can be confusing to users when they don't know what data to enter in which columns.  The other thing is that the sheet itself is not fully initialize so that even if we assign column headers programmatically, when users start entering data, the UI becomes unresponsive and generates a javascript error: Uncaught TypeError: Cannot read property 'indexOf' of undefined
    at r.set (kendo.all.js:4586)
    at r.set (kendo.all.js:4760)
    at kendo.all.js:127702
Planned
Last Updated: 05 Mar 2019 14:55 by ADMIN
Created by: Jose
Comments: 2
Category: Spreadsheet
Type: Feature Request
15
Set an indicator same way that grid already does but now in sheet cells when a record is 'dirty'.
Unplanned
Last Updated: 25 Feb 2020 15:44 by ADMIN
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…