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: 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: 08 Oct 2018 18:23 by Prasadh
Created by: Prasadh
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
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
Pending Review
Last Updated: 22 Jun 2018 07:39 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
It would be nice to have text orientation support (at least vertical) like in MS Office.
Pending Review
Last Updated: 18 Jul 2018 13:33 by ADMIN
Created by: auto
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
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)
Pending Review
Last Updated: 05 Jul 2017 01:02 by Sergio
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
It should be possible to define cell types (or types that are valid for the entire column) like:
- Booleans (which will result in showing check boxes inside the cells)
Pending Review
Last Updated: 11 May 2016 11:42 by ADMIN
Pending Review
Last Updated: 06 Aug 2017 10:54 by ADMIN
Created by: JackP
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
I know it seems like a small thing, but I work with complex spreadsheets, and supporting coloured sheet tabs would really help 
Love this control.
Pending Review
Last Updated: 11 May 2016 13:38 by ADMIN
Created by: Ganesan
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Add a watermark in each worksheet.
Pending Review
Last Updated: 07 Jun 2017 17:27 by ADMIN
Created by: David
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.
Pending Review
Last Updated: 12 May 2016 07:31 by ADMIN
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.
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: 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: 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: 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: 05 Oct 2016 17:12 by Robert
Created by: Robert
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Add menu item that allows end users to style background and text color based on rules (if cell value > 0 then green)
Pending Review
Last Updated: 11 May 2016 13:24 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
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.
Pending Review
Last Updated: 07 Aug 2017 09:59 by ADMIN
Created by: Otto Neff
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Pending Review
Last Updated: 14 Feb 2018 05:34 by ADMIN
Pending Review
Last Updated: 11 May 2016 11:43 by ADMIN
Created by: Otto Neff
Comments: 0
Category: Spreadsheet
Type: Feature Request
1