Unplanned
Last Updated: 10 Jan 2025 15:50 by Anil

Bug report

Spreadsheet fromFile() method does not return reject promise when an error occurs while loading file. An error is thrown on the browser console instead.

The issue has been tracked to the following implementation in the source:

  • In the spreadsheet/workbook.js, the method fromFile() rejects the promise only when no file has been passed to the method code
  • In the spreadsheet/excel-reader.js the method readWorkbook() should receive the deferred object as its last argument, but is renamed to progress and never used in the method;

Reproduction of the problem

  • On the following Dojo select invalid file in the file input (.png, .pdf, .jpg or other);

Expected:

the 'No file to be loaded!' should be alerted;

Actual:

An error will be thrown on the console

Kendo version: 2023.3.1010

Completed
Last Updated: 10 Jan 2025 13:39 by ADMIN
Release 2025 Q1 (Feb)
Created by: Markus
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug Report

Calling the saveAsExcel method of the Spreadsheet throws an error, and the component is not exported

Regression introduced with 2024.4.1112

Workaround: https://dojo.telerik.com/fDhKflqE/2

Steps to Reproduce

  1. Open the saveAsExcel API reference - https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet/methods/saveasexcel
  2. In the example, click the Export button, and check the browser console.

Current Behaviour

An error is thrown, and the file is not exported

Expected behaviour

No errors, and the file should be exported

Unplanned
Last Updated: 09 Jan 2025 07:31 by Faraz

Describe the bug
When a custom editor is defined and next to it there is a frozen column, the custom editor cannot be opened.

To reproduce
Steps to reproduce the behavior:

  1. Go to 'Dojo'
  2. Click in cell B1
  3. Try to open the calendar

Expected behavior
The calendar should be opened

Workaround

.k-spreadsheet .k-selection-wrapper .k-spreadsheet-editor-button.k-spreadsheet-last-column {
        transform: translateX(-100%);
}

The issue is a regression starting with themes version 6.3.0

Affected package (please remove the unneeded items)

  • theme-default
  • theme-bootstrap
  • theme-material
  • theme-tasks

Affected suites (please remove the unneeded items)

  • Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

  • All
Unplanned
Last Updated: 16 Dec 2024 13:31 by Jose

Bug report

When the change event is bound after initialization it is not fired when changing a cell value.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/XeTgsxKc
  2. Change a value in a cell

Current behavior

The change event is not fired.

Expected/desired behavior

The change event should be triggered when a value of a cell has been changed.

Environment

  • Kendo UI version: 2024.4.1112
  • Browser: [all ]
Unplanned
Last Updated: 28 Nov 2024 12:37 by Mirco

Bug report
Subtotal Function in Spread returns wrong calculation on hidden columns. In Excel hidden columns does not reflect the result

Reproduction of the problem

1.https://demos.telerik.com/kendo-ui/spreadsheet/index
 
2. Paste =SUBTOTAL(109, E3:E11) in cell not in E column
 
3. Hide E column 
 
4. See result becomes 0

 

Expected

Same result as in Excel

Ticket ID: 1671335

Environment

jQuery: 3.4.1

Kendo UI version: 2024.4.1112
Browser: [all]

Completed
Last Updated: 28 Nov 2024 11:00 by ADMIN

Bug report

When exporting a Spreadsheet with a set background to a PDF file, some of its borders are not displayed.

Reproduction of the problem

  1. Open the following Dojo example - https://dojo.telerik.com/IZUhIDeV
  2. Export the Spreadsheet to PDF

Current behavior

Some borders of the Spreadsheet are missing in the exported PDF file.

Expected/desired behavior

All borders of the Spreadsheet should be displayed in the PDF file.

Environment

  • Kendo UI version: 2023.2.829
  • Browser: [all]
Completed
Last Updated: 28 Nov 2024 09:30 by ADMIN

Bug report
SpreadSheet does not apply borderBottom correctly for last row

Reproduction of the problem

Dojo - https://dojo.telerik.com/UGABAnoR

Current behavior
Border is applied at the first row for the next column

Expected/desired behavior

The border shall be applied at the bottom at A2000


Environment
Kendo UI version: [all]
Browser: [all ]

Completed
Last Updated: 04 Nov 2024 15:24 by ADMIN
Created by: John
Comments: 2
Category: Spreadsheet
Type: Bug Report
3

[Edited]

Bug report

After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.

Reproduction of the problem

  1. Open the Kendo UI Spreadsheet Overview
  2. Copy Data C7:D8 from Kendo Spreadsheet
  3. Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
  4. Edit values in MS Excel.
  5. Copy from MS Excel
  6. Paste new values to a Kendo UI Spreadsheet.

Expected/desired behavior

The new values are not pasted back to the Kendo UI Spreadsheet.

Environment

  • Kendo UI version: 2023.3.1114
  • jQuery version: All Supported Versions
  • Browser: all
Unplanned
Last Updated: 02 Oct 2024 14:47 by Mohd
Created by: Mohd
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

The following Toolbar localization settings are not applying for the Kendo UI Spreadsheet when it is configured with a localization/messages file and/or using JavaScript:

  • kendo.spreadsheet.messages.toolbar.formatTypes
  • kendo.spreadsheet.messages.toolbar.alignmentButtons
  • kendo.spreadsheet.messages.toolbar.freezeButtons
  • kendo.spreadsheet.messages.toolbar.mergeButtons

Reproduction of the problem

  1. Go to this Progress Kendo UI Dojo. It uses the es-ES messages file.
  2. Open the alignment buttons dialog.
  3. Open the format types dialog.
  4. Open the merge buttons dialog - not in overflow menu.
  5. Open the freeze panes buttons dialog - not in overflow menu.

Expected/desired behavior

The toolbar messages should be translated.

Environment

Unplanned
Last Updated: 02 Oct 2024 05:21 by Pravin

Bug report

When a cell that contains letters and numbers is dragged and dropped, the new content has an incorrect value. The issue appears when the first character is a letter and when the number contains zero.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliK/OfalaBuc
  2. Drag the B0 and C0 cells

Current behavior

The result is:
image

Expected/desired behavior

The result should be the same value in case of text content (C0) or an incremented value in case the content ends with a number. Ex: A101 should result in A102, A103, A104 etc.

The issue is a regression starting with 2022.2.621

Environment

  • Kendo UI version: 2024.3.806
  • Browser: [all ]
Unplanned
Last Updated: 27 Aug 2024 20:21 by Shivam
Created by: Shivam
Comments: 0
Category: Spreadsheet
Type: Bug Report
3

Bug report

When trying to import an Excel document into the Kendo UI Spreadsheet with a missing/corrupt image reference, the file will not show.

Reproduction of the problem

  1. Import an XLSX file with a corrupted image into the Kendo UI Spreadsheet demo. (See ticket 1661911 for an example document)

Current behavior

The Kendo UI Spreadsheet fails to load the document.

Expected/desired behavior

The Kendo UI Spreadsheet should handle the error and load the Spreadsheet data without the image.

Environment

Unplanned
Last Updated: 27 Aug 2024 14:32 by ADMIN

As demonstrated here: https://dojo.telerik.com/oFiJOciY

I have the spreadsheet's first row and first column frozen.

I have also made the editor background red, so it is easier to visualize. 

Double click any cell below the frozen parts to enter editor mode, and you will see the editor drift out of its desired rectangle by 2 pixels,

 This is likely caused by the 2px border applied on the k-spreadsheet-pane

 

Unplanned
Last Updated: 26 Aug 2024 07:25 by Dennis

Bug report

When the formula PRODUCT is used and the content of the cell based on which the formula is calculated is deleted, the result is incorrect.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliK/OKAQaGOv
  2. Delete the content of the A1 cell

Current behavior

The result in B1 is 1, while it should be 0

Expected/desired behavior

When the content of the cell used for calculation is deleted, the product formula should result to 0 (as it is in Excel).

Environment

  • Kendo UI version: 2024.3.806
  • Browser: [all ]
Unplanned
Last Updated: 15 Aug 2024 05:51 by Steven
Created by: Steven
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

When the Spreadsheet height is greater than the page height and the user scrolls and than enters a value in a cell, the Spreadsheet scrolls to the top.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliK/EcUYewiH
  2. Scroll down the scroller of the page and enter a value.

Current behavior

The Spreadsheet is scrolled to the top. screencast - https://go.screenpal.com/watch/cZj220V9U6j

Expected/desired behavior

The Spreadsheet should persist the position.

The issue is a regression starting with 2022.1.119 version.

Environment

  • Kendo UI version: 2024.3.806
  • jQuery version: x.y
  • Browser: [all | Chrome XX | Firefox XX | IE XX | Safari XX | Mobile Chrome XX | Android X.X Web Browser | iOS XX Safari | iOS XX UIWebView | iOS XX WKWebView ]
Unplanned
Last Updated: 26 Jul 2024 09:55 by Dawid

Bug report

When attempting to validate a cell value against a predefined finite list, the validation process fails to recognize valid entries that are present in the list. Instead, it incorrectly flags them as invalid. The issue occur when there is an empty space before the first value in the 'from' option.

Reproduction of the problem

  1. Run the Dojo - https://dojo.telerik.com/@NeliK/icizisEF

Current behavior

On the first row, the 'YES' in the B1 cell is marked as invalid although it is present in the list with the valid values. the difference between row 1 and row 4 is the empty space in the validation from configuration:

"from": "{ \"YES\", \"NO\"}", //row 1
"from": "{\"YES\", \"NO\"}" //row 4

Expected/desired behavior

The empty space added in the from configuration option should not affect the validation. If the cell value is present in the list, it should be marked as valid.

The issue is a regression starting with 2020.3.1118

Environment

  • Kendo UI version: 2024.2.514
  • Browser: [all]
Completed
Last Updated: 16 Jul 2024 13:01 by ADMIN
Release 2024 Q3 (Aug)

Bug report

Modified date value from Excel is not correctly updated when pasting in the Spreadsheet.

Regression introduced with 2023 R1

Reproduction of the problem

  1. Open this Dojo example - https://dojo.telerik.com/AZateGoC/6
  2. Copy the Spreadsheet content
  3. Paste in to an Excel file
  4. Change the date cell value
  5. Copy and paste back in the Spreadsheet

Current behavior

The updated date cell is not pasted in the Spreadsheet

Expected/desired behavior

The updated cell's value should be pasted in the Spreadsheet

Environment

  • Kendo UI version: 2024.1.319
  • Browser: [all]
Completed
Last Updated: 15 Jul 2024 07:23 by ADMIN
Release 2024 Q3 (Aug)

Bug report

When the background tool is displayed in the overflow menu of the toolbar and the user tries to change the background color or text color an error: e[this._property] is not a function is thrown.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliK/IHaRIvoy
  2. Select a cell and try to change its background color or text color

Current behavior

An error e[this._property] is not a function is thrown and the background color is not changed.

Expected/desired behavior

There should be no error in the console and the color should be changed accordingly.

The issue is a regression starting with 2023.1.117 version

Environment

  • Kendo UI version: 2024.1.319
  • jQuery version: x.y
  • Browser: [all | Chrome XX | Firefox XX | IE XX | Safari XX | Mobile Chrome XX | Android X.X Web Browser | iOS XX Safari | iOS XX UIWebView | iOS XX WKWebView ]
Unplanned
Last Updated: 05 Jul 2024 08:04 by ADMIN

Bug report

When the sheets.filter property of the Spreadsheet is configured and there is a hyperlink in a cell, the hyperlink is not clickable and cannot be accessed.

Regression introduced with 2022.1.119

Reproduction of the problem

  1. Open the following Dojo example - https://dojo.telerik.com/@Zornitsa/aWugOqiw
  2. Try to click on the hyperlink in the 'Terry Lawson' cell.

Current behavior

The hyperlink cannot be clicked.

Expected/desired behavior

The hyperlink should be clickable.

 

Workaround

As a workaround, you can add the following style:

 .k-spreadsheet-data{
   z-index: 100;
}

Environment

  • Kendo UI version: 2023.3.1114
  • Browser: [all]
Completed
Last Updated: 04 Jul 2024 12:56 by ADMIN
Release 2024 Q3 (Aug)

Bug report

The computed range when pasting data into the spreadsheet is incorrect.



Reproduction of the problem

Dojo: https://dojo.telerik.com/eToXOQOL/9

1. Open a Notepad, and create the following structure:

a
b[tab]c[tab]d
e[tab]f[tab]g

Between each element on rows 2 and 3, there is a [tab] character. This will make sure that the data pasted into Spreadsheet will land on different columns.

 2. Copy the entire content of the Notepad document and paste it in cell A1. After the paste operation, you will notice under the Spreadsheet component an output with the range that was passed to the change event.

Problem:
The computed range is A1:A3 while the expected value is A1:C3

Expected behaviour

The expected value is A1:C3

Environment
Kendo UI version: 2021.1.224 or newer
Browser: [all]

Completed
Last Updated: 04 Jun 2024 06:07 by ADMIN
Release 2024 Q1

Bug report

When the reference to a cell in a specific Sheet is added in the defineName function, using the name leads to invalid result.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliKondova/eWeVASOK
  2. Select a cell and type '=Foo'

Current behavior

The returned result is '#NAME?'

Expected/desired behavior

The returned result should depend on the referenced cell value. In the example above B2 have a value 5, thus the value in the selected cell should be also 5.

The issue also appears when importing an Excel file with defined names in the Spreadsheet. The names in the attached Excel file are created as in the image below:
image

test.xlsx

The issue is a regression starting with the 2022 R2 SP1 (2022.2.621) release

Environment

  • Kendo UI version: 2023.2.829
  • Browser: [all ]
1 2 3 4 5 6