Unplanned
Last Updated: 09 Oct 2019 15:13 by ADMIN
Consider implementing functionality for importing and working with encrypted / password protected Excel files in the SpreadSheet component
Unplanned
Last Updated: 22 Aug 2019 10:51 by ADMIN
Created by: G.K. Raju
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
Currently there is no suitable event to detect cell styling changes. Such event could be implemented similar to the formatChange event but for the styling changes.
Unplanned
Last Updated: 06 Nov 2020 07:56 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: 05 May 2020 18:04 by ADMIN
Created by: Ohenewa
Comments: 0
Category: Spreadsheet
Type: Feature Request
3

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: 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: 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.

 

Completed
Last Updated: 17 Aug 2021 06:37 by ADMIN

Bug report

Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:

let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();

If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).

let dataURL = new kendo.ooxml.Workbook(data).toDataURL();

Reproduction of the problem

Dojo example.

  1. Click the "To Json" button above the Spreadsheet.
  2. Try to open the generated file in Excel.

Current behavior

The generated Excel file is corrupted

Expected/desired behavior

The generated Excel file is not corrupted

Environment

  • Kendo UI version: 2020.2.617
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 27 Oct 2020 14:04 by ADMIN
Created by: G.K. Raju
Comments: 0
Category: Spreadsheet
Type: Feature Request
3

Hi Team,

I'd like to request a way to manipulate a large amount of cell groups in the Kendo UI Spreadsheet without decreasing performance.  For example, I'd like to be able to merge/unmerge and change font size to multiple specific cell groups.  I understand changing multiple DOM elements at the same time can cause sluggishness, but maybe there's a way to reduce the time. Currently, it's taking a long time to completely load.  

Thank you for investigating.

Completed
Last Updated: 18 Jan 2021 09:09 by ADMIN
Release 2021.R1
Created by: Softwarehouse
Comments: 0
Category: Spreadsheet
Type: Bug Report
3

Bug report

Values that are copied from Spreadsheet are duplicated when pasted in Excel if before that the copied cells have been cut and pasted inside the Spreadsheet.

Reproduction of the problem

  1. Open this Dojo project
  2. Cut B3:C3
  3. Paste the copied content to A1:B1
  4. Copy A1:B2
  5. Paste to Excel

Current behavior

In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied

Expected/desired behavior

The pasted in Excel content should contain 2 rows instead of 3

Environment

  • Kendo UI version: 2020.3.1021
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 19 Mar 2021 19:49 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
3

Hi Team,

I would like to request the Kendo UI Spreadsheet to be able to validate by Text Length instead of using custom validation.  This would help with importing xlsx files which have text length validation.

Thank you!

Unplanned
Last Updated: 05 Apr 2021 09:17 by ADMIN
Created by: Janaki
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

Hi ,

we have a requirement to disable comment option on click of few cells (which are disabled) or to show a toastr message on click of comment that user can't add comment on specific cell. Do you have any such feature or event to track this requirement .

Completed
Last Updated: 02 Dec 2021 13:38 by ADMIN
Release 2021.R3.SP.next

In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell.  Next I name the single cell D5, and call it MyAnswer.  I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.

Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.

Can you please advise when this issue will be fixed in Telerik.

I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".

Thank you so much.

Declined
Last Updated: 26 Oct 2022 08:17 by ADMIN
Created by: Cheng Mun
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

Hi Support Team,

When select multiple cells continuously and right click, it will have more options. But when select multiple cells without continuously and right click, there is only 1 option

Would like to have a feature to have more options when select multiple cells without continuously and right click and also to able to detect which cells are selected if multiple cells are selected without continuously.

Select multiple cells continuously:                                   Select multiple cells without continuously:

      

Unplanned
Last Updated: 28 Feb 2023 13:34 by Chanaka
Created by: Chanaka
Comments: 0
Category: Spreadsheet
Type: Feature Request
3

Hi Team,

I would like to request the Kendo UI Spreadsheet to have CSP support.

Thank you for the consideration!

Completed
Last Updated: 04 Nov 2024 15:24 by ADMIN
Created by: John
Comments: 2
Category: Spreadsheet
Type: Bug Report
3

[Edited]

Bug report

After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.

Reproduction of the problem

  1. Open the Kendo UI Spreadsheet Overview
  2. Copy Data C7:D8 from Kendo Spreadsheet
  3. Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
  4. Edit values in MS Excel.
  5. Copy from MS Excel
  6. Paste new values to a Kendo UI Spreadsheet.

Expected/desired behavior

The new values are not pasted back to the Kendo UI Spreadsheet.

Environment

  • Kendo UI version: 2023.3.1114
  • jQuery version: All Supported Versions
  • Browser: all
Unplanned
Last Updated: 12 Sep 2023 13:53 by Pravin
Created by: Pravin
Comments: 0
Category: Spreadsheet
Type: Feature Request
3

Hi Team,

I would like to request a way to include commas for the sheets.rows.cells.validation.from values.

For example:

  • 1st
  • 2nd
  • Combine 1st, and 2nd

Instead of:

  • 1st
  • 2nd
  • Combine 1st
  • and 2nd

Additionally, it would be nice to be able to use another delimiter instead of commas. 

Thank you!

  
Unplanned
Last Updated: 27 Aug 2024 20:21 by Shivam
Created by: Shivam
Comments: 0
Category: Spreadsheet
Type: Bug Report
3

Bug report

When trying to import an Excel document into the Kendo UI Spreadsheet with a missing/corrupt image reference, the file will not show.

Reproduction of the problem

  1. Import an XLSX file with a corrupted image into the Kendo UI Spreadsheet demo. (See ticket 1661911 for an example document)

Current behavior

The Kendo UI Spreadsheet fails to load the document.

Expected/desired behavior

The Kendo UI Spreadsheet should handle the error and load the Spreadsheet data without the image.

Environment

Unplanned
Last Updated: 26 Feb 2020 14:30 by ADMIN
Created by: Otto Neff
Comments: 3
Category: Spreadsheet
Type: Feature Request
2
Declined
Last Updated: 05 Oct 2016 12:13 by ADMIN
Created by: Jeremiah
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
The Spreadsheet widget is a good start, here are some additional ideas:

1) Ability to assign specific data columns to a spreadsheet column in DataSource data binding and format them.
	2) Control tools that can be visible in the toolbar as well as add custom toolbar items/tabs
	3) Enabled/Disable or Show/Hide tabs in tool bar. Alternatively, be able to add custom tabs and toolbar items as well.
	4) Events! need more events. Cell selected, Range selected, column selected, etc...
	5) Disable/Enable certain commands (such as Cut, Copy, Paste, Delete) based on #4 or other criteria. Useful if I do not want specific cell or column data copied or deleted.
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.