Completed
Last Updated: 13 Jan 2020 09:19 by ADMIN
Release R1 2020
### Bug report
The Ctrl + Shift + Arrow key keyboard shortcut should select a range in the row/column starting with the active cell and ending with the first cell in the row/column that has a value: [list of shortcuts](https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/end-user/list-of-shortcuts) used by the Spreadsheet. It works similarly in Excel. 


### Current behavior
The selection does not end at the first cell that has a value, it ends with the last cell of the row/column.  

### Expected/desired behavior
The expected behavior should be as described in the documentation: "Extends the selection of cells to the last nonblank cell in the same row or column as the active cell."

### Environment

* **Kendo UI version:** 2018.2.620
* **Browser:** [all ] 

Completed
Last Updated: 13 Jan 2020 09:16 by ADMIN
Release R1 2020

Hi Kendo Team,

The exported excel file from spreadsheet can not be opened in Microsoft excel when the spreadsheet has both a comment and a image.

You can reproduce the issue at your demo site https://demos.telerik.com/kendo-ui/spreadsheet/index

First add a comment for cell D3, then add a image, then export as xlsx.

Try open the export excel file, and you will see the error popup says "we found a problem with some content in workbook.xlsx ......"

It works when exporting comment and image separately.

Completed
Last Updated: 13 Jan 2020 09:16 by ADMIN
Release R1 2020

Bug report
Spreadsheet SUMIF function returns #NA when Excel returns the correct result. The issue is observed when the criteria range and sum range have different sizes.

Reproduction of the problem
Run the Spreadsheet demo page
Open the attached file
Formula in cell B3 returns #NA!

Current behavior
The formula in cell B3 returns #NA!

Expected/desired behavior
The formula in cell B3 should return the correct value

Environment
Kendo UI version: 2019.3.1023
Browser: [all]

Completed
Last Updated: 13 Jan 2020 09:02 by ADMIN
Release R1 2020

Dear Concerned,

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

2. Import attached Book21.xlsx file

3. I have first row as frozen pane and columns C, D are hidden

4. Select columns B to E using mouse drag & then right click on selected column , it does not show Unhide option, because on right click it keeps the selection only on column E

It does not work if we keep Freeze Panes.

Unplanned
Last Updated: 03 Jan 2020 15:36 by ADMIN
Created by: Imported User
Comments: 5
Category: Spreadsheet
Type: Feature Request
26
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.
Pending Review
Last Updated: 27 Dec 2019 08:05 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: 25 Dec 2019 06:16 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
7

Bug report

Office 365 Comment are shown with a warning:
"[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Reproduction of the problem

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

Current behavior

import a file from ticket - 1447268

A warning is displayed

Expected/desired behavior

No warning is displayed

Environment

  • **Kendo UI version: 2019.3.1023
Unplanned
Last Updated: 19 Dec 2019 13:44 by Account Manager
Created by: Account Manager
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

There is no TypeScript definition for defineFunction and no custom functions can be created in TypeScript context using the approach demonstrated in this Custom functions article.

Reproduction of the problem

Try defining a new function using:
kendo.spreadsheet.defineFunction("Mask",mask).args(maskArgs)

Current behavior

The following error appears:

Propery "defineFunction" does not exist on type 'typeof spreadsheet'

Expected/desired behavior

There shouldn't be any errors

Environment

  • Kendo UI version: 2019.3.1023
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 17 Dec 2019 12:21 by ADMIN
Created by: 경태
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Please support Excel formulas copy and paste to Kendo Spreadsheet.

Now is the copy only the text, not formulas.
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: 11 Dec 2019 15:32 by ADMIN
Different scroll position should be persisted for each sheet.
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.
Pending Review
Last Updated: 04 Dec 2019 13:55 by ADMIN

Hi,

 

I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).

When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.

Editing an empty row above this new row will modify one of the records created in this process.

Declined
Last Updated: 04 Dec 2019 09:16 by ADMIN
Created by: Martin
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
Ability to hide a sheet in kendo spreadsheet
Unplanned
Last Updated: 04 Dec 2019 09:10 by ADMIN
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
Unplanned
Last Updated: 04 Dec 2019 09:02 by ADMIN
Created by: Naveen
Comments: 5
Category: Spreadsheet
Type: Feature Request
10

Dear Concerned,

I have observed that Conditional Formatting in Spreadhseet is not supported. Please add support for the same as it is very important feature of XLSX.  during financial calculation this feature plays an important role. Here is the issue that needs a fix.

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

2. Check attached file CellColorFormula.xlsx, conditional formatting set for B2, C2, D2

3. Import attached file CellColorFormula.xlsx

4. Check Cells B2, C2, D2 and try to change values for A2, C2, D2

5. None of the conditional formatting is working

 

Completed
Last Updated: 28 Nov 2019 14:23 by ADMIN

Dear Concerned,

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

2. Copy from F3:F15

3. Paste as value (ctrl+shift+v) in H3

4. See it pasted only non-empty cells

Empty cells values should be pasted as well as Excel does.

 

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.
Unplanned
Last Updated: 26 Nov 2019 07:18 by ADMIN

The FromJson method of Telerik.Web.Spreadsheet.Workbook doesn't add images when a JSON containing an image blob is passed to it. 

It would be nice if the FromJson method supports images.