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

Approved
Last Updated: 07 Oct 2019 11:33 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
7
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.
Approved
Last Updated: 30 Aug 2019 04:59 by ADMIN

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]
Approved
Last Updated: 27 Sep 2019 17:56 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
7

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]
Approved
Last Updated: 08 Oct 2019 06:53 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
7
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.
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 ] 

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: 01 Apr 2019 11:52 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
7

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.

Approved
Last Updated: 24 Apr 2019 12:02 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
7

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.

 

Approved
Last Updated: 23 Apr 2019 06:57 by ADMIN
Created by: Papas
Comments: 1
Category: TreeList
Type: Bug Report
6

Steps to reproduce bug:

  • add also toolbar: ["excel"] on config options
  • Run dojo and hit export

The result has broken Headers

Completed
Last Updated: 23 May 2019 05:50 by ADMIN
Release 2019.R2.SP.Next

The issue is reproducible when the grid consists only from Multi-header columns, the setDataSource() method has been used and one of the columns is initially hidden.

After setting the new data source, the last header gets hidden. The "display: none;" style has been applied to the "th" HTML element.

Steps to reproduce:

1. Create a grid with multi-header columns only.

2. Hide one column initially.

3. Set a new data source via the setDataSource() method.

4. The last column gets hidden.

Sample Dojo:

https://dojo.telerik.com/AcipENOt

Kendo UI version: 2019.1.220


Pending Review
Last Updated: 30 Nov 2018 12:24 by ADMIN
Created by: Abhinav
Comments: 3
Category: Spreadsheet
Type: Bug Report
3

1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.

2. Click on open button in the Toolbar of the spreadsheet.

3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.

4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.

5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.

 

Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?

Approved
Last Updated: 21 Feb 2019 07:36 by ADMIN
Created by: Iggy
Comments: 0
Category: Date/Time Pickers
Type: Bug Report
3

When the dateInput property is set to true, the readonly method does not make the widget completely non-editable. It restricts user input, however, the date can be modified using the arrow keys.

Reproduction of the issue in a Dojo sample:
https://dojo.telerik.com/OpIFacOz

1. Initialize DatePicker
2. Set the dateInput property to true
3. Call the readonly() method

Current behavior

Value can be changed with the arrow keys

Expected/desired behavior

The value should not be editable

Environment

  • Kendo UI version: 2019.1.220
  • jQuery version: 1.12.4
  • Browser: [all]

Completed
Last Updated: 05 Aug 2019 11:11 by ADMIN
Release 2019.R3
Created by: Eduard Töws
Comments: 2
Category: Kendo UI for jQuery
Type: Bug Report
3

Bug report

An error occurs on components' initialization when using a custom Kendo UI build which includes PDFviewer

Reproduction of the problem

  1. Go to Kendo UI Custom Download page
  2. In the "WEB" section select random components including the Grid and PDFviewer
  3. Download the custom build(kendo.custom.min.js file) and put it in the same folder with an HTML file with the following structure.
<!DOCTYPE html>
<html>

<head>
    <style>
        html {
            font-size: 14px;
            font-family: Arial, Helvetica, sans-serif;
        }
    </style>
    <title></title>
    <link rel="stylesheet" href="https://kendo.cdn.telerik.com/2019.2.514/styles/kendo.default-v2.min.css" />

    <script src="https://kendo.cdn.telerik.com/2019.2.514/js/jquery.min.js"></script>
    <script src="./kendo.custom.min.js"></script>
</head>

<body>
    <div id="example">
        <div id="grid"></div>
        <script>
            $(document).ready(function () {
                $("#grid").kendoGrid({
                    dataSource: {
                        type: "odata",
                        transport: {
                            read: "https://demos.telerik.com/kendo-ui/service/Northwind.svc/Customers"
                        },
                        pageSize: 20
                    },
                    height: 550,
                    groupable: true,
                    sortable: true,
                    pageable: {
                        refresh: true,
                        pageSizes: true,
                        buttonCount: 5
                    },
                    columns: [{
                        template: "<div class='customer-name'>#: ContactName #</div>",
                        field: "ContactName",
                        title: "Contact Name",
                        width: 240
                    }, {
                        field: "ContactTitle",
                        title: "Contact Title"
                    }, {
                        field: "CompanyName",
                        title: "Company Name"
                    }, {
                        field: "Country",
                        width: 150
                    }]
                });
            });
        </script>
    </div>
</body>
</html>
  1. The following error appears:
    Uncaught TypeError: Cannot read property 'Toolbar' of undefined

Current behavior

grid_pdf

Expected/desired behavior

A Grid should be initialized properly and without errors if a custom build is including the PDFviewer

Environment

  • Kendo UI version: 2019.2.514
  • 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: 16 Sep 2019 14:18 by ADMIN
Release 2019.R3

Bug report

HtmlPage1.zip

Reproduction of the problem

  1. Run the attached page in the browser.
  2. Take a 20 sec long heap snapshot. During these 20 sec click the "change" button to make changes to a specific node's data in the observable.

Current behavior

There are multiple detached span elements: screenshot
Memory consumption increases with every change: screenshot

Expected/desired behavior

Environment

  • Kendo UI version: 2019.2.619
  • jQuery version: x.y
  • Browser: [all ]
Approved
Last Updated: 04 Dec 2019 11:14 by ADMIN

Bug report

When the horizontal scroll of the grid is shown and is configured for RTL, the resize handle is mispositioned. 

Reproduction of the problem

1. Make the grid scrollable and set explicit widths to all columns.

2. Make the grid RTL.

3. Introduce multi-column headers.

4. Notice that the columns cannot be resized due to the disposition of the handler.

5. Dojo for replication:

https://dojo.telerik.com/IZInOVUd

6. Notice that whenever the horizontal scroll is not present, the resize handle is positioned correctly.

Environment

* **Kendo UI version:** 2019.3.1023
* **jQuery version:** 1.12.4
* **Browser:** [all] 

Approved
Last Updated: 28 Nov 2019 17:28 by Ashwani

Bug report

The Tooltip component is visualized at the upper left corner of the browser's window when opened in Safari.

  • The issue is not reproducing with jQuery 1.xx and 2.x.x

Reproduction of the problem

  1. Open this Dojo in Safari browser
  2. Hover the bars in the BarChart

Current behavior

The Tooltip is visualized in the upper left corner of the browser's window

Expected/desired behavior

The Tooltip should be visualized on the top of each bar of the chart that is hovered.

  • The expected behavior could be observed when the above Dojo is opened in Chrom

Environment

  • Kendo UI version: 2019.3.917
  • jQuery version: 3.x.x
  • Browser: [Safari 11.1.2 ]
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 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.


1 2 3 4 5 6