Bug report

In the Spreadsheet, if you freeze too many columns and then try to export to Excel, the file is corrupted.

If you reduce the number of columns in the example below, the issue does not occur.

Reproduction of the problem

1. Open this example
2. Click the frozen rows button
3. Click the Export to Excel button

Current behavior

The exported file is corrupted and cannot be opened

Expected/desired behavior

The file should not be corrupted

Environment

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

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

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]

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

When the INDEX formula is used in combination with LINEST the Spreadsheet displays an empty cell. In case such formula is imported from Excel file '#VALUE' is displayed.

Reproduction of the problem

1. Open the Dojo
2. Observe the content of the cell with the pink background.

behavior when importing:

1. Import the file in the Spreadsheet demos
   LINEST_INDEX.xlsx

Current behavior

The content of the formula cell that includes LINEST and INDEX is empty. When clicking on the cell the formula is displayed in the formula bar. When importing the content in some cases the content is '#VALUE'.

Expected/desired behavior

The LINEST should work as expected in combination with the INDEX formula.

Environment

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

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 ]

Hi Team,

I would like to request the Kendo UI Spreadsheet to have CSP support.

Thank you for the consideration!

Hi

Is it possible to only move between "open cells for input. " With fx. using tab or enter. 

When you are input finance data. It would be nice, that with a tab, it only moves between open cell. Is this possible. 

On all browser, but mainly edge, chrome , 

reg. jakob

To whom it may concern,

I am having a problem with the AGGREGATE function in the spreadsheet control. Cell H7 does not give me a value.

I have attached a dojo saved file, the tutorial documentation I was following (please see pages 4 & 5), a screenshot of the function in dojo and an excel file with the aggregate function working.

Thank you advance.

After the 2022 R2 SP1 version. there is a bug in the spreadsheet data source. when dill down the cell, the data source will not be changed. only input text can trigger the change event.

• https://demos.telerik.com/kendo-ui/spreadsheet/datasource 

Reproduction steps:

1. Open the demo
2. Drag down the fill handle of a UnitPrice cell

Expected:
    Button is enabled

Actual:
    Button not enabled

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.

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.

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 ]

Hi Support Team,

Would like to have a feature below:

• To allow right-click along row and column headings to insert rows and columns.

Hi Support Team,

When select multiple cells continuously and right click, it will have more options. But when select multiple cells without continuously and right click, there is only 1 option

Would like to have a feature to have more options when select multiple cells without continuously and right click and also to able to detect which cells are selected if multiple cells are selected without continuously.

Select multiple cells continuously:                                   Select multiple cells without continuously:

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

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

Bug report

Dates and times entered (or pasted) in the spreadsheet are incorrectly parsed and do not respect the specified format. For example, dd.MM.yyyy HH:mm becomes MM.dd.yyyy HH:mm. The issue is replicated even if a culture is set.

Reproduction of the problem

1. Open the Dojo
2. Add the following date in Excel file and paste it in the Spreadsheet - 10.01.2022 09:00

Current behavior

The Spreadsheet does not parse the dates correctly.
10.01.2022 09:00 (january 10th) becomes 01.10.2022 09:00 (october 1st)
13.01.2022 09:00 is not affected by this issue.
10.01.2022 (january 10th, without time) is not affected by this issue.

Expected/desired behavior

Spreadsheet should parse the dates as they are. Copy dates such as 10.01.2022 09:00 should remain 10.01.2022 09:00 without switching the month and date values

Environment

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

Currently, when a custom button is configured in the Spreadsheet toolbar a separator is added before the button. I would like to have an option to configure whether such a separator is to be rendered or not.

I would like to avoid adding custom styles for hiding unneeded separators, which is needed with the current implementation (Dojo). 

Bug report

When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.

Reproduction of the problem

1. Open the Dojo example.

Current behavior

The bottom border and the right border are split with a white line in the middle.

Expected/desired behavior

The border should appear entirely filled with the selected color.

Environment

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