Unplanned
Last Updated: 27 Sep 2023 12:30 by Pravin

Bug report

Dropdownlist editor remains visible on scroll of the Scheduler

Reproduction of the problem

Dojo: https://dojo.telerik.com/iLusiHAm

Open the DropsDownList editor in B2 cell 

Scroll down the sceduler

Expected/desired behavior
DropsDownList editor shall close

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

Unplanned
Last Updated: 27 Sep 2023 09:33 by ADMIN

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 ]
Completed
Last Updated: 27 Sep 2023 08:50 by ADMIN

Bug report

Cannot delete defined names in the name box of the Spreadsheet when clicking the delete button.

Regression introduced with 2022.1.119

Reproduction of the problem

  1. Open the Dojo example - https://dojo.telerik.com/UcARaSok
  2. Expand the name box with the defined names.
  3. Try to delete an item from the name box by clicking the delete button.

Current behavior

The items cannot be deleted.
The following error appears in the browser console:
Uncaught TypeError: Cannot read properties of undefined (reading 'name')

Expected/desired behavior

The items in the name box should be deleted and an error should not appear.

Environment

  • Kendo UI version: 2023.2.718
  • Browser: [all]
Unplanned
Last Updated: 26 Sep 2023 06:14 by n/a

Bug report

When validation type list or a custom editor is defined for the last column of the Spreadsheet, the popup for displaying the items does not open.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliKondova/oNODiSuj
  2. Scroll horizontally to the last column and click on the cell.
  3. Try to open the popup.

Current behavior

The list with items does not appear.

Expected/desired behavior

The items should be displayed.

The issue is a regression starting with the 2023 R1 SP2 (2023.1.425) release.

Environment

  • Kendo UI version: 2023.2.829
  • Browser: [all]
Unplanned
Last Updated: 22 Sep 2023 15:59 by Mohd
Created by: Mohd
Comments: 0
Category: Spreadsheet
Type: Feature Request
2

Hi Team,

I would like to request the functionality to be able support multiple languages for the Excel file.  It would be great if there was a way to make the file content automatically change to a specific language. 

For example, if we could use a collection of <English key, French strings> of a selected language e.g. French, and all Excel text strings matching with the English key would convert to the French text.

Thank you!

Unplanned
Last Updated: 21 Sep 2023 12:34 by Pravin

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]
Unplanned
Last Updated: 12 Sep 2023 13:53 by Pravin
Created by: Pravin
Comments: 0
Category: Spreadsheet
Type: Feature Request
3

Hi Team,

I would like to request a way to include commas for the sheets.rows.cells.validation.from values.

For example:

  • 1st
  • 2nd
  • Combine 1st, and 2nd

Instead of:

  • 1st
  • 2nd
  • Combine 1st
  • and 2nd

Additionally, it would be nice to be able to use another delimiter instead of commas. 

Thank you!

  
Unplanned
Last Updated: 05 Sep 2023 12:38 by ADMIN
Cell Highlight is getting Overlapped to the top and left cell of the current editing cell when "Freeze Panes" has been enabled. Working and Overlapping versions have been provided as Screenshots replicated in the Kendo UI Demo Page.
Unplanned
Last Updated: 28 Aug 2023 07:48 by Steven

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]
Unplanned
Last Updated: 18 Jul 2023 09:15 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
2

Bug report

MONTH function does not return the same value on a black cell as in MS Excel

Reproduction of the problem

Apply the Month function on any blank cell, it returns #VALUE!, where as Excel returns 1

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

Unplanned
Last Updated: 15 Jun 2023 09:24 by ADMIN

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]
Completed
Last Updated: 12 Jun 2023 13:08 by ADMIN

Bug report

When the Spreadsheet is bound to a DataSource upon making multiple selections in the Spreadsheet and deleting the selected ranges a JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.

Reproduction of the problem

  1. Run the demo on DataSource binding
  2. Make random multiple selections
  3. Delete selection using the Delete key

Current behavior

A JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.

Expected/desired behavior

Upon an attempt to delete multiple selections a popup should be displayed with a warning that this operation is not supported, similar to trying Copy/Paste multiple selections.

Environment

  • Kendo UI version: 2020.1.219
  • Browser: [all]
Completed
Last Updated: 31 May 2023 07:32 by ADMIN
Release R2.2023-Increment.3(7.June.2023)

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.

Reproduction steps:

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

Expected:
    Button is enabled

Actual:
    Button not enabled

Unplanned
Last Updated: 11 May 2023 14:48 by ADMIN
Created by: John
Comments: 1
Category: Spreadsheet
Type: Bug Report
2

Hi Team,

Copying cells from Kendo UI spreadsheet for JQuery and pasting into excel is working as expected. But if the copied content is updated in excel and it is then copied and pasted back to the spreadsheet control using Ctrl + V keyboard shortcut, the change is not reflected. It pastes the original content copied from the spreadsheet control. Using the Ctrl+Shift+V keyboard shortcut fixes this issue and pastes the modified content as expected. But Ctrl + V keyboard shortcut should be doing this. Is this a bug in the control or is there a way to fix this with extra code when using this control?

Thank you,

John

Unplanned
Last Updated: 27 Apr 2023 09:33 by EK

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]
Unplanned
Last Updated: 21 Apr 2023 06:59 by ADMIN

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.

 

 
Unplanned
Last Updated: 20 Apr 2023 07:24 by ADMIN

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

Unplanned
Last Updated: 07 Apr 2023 13:25 by George
Created by: George
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

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]
Unplanned
Last Updated: 30 Mar 2023 11:48 by n/a

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.

Unplanned
Last Updated: 08 Mar 2023 08:16 by ADMIN
Created by: Sooty
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

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.

1 2 3 4 5 6