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
0

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

Pending Review
Last Updated: 10 Mar 2020 12:01 by ADMIN
Created by: Ron
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

With Excel when you use a custom number format of #,##0.00 and you enter (10) into the cell it will be displayed as -10.  With the Spreadsheet control the same example yields (10).  How can we get the same behavior as Excel with the Spreadsheet control?

 

  dojo example: https://dojo.telerik.com/@843335b6-427b-4127-af09-fbe9957bfec6/uGaVAVat

 

Thanks,

Ron

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]
Unplanned
Last Updated: 04 Mar 2020 15:54 by Vasanth

Bug report

When the Spreadsheet is bound to a DataSource upon making multiple selections in the Spreadsheet and deleting the selected ranges a JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.

Reproduction of the problem

  1. Run the demo on DataSource binding
  2. Make random multiple selections
  3. Delete selection using the Delete key

Current behavior

A JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.

Expected/desired behavior

Upon an attempt to delete multiple selections a popup should be displayed with a warning that this operation is not supported, similar to trying Copy/Paste multiple selections.

Environment

  • Kendo UI version: 2020.1.219
  • Browser: [all]
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
Need More Info
Last Updated: 27 Feb 2020 16:08 by ADMIN
Support scenarios where users can use the spreadsheet component to design templates with disabled cells.

I appreciate that this can be customized (as almost anything) but note this is the only cell property that is not configurable via the toolbar.
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.
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
8
Integration of the pivot control with the spreadsheet
Unplanned
Last Updated: 26 Feb 2020 15:16 by ADMIN

1. The top tab section (with the Home, Insert, Data, Undo, Redo) button of the toolbar should be configurable to be hidden, i.e. "single toolbar" configuration should be supported. Since it is possible to configure the toolbar to show custom items, it should also be possible to hide other tabs and the undo/redo button and only have a single toolbar as the configuration.

/* Style hack to hide the "Home/Insert/Data" tabstrip at the top of the spreadsheet. */
.k-spreadsheet-tabstrip.k-tabstrip {
    & > ul {
        display: none;
    }

    & .k-content {
        border-top: 0px;
    }
}

/**
 * Style hack to hide the undo/redo buttons in the quick-access toolbar.
 */
.k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
    display: none;
}

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:14 by ADMIN
Created by: Brian
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

It would be nice to have custom attributes for rows and cells so that I can track things behind the scenes such as row identifiers that could be used to update a corresponding rows in a the data base. This id would not be editable by the user. There are many more uses I would like this for and that is just one example.

I would rather not have to create a column in the spreadsheet just for this and then hide it. I find that very clunky.

 

Thanks.

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

1 2 3 4 5 6