Approved
Last Updated: 24 Jan 2020 13:28 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
Dear Concerned,

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

2. Move horizontal scroller to column P

3. Now select Row 1 header, then row 2 header and keep doing it

4. Please observe horizontal scroller is also moving towards left

I assume it is a bug and need a fix. Meanwhile if you can provide a workaround for the same if possible.

Note: Similar behavior can be noted for vertical scroller on column header selection
Approved
Last Updated: 22 Jan 2020 11:53 by ADMIN

Dear Concerned,

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

2. Select column B and drag mouse towards C, both columns will be selected which is correct behavior

3. Now just scroll down 2-3 rows using vertical scroll bar

4. Repeat step 2, this time it does not select B &  C, instead it selects B,C,D,E.

5. Seems a bug, not an expected behavior.

 

Observation that might help you in fixing it:

1. if you move scroll bar in such a way so that no merged cell is visible it works well, e.g. scroll down till 20th row becomes first visible row on screen and now repeat step 2, it will work

2. if scroll position is on top then behavior is correct as well

3. Same issue exists in case of multiple row selection with merged column and scroll position.

Approved
Last Updated: 17 Jan 2020 09:14 by ADMIN

There is an issue with the Date type fields validation in the Spreadsheet. 

Here are the reproduction steps:

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

2. Import attached xlsx file.

3. There are two date cells (B1 & B2), B2 has a data validation (Date between B1 to ToDay)

4. Try to edit the date using the calendar icon from B2. An empty calendar appears

Note: If I change data validation (remove reference of B1 and put hardcoded date) as below then it works.


Approved
Last Updated: 14 Jan 2020 07:10 by Naveen

Bug report

If an Excel file that contains Shapes is imported in the Spreadsheet, the imported content cannot be exported back to '.xlsx' file. Saving the imported content to Excel throws an error in the console.

Reproduction of the problem

  1. Open this demo
  2. Import the attached "Download Issue.xlsx" file that has one shape and one Image in the Sheet1.
  3. The file import will be successfully executed. The shape from the file is not visible in the Spreadsheet(this is expected behavior as the Spreadsheet component does not support Shapes, so they are ignored during the import process)
  4. Export(save) the Spreadsheet content as Excel file

Current behavior

Exporting the Spreadsheet content throws an error in the console:
image

Expected/desired behavior

The Spreadsheet content should be exported to Excel file that doesn't contain the shapes from the imported file

Environment

  • Kendo UI version: 2019.3.1023
  • jQuery version: x.y
  • Browser: [all]
Approved
Last Updated: 17 Jan 2020 13:39 by ADMIN

Bug report

Reproduction of the problem

Dojo example.

Current behavior

The first row is duplicated.

Expected/desired behavior

The first row is not duplicated

Environment

  • Kendo UI version: 2019.3.1023
  • jQuery version: x.y
  • Browser: [all]
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.

Approved
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
Approved
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]
Approved
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)

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

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.

Approved
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.
Approved
Last Updated: 25 Nov 2019 08:44 by ADMIN
It would be useful if it is possible to filter between a range of values, like in Excel. For example filter for values that are between 3 and 6.
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.

Pending Review
Last Updated: 22 Nov 2019 12:48 by ADMIN
Created by: Sandeep
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

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.

Approved
Last Updated: 20 Nov 2019 07:50 by ADMIN

Bug report

The wrap text tool hides some of the cell's text if it is too long.

Reproduction of the problem

Go to this Dojo. Select cell A1 and toggle the wrap text tool. The beginning of the text is not displayed.

Current behavior

Part of the cell's content is hidden.

Expected/desired behavior

All the text should be visible.

Environment

  • Kendo UI version: 2019.3.1023
  • Browser: [all]
Approved
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.

Approved
Last Updated: 19 Nov 2019 15:54 by ADMIN
Created by: Janne
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

I would like to be able to generate PDF from spreadsheet using HTML template (like http://dojo.telerik.com/Ovegu), so i could specify headers and footers for all PDFs that are created by the user.

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]

1 2 3 4 5 6