Pending Review
Last Updated: 06 Aug 2017 10:54 by ADMIN
Created by: Jeffrey
Comments: 0
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.
Pending Review
Last Updated: 11 Aug 2017 13:44 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.
Pending Review
Last Updated: 11 Aug 2017 13:47 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.
Pending Review
Last Updated: 31 Jul 2017 21:54 by ADMIN
Created by: Doug
Comments: 0
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.
Pending Review
Last Updated: 19 Jun 2017 17:12 by Christopher
Created by: Christopher
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
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.
Pending Review
Last Updated: 09 Jun 2017 03:21 by Ashvinkumar
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.
Pending Review
Last Updated: 03 Aug 2018 13:32 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)
Pending Review
Last Updated: 08 Jun 2018 10:41 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.
Pending Review
Last Updated: 26 Oct 2017 03:03 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
Pending Review
Last Updated: 13 Apr 2017 15:45 by Taras
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).
Pending Review
Last Updated: 04 Apr 2017 13:38 by Vinay Kiran S
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
Pending Review
Last Updated: 16 Feb 2017 15:38 by Nikos
Created by: Nikos
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Pending Review
Last Updated: 27 Feb 2019 15:26 by Michael
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
Pending Review
Last Updated: 31 Oct 2017 16:58 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…
Pending Review
Last Updated: 23 Jan 2017 13:59 by Victor
Created by: Victor
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
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.
Pending Review
Last Updated: 06 Jan 2017 06:28 by SHIVANG
Created by: SHIVANG
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
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.
Pending Review
Last Updated: 07 Aug 2017 09:59 by ADMIN
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
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.
Pending Review
Last Updated: 02 Dec 2016 02:53 by Su Pei
Created by: Su Pei
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
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. 
Pending Review
Last Updated: 09 Nov 2016 16:06 by ADMIN
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.
Pending Review
Last Updated: 06 Aug 2017 10:54 by ADMIN
Created by: iTai
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
In the scpreadsheet you can use controls like  dropdowns & datepicker , but should be helpful if user could to customize the design and behavior. 

For example, the dropdown and any other control needs be opened since an icon at right that is displayed over the next column, As user i would like to choose how i want to be displayed the control: Open clicking on it, set expand direction, styles, etc.