Declined
Last Updated: 27 Feb 2020 16:05 by ADMIN
Created by: Ganesan
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
Add a watermark in each worksheet.
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.
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.
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: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 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
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…
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
Declined
Last Updated: 26 Feb 2020 15:03 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.
Declined
Last Updated: 27 Feb 2020 16:07 by ADMIN
Created by: David
Comments: 1
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.
Unplanned
Last Updated: 28 Jan 2020 12:14 by ADMIN
Expose API that would allow a check of whether filtering has been applied to a given range/sheet. Especially identify the case when filtering is applied but no items were filtered out.
Unplanned
Last Updated: 06 Feb 2020 09:17 by ADMIN

For the time being the Spreadsheet parser is unable to read files which tags are not in the default namespace. Try to open the attached file in this demo project: https://demos.telerik.com/kendo-ui/spreadsheet/index

You won't be able to load the file. If you open the file in Excel, save the file ("Ctrl+S") and try to load it in the Spreadsheet again, there will be no issues with it. The difference in file's structure before and after being saved in Excel could be seen in the attached screenshot.

The code in red is the structure of the file before saving it and the one in green is after the "save" operation. The difference between the files is that the structure of the one saved in Excel inserts the tags in the default namespace while the original document uses the "x:" namespace. 

It will be very useful if we can load files with defined namespaces in their structure. 

Duplicated
Last Updated: 03 Mar 2020 10:28 by ADMIN
Text formatting examples are bold, underline, italic. if a react wrapped jquery spreadsheet component cell has two words something like 'Hello World' i want only 'world' to be bold which means in the cell it should show as 'Hello World'. Instead of applying these formatting options to cells apply them to the text in the cell. please make this feature applied to the react spreadsheet as well.

API Reference - https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/bold
Unplanned
Last Updated: 17 Mar 2020 08:05 by ADMIN
Created by: Massimo
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

Needs:

Load big excel files stored on the server

Possible implementation:

Load on demand data:

First load the file structure (sheets name, column names and number of rows)

Then load data when sheet is selected or scrolled

Declined
Last Updated: 26 Feb 2020 14:05 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.
Completed
Last Updated: 26 Feb 2020 14:58 by ADMIN
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. 
Completed
Last Updated: 22 Jul 2019 14:14 by ADMIN
Created by: 炯军
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
can add float object container ? eg:charts
Declined
Last Updated: 27 Feb 2020 16:06 by ADMIN
Created by: Robert
Comments: 1
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)
Completed
Last Updated: 26 Feb 2020 14:52 by ADMIN
Created by: Nikos
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
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