Unplanned
Last Updated: 06 Aug 2020 08:18 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.

Reproduction of the problem

  1. Open our Spreadsheet demo in Chrome.
  2. Import the attached Spreadsheet.
  3. Open the Task Manager to check Chrome memory usage, and switch sheets to see the navigation speed.
  4. Open DevTools and check memory usage again. Note that switching sheets is also significantly slower.

Current behavior

Memory usage increased and slower sheet change.

Expected/desired behavior

Memory usage should not be increased and sheet navigation should not be slow.

Environment

  • Kendo UI version: 2020.2.619
  • Browser: [all]
Unplanned
Last Updated: 21 Jul 2020 07:16 by ADMIN
Created by: Dhruven
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

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: 14 Jul 2020 07:25 by Naveen

Bug report

The AND formula, when used as part of an array formula, does not evaluate the whole array.

{=AND(A1:D1="")} would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE) would return FALSE if value is entered in any cell in range A1:D1

Reproduction of the problem

  1. Run this dojo
  2. Select cell E1, press F2 to edit formula and press Ctrl+Shift+Enter to enter as an array formula

Current behavior

  1. Enter a value in cell B1 - Array formula evaluates as TRUE, Non-array formula as FALSE
  2. Only if a value is entered in A1 the Array formula will evaluate as FALSE

Expected/desired behavior

Array formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.

Environment

  • Kendo UI version: 2020.2.617
  • Browser: [all]
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: 25 Jun 2020 07:12 by Naveen

Bug report

When using a custom cell editor in the Spreadsheet along with keyboard navigation value selection is not limited to the cell with the custom cell editor

Reproduction of the problem

  1. Run the Custom Editors Demo
  2. Click on cell B2 and open the list popup with available values for selection
  3. Press the right arrow key on the keyboard
  4. Select a value from the list
  5. The selected value will be applied to cell C2

Current behavior

The selected value is applied to cell other then the one using the custom cell editor

Expected/desired behavior

The selected value should be applied only to the cell with the custom cell editor

Environment

  • Kendo UI version: 2020.2.617
  • Browser: [all]
Unplanned
Last Updated: 22 Jun 2020 18:18 by Vamsi
Created by: Vamsi
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

Reproduction of the problem

Reproducible in this demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource

  1. Scroll down to row 78
  2. Focus A78 and drag to E78. Copy the data
  3. Paste over the empty 79 row's first cell
  4. Press Ctrl + Z to undo the changes.
  5. Open the browser's dev tools network tab and press the "Save" button above the Spreadsheet.

Current behavior

The data cleared by the "undo" shortcut is saved and sent to the server

A different behavior is exhibited if the data is pasted over the row header instead of the row's first cell. Follow the same steps, but on step 3. instead of pasting over the first cell, paste the data over the row 79 header. After undo and then clicking "Save", the fields have null values.

Expected/desired behavior

No data is sent with the request

Environment

  • Kendo UI version: 2020.2.617
  • jQuery version: x.y
  • Browser: [all]
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: 11 Jun 2020 11:21 by Naveen
Created by: David M
Comments: 5
Category: Spreadsheet
Type: Feature Request
23
Use case:
My app doesn't know how many rows of data the excel spreadsheet will be prior to upload.  I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others.  The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition.  

As a workaround, I'm destroying and reloading the widget instance after the initial load.
Unplanned
Last Updated: 10 Jun 2020 12:55 by ADMIN
Created by: Naveen
Comments: 2
Category: Spreadsheet
Type: Feature Request
1

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.

Completed
Last Updated: 08 Jun 2020 13:57 by ADMIN
Release 2020.R2.SP.next
Created by: Imported User
Comments: 5
Category: Spreadsheet
Type: Feature Request
43
It would be great if you could put images to cells using html. E.g.: <img src="..."> would result in an image in the cell.
Completed
Last Updated: 04 Jun 2020 11:49 by ADMIN
Created by: Chris
Comments: 2
Category: Spreadsheet
Type: Feature Request
4
Additional functionality for:
-- Conditional Formatting -- coloring of cells, for example based upon a value and then be able to import from excel, and export back out.
-- Data Validation (dropdowns).  Also be able to import and export back out.
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. 

Completed
Last Updated: 30 Apr 2020 08:30 by ADMIN
Created by: Martin
Comments: 6
Category: Spreadsheet
Type: Feature Request
34
Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.
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]
1 2 3 4 5 6