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!

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

Hi,

We are using Kendo spreadsheet one of our applications. We wanted to get applied filters and set back to the Kendo spreadsheet. Not able to find a documentation for that. Can you please anyone help to sort this issue out?

Thanks

Dear Kendo,

I made research about Kendo Spreadsheet control and I found some of unlogical things in example:

1. When I made changes (kendoSpreadsheetCancelChanges.png) in spreadsheet and click on CANCEL CHANGES button, all of these changes aren't removed.

2. Manually reading spreadsheet datasource, all of these changes aren't removed. For example, when I type in console

$("#spreadsheet").data("kendoSpreadsheet").options.sheets[0].dataSource.read();, datasource is reading, but almost all changes are shown. Why?

Kind Regards,

Marin

Hi,

Would like to suggest 2 features for the spreadsheet which will be very useful

1) Ability to delete specific cell (not just the content, but the cell itself). Currently there is way to delete row or columns, but no cell deletion.  When cell is deleted, user should be prompted whether to allow all cells below the deleted cell to shift up, or all cells on the right of it to shift left. Akin to excel

2) Format painter. The ability to "paint" the styles (such as font size, boldness) from existing text to another existing text. Akin to excel.

Spreadsheet saveAsExcel split is not a function error (kendo.all.js:3436) after upgrade to Kendo 2019.2.514.

The filtering on the spreadsheet component is great!!

There is however one behaviour that causes confusion for end users, and that is filtering when merged cells  are present in the selection.  
An example is available in the following dojo:
https://dojo.telerik.com/UzUMUDos

Open the dojo and filter column A on a1 and you will only see only b1 in column B, but the b1a will not be shown.

To be clear - This is also how Excel behaves...  (which is of course your prime aim so its not a bug as such)... 
Interestingly google sheets stops you putting filter on merged cells / stops you merging on filtered column.

The Excel behavior is discussed in the following threads:
https://stackoverflow.com/questions/49816515/excel-filtering-for-merged-cells
https://www.officetooltips.com/excel_2013/tips/workaround_for_sorting_and_filtering_of_merged_cells.html

Is it possible to implement something, so the end user experience would be improved? Maybe when merged cells are present :
a) if they click filter, this is detect and user is warned of this behaviour
b) if they click filter, the sheet is changed into an unmerged version (which repeats data in merged cells) as in the excel examples above.