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.

Duplicated
Last Updated: 30 Apr 2020 08:23 by ADMIN
Created by: Emanuele
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
I think it might be very useful to add to cell comments an HTML code and be able to do it programmatically.

Thank you
Completed
Last Updated: 30 Mar 2020 07:11 by ADMIN
Created by: Seuthes
Comments: 2
Category: Spreadsheet
Type: Feature Request
4

It would be great if you would add accessabbility to the spreadsheet as it seems to be the last control without this feature.

Currently the focus gets trapped inside its grid and the user cannot leave the spreadsheet with the TAB key. At least this should be avoided. It would be also better if only the first cell would be focusable and you then could navigate with the arrow keys, as with thousands of cells it is not very comfortable to use the TAB key.

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)

Completed
Last Updated: 24 Mar 2020 17:11 by ADMIN
Release 2020.R1.SP.next

Bug report

The select method of the range in the Spreadsheet component throws an error when we have a selected cell in the visible area of the component and try to select a range that is outside of this visible area.
The bug is replicable both when the range is passed as exact cells or row-column pair:

  • sheet.range(3,2,3,3).select();
  • sheet.range("C4:E6").select();

** This is a regression from the R3 2019 release

Reproduction of the problem

  1. Open this Dojo
  2. Scroll to row 70+ and select a random cell
  3. Press the "Select range" button

Current behavior

The following error appears in the browser's console
image

If you scroll to the top rows of the Spreadsheet there is a visual selection of the cells that are passed in the range

Expected/desired behavior

On "Select range" click the "C4:E6" cell range should be selected and the Spreadsheet should be automatically scrolled to this selection.

Here is a working demo: https://dojo.telerik.com/uRERUxOm

Environment

  • Kendo UI version: 2020.1.219
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 10 Mar 2020 09:51 by Naveen

Bug report

The Spreadsheet doesn't' load correctly Excel files which definition of the tag is a single cell, instead of a cell range.

Test files: test-2.zip

Reproduction of the problem

  1. Download the test-2.zip file and load the "test.xlsx" file in the Spreadsheet here.
  2. The file has data in the “AZ” and “BA” columns and once it is imported in the Spreadsheet the data from the “BA” column is imported in the “AX” column and the values in the AZ column are missing.
  • If the above file is saved in Excel it is correctly loading in the Spreadsheet. In the attached archive there is the “test-copy.xlsx” file which is the saved and correctly working one. Below is the structure of the two files. The one in red is from the "test.xlsx" file and the code in green is from the "test-copy.xlsx" file.

MicrosoftTeams-image

Current behavior

The The "test.xlsx" file is not loading correctly in the Spreadsheet and loses data

Expected/desired behavior

The "test.xlsx" file should load correctly in the Spreadsheet without losing data

Environment

  • Kendo UI version: 2020.1.219
  • jQuery version: x.y
  • Browser: [all]
Declined
Last Updated: 27 Feb 2020 16:07 by ADMIN
Created by: David
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.
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)
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.
Declined
Last Updated: 27 Feb 2020 16:04 by ADMIN
Declined
Last Updated: 27 Feb 2020 16:01 by ADMIN
Created by: JackP
Comments: 2
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.
Declined
Last Updated: 26 Feb 2020 15:53 by ADMIN
Hi Progress - just some quick feedback: 1. Telerik Control Panel updates - it feels like a lot of the time, when the TCP needs updating the user has to manually uninstall the old version and the install the new one using the .exe installer. If the TCP could automatically handle this process, that would be appreciated. 2. The various Telerik Spread Processing libraries (and other document processing libraries) can only be installed as an included component of the Telerik "UI for X" library installations. It would be great if there was an option in the TCP to do a standalone installation of just the Spread Processing libraries. Thanks and kind regards, - Lawrence
Unplanned
Last Updated: 26 Feb 2020 15:31 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
9
Integration of the pivot control with the spreadsheet
Declined
Last Updated: 26 Feb 2020 15:15 by ADMIN
Created by: Paul
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

Bug in js\spreadsheet\numformat.js makeDateFormat

 

You appear to be using the wrong indices inside a nested loop.

if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {

Should be (switch i to j)

if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {

Getting error

Uncaught TypeError: Cannot read property 'type' of undefined
     at Object.<anonymous> (numformat.js:630)

 

Note: Version is actually 2018.3.1114 from npm

Unplanned
Last Updated: 26 Feb 2020 15:13 by ADMIN
Created by: Michael
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hi,

We are using Kendo spreadsheet one of our applications. We wanted to get applied filters and set back to the Kendo spreadsheet. Not able to find a documentation for that. Can you please anyone help to sort this issue out?

Thanks

Unplanned
Last Updated: 26 Feb 2020 15:12 by ADMIN
Created by: Jeffrey
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

Hello

We are trying to use the Kendo Jquery spreadsheet but are running across some issues in terms of setting up for printing and/or exporting to PDF.

 

Currently, we let the user modify the spreadsheet to suit their needs.  The problem is there is no way to see page breaks at this time...that we know of.  The users stretch columns and row to suit their needs but the only way to see if they 'broke' across a page is to export to pdf to see...

 

We would like one or two options...

1. We know what our page size is - 8 1/2 x 11.  Is there a way to fix the max size of the spreadsheet so it's 1 page wide?  If the user inserts columns then the other columns just get smaller and smaller - proportionally - but ultimately the sheet is as only as wide as 1 page...

 

2. The ability to see where the page breaks are so they can set up the sheet correctly.

 

Please let me know if one of these options is feasible or are we stuck?

 

Thank you

Jeffrey Suffet

Unplanned
Last Updated: 26 Feb 2020 15:07 by ADMIN
Created by: Sandeep
Comments: 3
Category: Spreadsheet
Type: Bug Report
1

Hi team,

In kendo spreadsheet if you disable any row by adding enable property to false and apply sort from data tab, then the disable row is changing based on the sort. instead of applying to particular row  it is applying to perticular range and while sorting the row items are changing. The cell properties are not applying there while sorting.

 

link for example: https://dojo.telerik.com/IkoJeMIz

 

please let me know if I am doing anything wrong here.

 

thanks.

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.

Completed
Last Updated: 26 Feb 2020 15:05 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
0
Set Fixed Cols/Rows etc. or setOptions( {filter: { ref: "A3:G49", columns:[]}});
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.