Unplanned
Last Updated: 28 Jan 2020 12:14 by ADMIN
Expose API that would allow a check of whether filtering has been applied to a given range/sheet. Especially identify the case when filtering is applied but no items were filtered out.
Unplanned
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
Unplanned
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.

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


Unplanned
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]
Unplanned
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]
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: 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.
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: 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: 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.
Unplanned
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]
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.

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

Unplanned
Last Updated: 06 Nov 2019 13:37 by ADMIN
Created by: Naveen
Comments: 3
Category: Spreadsheet
Type: Bug Report
8

Dear Concerned,

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

2. Select Column B11, click wrap text from Home toolbar.

3. Start typing in B11 & see cell editor keeps growing and goes beyond screen.

4. This is not user friendly, it should be same as Excel

5. Any alternative or quick fix would be appreciable

Unplanned
Last Updated: 01 Nov 2019 09:08 by ADMIN
Currently, when trying to load a corrupt XLSX file, the Spreadsheet will freeze and no message will be returned to the user. Improve the widget to unfreeze the view and notify the user about the problem.
Unplanned
Last Updated: 30 Oct 2019 15:32 by ADMIN

Add option for manual calculation of formulas, as available in Excel.

It would be a great feature to have to save time for inputting values without updating other dependent cells and once data entry is done user could press "Calculate Now" and all of the cells updated in one go, same as we do have this feature in MS Excel 365.

Unplanned
Last Updated: 22 Oct 2019 16:48 by ADMIN
Created by: Seuthes
Comments: 1
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.

1 2 3 4