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]
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]
Completed
Last Updated: 13 Jan 2020 09:20 by ADMIN
Release R1 2020

Bug report

When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.

Reproduction of the problem

  1. Go to Spreadsheet Basic usage demo
  2. Add a new sheet
  3. Type ab113abababab11ab in A1
  4. Enter the following formula in B1 =SUBSTITUTE(A1, "ab", "")

NOTE: substituting ab with another string, e.g. cd, replaces all instances of ab as expected.

Current behavior

113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string

Expected/desired behavior

11311

Environment

  • Kendo UI version: 2019.2.514
  • Browser: all
Completed
Last Updated: 13 Jan 2020 09:20 by ADMIN
Release R1 2020

When using IE 11 and using Ctrl+X to cut, this only works the first time. All subsequent attempts to use cut produce the following dialog:

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

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)

Uncaught TypeError: Cannot read property 'row' of undefined
    at init.setState (kendo.all.js:130820)
    at init.setState (kendo.all.js:125407)
    at init.undo (kendo.all.js:125401)
    at init.undo (kendo.all.js:72253)
    at init.onEntryAction (kendo.all.js:138955)
    at init.handleEvent (kendo.all.js:127458)
    at init.keyDown (kendo.all.js:127401)
    at HTMLDivElement.dispatch (jquery-1.12.4.min.js:3)
    at HTMLDivElement.r.handle (jquery-1.12.4.min.js:3)
setState @ kendo.all.js:130820
setState @ kendo.all.js:125407
undo @ kendo.all.js:125401
undo @ kendo.all.js:72253
onEntryAction @ kendo.all.js:138955
handleEvent @ kendo.all.js:127458
keyDown @ kendo.all.js:127401
dispatch @ jquery-1.12.4.min.js:3
r.handle @ jquery-1.12.4.min.js:3
Completed
Last Updated: 13 Jan 2020 09:20 by ADMIN
Release R1 2020
Created by: n/a
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

File:
3f0465a2-412c-4876-ba47-4b12ae46f92e_adam.zip

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

Reproduction of the problem

  1. Import the file

Current behavior

Errors are encountered. Even if resolving the errors bold styles are not applied as they are part of the font definition and not of the inlineStyles.

Expected/desired behavior

The excel is imported as expected.

Environment

  • Kendo UI version: 2019.2.514
  • Browser: all
Completed
Last Updated: 13 Jan 2020 09:20 by ADMIN
Release R1 2020

Bug report

The current client-side export functionality does not preserve the number of columns.

Reproduction of the problem

  • Load the following file in the Spreadsheet which contains columns up to "BA".

  • Export the file

  • Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".

Current behavior

Client-side export does not preserve the number of columns greater than "AX".

Expected/desired behavior

Client-side export does not preserve the exact number of columns.

Environment

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

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

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.

 

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: 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

Planned
Last Updated: 30 Oct 2019 11:41 by ADMIN

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

1 2 3