Unplanned
Last Updated: 29 Sep 2020 10:08 by ADMIN
Created by: Shadi
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Since the Spreadsheet does not support macros, implement error handling in the widget that notifies the user if they attempt to load a file that contains a macro. For more details see: Ticket ID: 1486172
Unplanned
Last Updated: 24 Aug 2020 11:40 by ADMIN

Working with numbers like 0.000001056  in a Spreadsheet that is bound to a dataSource, after saving the dataSource, the mentioned number will be converted to an exponential format. 

The current feature request is about preventing the format changing after saving decimal numbers.

It will be very useful if we can use the Spreadsheet with dataSource binding but keep the decimal numbers as such, not converting them to exponential expressions.

 

Unplanned
Last Updated: 18 Aug 2020 06:27 by ADMIN
Created by: Owen
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

In the Spreadsheet control for jQuery it is possible to set cells as read-only through the use of the Enable property.

However, on calling saveAsExcel() these cells are editable. This means as a developer it is then necessary to create both the spreadsheet JSON (for Kendo Spreadsheet) as well as another spreadsheet class to export to Excel.

Could you please map the Cell.Enable property to the setting of Excel cells as disabled/read-only. Thanks 👍

Unplanned
Last Updated: 21 Jul 2020 07:16 by ADMIN
Created by: Dhruven
Comments: 1
Category: Spreadsheet
Type: Feature Request
4

When I use this formula 

=HYPERLINK("mailto:"&B4&"?subject=“& B5 & “&body=“ & B6,", "test")

in the excel, I am able to click on the link which opens up my mail client with compose new email window and also populates To, Subject and Body of the email from cells B4, B5, B6 respectively.

But currently, HYPERLINK formula does not support "mailto:" functionality in Kendo UI spreadsheet. I would love to see this with kendo UI spreadsheet. 

For more details you can see the discussion on the forums here

Unplanned
Last Updated: 08 Jul 2020 07:55 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be useful to have a method capable of executing a formula without assigning it to a cell in the Spreadsheet.
Unplanned
Last Updated: 17 Jun 2020 09:41 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

Need:

Extract only the values for all Spreadsheet cells. These extracted values can be sent back to server (with minimum size) as server only needs data on each sheet. On other information required like references, formulas, images, colors etc.

 

Possible Approach:

On click of save or a separate button, which will generate a low size data file (having sheet name, cell index and value), which we can send to server.

 

It will save network traffic and also no complex parsing needed at server side to fetch data.

 

Unplanned
Last Updated: 10 Jun 2020 12:55 by ADMIN
Created by: Naveen
Comments: 2
Category: Spreadsheet
Type: Feature Request
2

Dear Concerned,

1. open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. select row header of row 10, go to Insert tab

3. click insert row below, it inserts row successfully after row 10, it adjust formulas of row 12, and other rows there after which is good.

4. But issue is - it neither keep format of row 10 in new row & nor it add formulas to various columns in new row(e.g. F11, E11)

Please suggest how can we achieve it, it is very common and useful feature which excel have. if you do not have any ready solution then please suggest workaround for the same as it is urgent for my client.

Unplanned
Last Updated: 02 Jun 2020 07:34 by ADMIN
Created by: kaan
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hi,

I want to highlight spreadsheet on cell hover. But I just want to highlight row and column until cell. Is there any way to do this ? 

In example, When my mouse on cell E11.

Best Regards,

Kaan

Unplanned
Last Updated: 28 May 2020 12:32 by ADMIN

In Excel it is possible to select several rows and increase/decrease all selected rows height. In the Spreadsheet this works only for the last selected row. The following steps demonstrate the behavior:

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Click on the header of row 6, hold and drag until rows 6, 7, 8, 9 , 10 are selected.

3. Click the handle below row 10's header and drag to increase the height of the rows. The Spreadsheet increases only the last row's height.

Unplanned
Last Updated: 05 May 2020 18:04 by ADMIN
Created by: Ohenewa
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Currently, the sheets in the Spreadsheet component can be reordered. It will be a very useful feature if we can configure the component in a way this reordering can be disabled.

Thus the users won't be able to move the sheets' tabs.

Unplanned
Last Updated: 05 May 2020 16:07 by ADMIN

Currently, when the "Custom format" button in the Spreadsheet is clicked, the available predefined formats that can be applied to a cell appear as demonstrated in the below screenshot. These predefined options don't change if you set a specific Kendo UI culture. 

It will be a very useful feature to be able to change the predefined custom formats. Also, it will be nice if the custom formats in the Spreadsheet can be set based on the selected Kendo UI culture. 

Unplanned
Last Updated: 25 Mar 2020 18:01 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Add support for multiple ranges for the Spreadsheet's SUM function, for example: 

=SUM(E5:E6:E9:E10)

Unplanned
Last Updated: 17 Mar 2020 08:05 by ADMIN
Created by: Massimo
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

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

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. 

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: 26 Feb 2020 15:06 by ADMIN
Created by: kaan
Comments: 3
Category: Spreadsheet
Type: Feature Request
0

Hello,

Is is possible to trigger validation in cells in spreadsheet control? I want to make all validation controls with a button click outside the spreadsheet control.

Unplanned
Last Updated: 10 Dec 2019 08:54 by ADMIN

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Put some text in B2 so that it does not fit in the cell width.

3. Press Wrap Text button 

4. Press Wrap Text again

5.  The row height is not adjusted back to the original height (Excel does it)

Unplanned
Last Updated: 09 Dec 2019 13:50 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Dear Concerned,

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Import attached Book1.xlsx. Observe Cell F4 of Sheet1 has a font size of 72.

3. Change it to 8, row height does not change automatically

4. It should be same as Excel behavior


Please provide a fix or any workaround in the meanwhile.
Unplanned
Last Updated: 13 Dec 2019 15:32 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
8

https://demos.telerik.com/kendo-ui/spreadsheet/index

1. Enter some text in a cell.

2. Increase the cell font size to 48.

3. Reduce the cell font size to 8.

4. Double click the row resize handler: the row height is not adjusted to correspond to font size 8.

The same behavior can be observed when opening an existing .xlsx file that has some text and font size set and following steps 3-4.

Unplanned
Last Updated: 26 Nov 2019 12:29 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Dear Concerned,

It would be very useful if Kendo can provide two more functions like fromJSON & toJSON in a Spreadsheet as mentioned below

fromStream() - to load an excel file form an Excel stream string so that the developer does not need to convert it to blob etc.

toStream() - to return excel stream string, it would good if it is possible to get stream without blocking UI operation. As of now, we first call toJSON & then call kendo.ooxml.Workbook(jsonSpreadsheetData).toDataURL(); to get excel stream and it is time consuming operation.

Use case: keeping excel file/stream on the server and fetching it using API on UI and then using fromStream to load & render it. And toStream is the same as toJSON to save modified stream back to the server since stream size is very low as compared to json.

Please see if it is feasible to provide these features.
1 2 3 4 5