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]

Bug report

Some date formats are lost when pasting from Excel and parsed as strings

Reproduction of the problem

Excel provided in Ticket ID: 1658266

copy and paste that into any Kendo Spreadsheet component.

Expected/desired behavior
Dates shall be parsed to dates

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

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]

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 ]

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

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 ]

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

• Kendo UI version: 2024.3.806
• jQuery version: All Supported Versions
• Browser: all

Hi Team,

I would like to request the open button for the Kendo UI Spreadsheet's toolbar to fully utilize a Kendo UI Button rather than a native input button.  One benefit would be to help provide a localization message with ease.  

Thank you!

Hi Team,

I would like to request to include the Embed function for the Kendo UI Spreadsheet to include objects such as PDF files into the Spreadsheet. 

Thank you!

When a cell is copied to another cell by using the 'auto-fill' option, the format and validation from the initial cell is applied to the target as well, as described in the documentation.

- https://docs.telerik.com/kendo-ui/controls/spreadsheet/end-user/user-guide#other

I would like the possibility to persist the format and validation of the targeted cell and if for example non-valid data is dragged and dropped in a cell, the content to be rejected based on the targeted cell validation. 

Hi Team,

I would like to request a built-in way to set a reject type validation when a value is programmatically set in the Kendo UI Spreadsheet.  Currently, it only sets a warning type as shown in this Kendo UI Dojo.  

Thanks!

Hi Team,

I would like to request emf image support for the Kendo UI Spreadsheet.  If that is not possible, I would like to request a way to handle if the image is in a non-supported image type - such as a console error.  

Thank you!

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

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

Hi Team,

We are using the Kendo Spreadsheet and would like to request a feature to display a character limit indicator while the user is entering data in the cell. This is to prevent users from exceeding the character limit of a cell.

Requirement:

• When the user starts typing in a cell, it should display a live character count e.g. "10/100" if the user has entered 10 characters and limit is 100.
• Once the user reaches the maximum limit (e.g. 100/100), further input in the cell should be restricted.

Thank you!

Set Fixed Cols/Rows etc. or setOptions( {filter: { ref: "A3:G49", columns:[]}});

Bug in js\spreadsheet\numformat.js makeDateFormat

You appear to be using the wrong indices inside a nested loop.

if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {

Should be (switch i to j)

if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {

Getting error

Uncaught TypeError: Cannot read property 'type' of undefined
     at Object.<anonymous> (numformat.js:630)

Note: Version is actually 2018.3.1114 from npm