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

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.

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.

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:

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]

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]

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

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]

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]

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

Dear Concerned,

1. Open https://dojo.telerik.com/IjasAbeC/11

2. Check split button is not prefixed with a separator, where as all other buttons comes with prefixed separator

It seems a bug, please provide a fix.

1. Open https://dojo.telerik.com/IjasAbeC/3

2. Background color and text color buttons are initialized as a group. These buttons are not working if we put them in a group

3. If we keep them separate, outside group, the buttons work as expected.

Bug report

Reproducible with the Default and Bootstrap SASS themes.

Reproduction of the problem

Reproducible in the demos.

1. Resize the browser window making it more narrow (screencast)

Current behavior

Icons are misaligned.

Expected/desired behavior

Icons are properly aligned.

Environment

• Kendo UI version: 2019.3.917
• jQuery version: x.y
• Browser: [all]

Bug report

Reproduction of the problem

Reproducible in the demos.

1. Use the HYPERLINK function in a cell:

=HYPERLINK("https://google.com")

Current behavior

The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")

Expected/desired behavior

The link works with and without a "friendly name" specified, as in Excel.

Environment

• Kendo UI version: 2019.2.619
• jQuery version: x.y
• Browser: [all]

Bug report

When destroying a SpreadSheet and removing its corresponding DOM element, there are some DOM nodes added on SpreadSheet's initialization which are not removed after the execution of .destroy() and .remove().

Reproduction of the problem

1. Open this Dojo and run it.
2. Open browser's console and see the output in it. The initial number of the children nodes in the body is 2 and the children nodes after adding and removing a SpreadSheet are 5.
   
3. Right-click the blank page in right and inspect it. Navigate to the body in the iframe and see the additional nodes in it
   

Current behavior

Not all DOM elements added on SpreadSheet initialization are being removed when destroying it and removing its corresponding DOM element.

Expected/desired behavior

After destroying a SpreadSheet and removing its corresponding DOM element, no DOM nodes added on component's initialization should be presented in the DOM tree.

Environment

• Kendo UI version: 2019.2.514
• jQuery version: x.y
• Browser: [all]

Dear Concerned,

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

2. Open Workbook(1).xlsx (attached)

3. Edit B2, D2, F2 with some new values

4. See the results in B4, D4, F4

Calculations are different in Excel.

 

Dear Concerned,

 

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

2. Try to select columns B to D using mouse

3. Click on column B, keeping mouse clicked, move your mouse towards C then D

4. It does not allow to select B,C,D where as it is possible in Excel.

It is serious issue for me as I could not proceed with Hide/Unhide columns and some other features depend on multiple columns selection

Note: if we add a blank row at first position then it works well, seems like first with merged columns is creating problem.

Dear Kendo,

 

I made research about Kendo Spreadsheet control and I found some of unlogical things in example:

1. When I made changes (kendoSpreadsheetCancelChanges.png) in spreadsheet and click on CANCEL CHANGES button, all of these changes aren't removed.

2. Manually reading spreadsheet datasource, all of these changes aren't removed. For example, when I type in console

$("#spreadsheet").data("kendoSpreadsheet").options.sheets[0].dataSource.read();, datasource is reading, but almost all changes are shown. Why?

 

 

Kind Regards,

Marin

Hello there,

I am developing a Web application using  Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.

For example:

I have the following numbers on a Excel sheet:

1

0.5

0.333333333

0.25

0.2

0.166667

0.142857

0.125

0.111111

0.1

0.090909

0.083333

0.076923

0.071429

0.066667

0.0625

0.058824

0.055556

0.052632

Then, I copy them to the Kendo spreadsheet and I got the following:

100.00%

50.00%

33.33%

25.00%

20.00%

16.67%

14.29%

12.50%

11.11%

10.00%

9.09%

8.33%

7.69%

7.14%

6.67%

6.25%

5.88%

5.56%

5.26%

But when I copy them back to Excel I got this:

1

0.5

0.3333

0.25

0.2

0.1667

0.1429

0.125

0.1111

0.1

0.0909

0.0833

0.0769

0.0714

0.0667

0.0625

0.0588

0.0556

0.0526

Losing many decimals affecting the results of my computation and calculation.

Can you tell me why is this happening?

Thank you some much.