Reproduction of the problem

Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource

And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve

Current behavior

The first added cell value (or row) is removed when the user deletes an empty row.
If the ID is entered, the result is even stranger:
https://www.screencast.com/t/osmVOiY7al

Expected/desired behavior

It should behave and function like Excel. I think with local/static binding there are no issues.

Bug report

The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.

Reproduction of the problem

Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.

Expected/desired behavior

If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.

Environment

• Kendo UI version: 2022.2.802
• jQuery version: All Supported
• Browser: all

Hi Team,

I'd like to request the functionality to allow cell configurations to be populated by database values by default.  For example, I'd like to have a value from the database populate the specific link configuration.

Thank you!

Bug report

When the select() method is used in the Spreadsheet changing event wrong cell is selected.

Reproduction of the problem

1. Open the dojo example
2. Select a different cell, change its value, and press Enter

Current behavior

Changing event is fired, but the 'B3' cell is selected instead of the 'B2'

Expected/desired behavior

The correct cell should be selected when using the select method inside the Spreadsheet event handlers.

Environment

• Kendo UI version: 2022.3.913
• Browser: [all ]

When cells of the Spreadsheet that contain data are merged data loss occurs.

To prevent inappropriate merges we need to be able to handle an Merge/Unmerge event of the Component that should be preventable.

Thank you.

Has anyone at Kendo ever thought of putting an OnBlur event on a Spreadsheet Cell. The purpose of the event (at least in my case) would be to cancel navigation to another cell. The Change and Changing events are close, but from what I can tell there is no way to cancel the navigation when either of these events fire. If you navigate to another cell and the data has changed, the Changing event fires before the Select event, but there is no way to stop the select event from firing once the Changing even is complete. I tried using Select from with the Changing event to set navigate back to the same cell, but there is currently an open bug in respect to that, as it does not navigate properly.

To hopefully state it more clearly, It would be nice if the Spreadsheet cell had an OnBlur Event that allows you to cancel navigation and remain in the same cell. Ideally it would word for all forms of navigation. Mouse Click on new cell or Scroll with Arrows.

Bug report

Spreadsheet: Improper copy paste to Excel when merged cells are present and one column in the merged cells range is hidden. If the column containing the first merged cell is hidden all the rows on that row will be shifted to the left.

Reproduction of the problem

• Run the following Dojo;
• Select Range A1:D3 (note that column B is hidden)
• Press Ctrl + C;
• In Excel workbook press Ctrl + P;

Current behaviour

After pasting, the merged cell consists of 4 cells, as expected, but the cell data is shifted to the left and the hidden column contains the cell data of the next column

Expected/desired behavior

The cells after the merged cell should not be shifted.

Environment

• Kendo UI version: 2023.1.117
• Browser: [all ]

I have a column of a string type, but I would like to have a validation list such as ['1', '2', '3', '4', '5']. However, even after setting the format to '@' and the schema column to type: "string", after saving the values, the cells are marked as invalid, as the column is of type string and the values in the validation.from the list are numbers. Thus, the validation marks the values as invalid. Here is a Dojo that demonstrates the issue - in the Dojo after selecting a value in column C and saving the changes the value is marked as invalid

I would like the validation.from option to be improved, to have the possibility to set the type of values in the validation.from a list and have digits in a string column to be considered a valid value. Such improvement could be also helpful in scenarios where boolean true/false values should be considered as strings.

Bug report

In Firefox with Windows 11, the Spreadsheet cannot be scrolled using the scrollbars.

Reproduction of the problem

1. Open the Overview demo in Firefox on a machine that uses Windows 11
2. Try to scroll vertically or horizontally.

Current behavior

The Spreadsheet cannot be scrolled through the scrollbars

Expected/desired behavior

The Spreadsheet should be scrolled through the scrollbars

Environment

• Kendo UI version: 2023.1.314
• Browser: [Firefox + Windows 11]

Related to this ticket View Ticket | Your Account (telerik.com) (id: 1605513)

Basically, when all the rows fit in the viewport, the horizontal scrollbar should be entirely hidden instead of always visible.

Bug report

If you copy a cell whose text contains multiple spaces from one Spreadsheet and try to paste it in another, the multiple spaces are lost

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/ExaliBOc/6
2. Copy the Content of B1 cell from the first Spreadsheet.
3. Paste it in the second Spreadsheet.

Current behavior

The pasted content contains only one spaces instead of three, as in the original cell content

Expected/desired behavior

All the spaces should be preserved when pasting in another Spreadsheet.

Environment

• Kendo UI version: 2023.1.425
• Browser: [all]

Bug report

When an Excel File that contains VLOOKUP and calculated columns is imported in Excel, this results to CIRCULAR value for the cells, although ther are no circular formulas in the file.

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliKondova/ApAGUkET
2. Import the file - Demo.xlsx

Current behavior

The values in the Spreadsheet are imported as '#CIRCULAR' although there are no circular formulas.

When the VLOOKUP in cell L2 is deleted the values are imported as '#VALUE'

Expected/desired behavior

The values in the Excel file should be imported correctly.

Environment

• Kendo UI version: 2023.3.1114
• jQuery version: x.y
• Browser: [all ]

Hi Team,

Please add the MINIFS function to the Kendo UI Spreadsheet. 

Thank you!

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

Once I showed this control to a few people they loved it and are asking me to make a lot of interfaces with it.
All of these are databound. 
They want some validation, like dropdown lists, datapicker, etc. And I found you can put controls in cells.
But what do I do with hundreds of rows? In the rows/cells there is validation and editors that can be setup.
For databound sheets, the columns would be a more logical place for validation and editors.

I did find this today, prepping for this request,  https://docs.telerik.com/kendo-ui/controls/spreadsheet/custom-editors

But that is not intuitive.

I'd like for the same validation and editors that are available on rows.cells to be available at sheets.columns when the sheets.dataSource is used.

These would be applied to the columns on the data rows created from the datasource.

Currently, there is a KB that demonstrates how only values can be pasted into the Spreadsheet. However, to achieve pasting values the cells are modified programmatically, which leads to an improper undoRedo stack. In the knowledge base article if the user presses 'Undo' then a single cell will be undone. 

We can add the editing of the cell using commands as demonstrated below, but this will require the user to undo the changes cell by cell and not the entire range at once:

spread._workbook.execute({ command: "EditCommand", options: { value: value, operatingRange: range, editRange: range}});

I think that it will be a good improvement if the Spreadsheet can be configured or if it provides a method that will allow paste-only values that will be properly added to the undoRedo stack and without additional customizations. 

Regards

Bug report

Round Function from empty cell shows #VALUE! but in Excel, this shows 0

Reproduction of the problem

Open Dojo: https://dojo.telerik.com/aBOMoCOF

Paste in cell B1 the following formula: =ROUND(A1, 2)

The shown result is #VALUE!

In Excel the same formula returns 0

Expected/desired behavior

The shown value must be 0

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

Bug report

When values are pasted in the Spreadsheet if the cell is not empty the previous format is taken into account

Reproduction of the problem

1. Open the Dojo - https://dojo.telerik.com/@NeliK/IniJunuZ
2. Paste content that contains different formats such as dates and numbers (sample file attached)
   test_format.xlsx
3. Paste the content two times as the second time the number column should be pasted over the column that has dates

Current behavior

The number column is formatted as date - screencast(https://somup.com/cZeoodChyH)

Expected/desired behavior

The current format should be applied to the pasted data.

Environment

• Kendo UI version: 2024.1.130
• Browser: [all ]