This is observed also in online demos:

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

Steps:

1. Open demo
2. Edit a cell and enter text
3. Press Alt+Enter and enter more text
4. Press Alt+Enter
   
   Result: the last letter of the row is transferred to the new row

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]

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.

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.

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.

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]

Hi Team,

I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please 

check the URL

https://dojo.telerik.com/

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]

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.

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

Bug report
When using Spreadsheet with SASS theme and entering an array formula with Ctrl+Shift+Enter the {} braces surrounding array formula in the formula bar are not displayed.

Reproduction of the problem
Enter the following formula in any cell within the dojos below cell and press Ctrl+Shift+Enter : =Product(C3:C11)
dojo of a Spreadsheet demo with LESS theme
dojo of a Spreadsheet demo with SASS theme

Current behavior
Spreadsheet with LESS based theme displays the array formula correctly in the formula bar: {=Product(C3:C11)}
Spreadsheet with SASS based theme displays the array formula incorrectly in the formula bar: =Product(C3:C11)

Expected/desired behavior
Spreadsheet with SASS based theme should display array formulas with {} braces: {=Product(C3:C11)}

Environment
Kendo UI version: 2019.3.1023

Error occurred in browser console after select cell with value, pressing cut scissors button on top and press undo shortcut key combination (Ctrl+Z at windows or Cmd+Z at macos)