Completed
Last Updated: 27 Feb 2024 12:06 by ADMIN
Release 2024 Q2
Created by: ccacdi
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

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

Unplanned
Last Updated: 16 Feb 2024 14:20 by n/a
Created by: n/a
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

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

Under Review
Last Updated: 14 Feb 2024 11:20 by ADMIN
Created by: Doug
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

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.

 

Completed
Last Updated: 02 Feb 2024 15:34 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

Reproduction of the problem

Reproducible in the demos. The attached video demonstrates the issue.
Recording49.zip

  1. Reduce to minimum the width of several adjacent columns
  2. Increase the width of one of them

Current behavior

As shown in the video, the F column completely disappears. The column letter remains visible within the next column (G). F column's resize handle remains hidden, and it cannot be made visible.

Expected/desired behavior

There should be a minimum column width that should be respected on resizing. Its value should always allow the column to be resized. No column overlapping should occur.

Environment

  • Kendo UI version: 2020.3.1118
  • jQuery version: x.y
  • Browser: [Chrome 87 ]
Completed
Last Updated: 18 Jan 2024 09:41 by ADMIN
Release 2024 Q1

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]
Unplanned
Last Updated: 09 Jan 2024 14:35 by Mohd
Created by: Mohd
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Structured references in MS Excel: 

Example formulas that should work (Table1 is a named reference of a table):

1. =Table1[Column2] is not working in kendo 

2. =Table1[#Header]  -- Header, Data, All and all other specifiers.

 

3. =[@ColX] also not working .

Unplanned
Last Updated: 08 Jan 2024 09:09 by Anant

Bug report

In a Spreadsheet with date cell editor, the fr-CA culture does not work.

Reproduction of the problem

  1. Open this Dojo example - https://dojo.telerik.com/ogEvuTEf/6
  2. Open the editor for the date cell

Current behavior

The Calendar is empty

Expected/desired behavior

The Calendar should display the dates defined in the validation

Environment

  • Kendo UI version: 2023.3.1114
  • Browser: [all]
Completed
Last Updated: 05 Jan 2024 09:26 by ADMIN

Bug report

When destroying a SpreadSheet and removing its corresponding DOM element, there are some DOM nodes added on SpreadSheet's initialization which are not removed after the execution of .destroy() and .remove().

Reproduction of the problem

  1. Open this Dojo and run it.
  2. Open browser's console and see the output in it. The initial number of the children nodes in the body is 2 and the children nodes after adding and removing a SpreadSheet are 5.
    Nodes_count
  3. Right-click the blank page in right and inspect it. Navigate to the body in the iframe and see the additional nodes in it
    Nodes_count_body

Current behavior

Not all DOM elements added on SpreadSheet initialization are being removed when destroying it and removing its corresponding DOM element.

Expected/desired behavior

After destroying a SpreadSheet and removing its corresponding DOM element, no DOM nodes added on component's initialization should be presented in the DOM tree.

Environment

  • Kendo UI version: 2019.2.514
  • jQuery version: x.y
  • Browser: [all]
Completed
Last Updated: 03 Jan 2024 09:21 by ADMIN
Release R1.2024-Increment.2(31.Jan.2024)

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]
Completed
Last Updated: 15 Dec 2023 14:53 by ADMIN

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
Unplanned
Last Updated: 15 Dec 2023 14:14 by ADMIN
Created by: John
Comments: 2
Category: Spreadsheet
Type: Bug Report
3

[Edited]

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
Completed
Last Updated: 15 Dec 2023 13:14 by ADMIN
Release 2020.R1
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
7

Dear Concerned,

 

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Try to select columns B to D using mouse

3. Click on column B, keeping mouse clicked, move your mouse towards C then D

4. It does not allow to select B,C,D where as it is possible in Excel.

It is serious issue for me as I could not proceed with Hide/Unhide columns and some other features depend on multiple columns selection

Note: if we add a blank row at first position then it works well, seems like first with merged columns is creating problem.

Completed
Last Updated: 15 Dec 2023 13:12 by ADMIN
Release 2019.R1
Created by: Abhinav
Comments: 3
Category: Spreadsheet
Type: Bug Report
3

1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.

2. Click on open button in the Toolbar of the spreadsheet.

3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.

4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.

5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.

 

Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?

Completed
Last Updated: 15 Dec 2023 09:41 by ADMIN


To reproduce
Steps to reproduce the behavior:

step1: Make a cell become wrap text and text something

 

step2: Export to pdf file:

 

Expected behavior
Text display same as on safari

Please fix this problem asap!!!.

Completed
Last Updated: 15 Dec 2023 09:34 by ADMIN

There is an issue with the Date type fields validation in the Spreadsheet. 

Here are the reproduction steps:

1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Import attached xlsx file.

3. There are two date cells (B1 & B2), B2 has a data validation (Date between B1 to ToDay)

4. Try to edit the date using the calendar icon from B2. An empty calendar appears

Note: If I change data validation (remove reference of B1 and put hardcoded date) as below then it works.


Completed
Last Updated: 14 Dec 2023 14:24 by ADMIN
Release 2021.R1.SP1
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
7

Dear Concerned,

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Open Workbook(1).xlsx (attached)

3. Edit B2, D2, F2 with some new values

4. See the results in B4, D4, F4

Calculations are different in Excel.

 

Completed
Last Updated: 04 Dec 2023 14:35 by ADMIN

Bug report

When the sheets.filter property of the Spreadsheet is configured and there is a hyperlink in a cell, the hyperlink is not clickable and cannot be accessed.

Regression introduced with 2022.1.119

Reproduction of the problem

  1. Open the following Dojo example - https://dojo.telerik.com/@Zornitsa/aWugOqiw
  2. Try to click on the hyperlink in the 'Terry Lawson' cell.

Current behavior

The hyperlink cannot be clicked.

Expected/desired behavior

The hyperlink should be clickable.

 

Workaround

As a workaround, you can add the following style:

 .k-spreadsheet-data{
   z-index: 100;
}

Environment

  • Kendo UI version: 2023.3.1114
  • Browser: [all]
Unplanned
Last Updated: 01 Dec 2023 06:21 by Markus
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
Unplanned
Last Updated: 30 Nov 2023 14:03 by Mohd
Created by: Mohd
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Hi Team,

Please add the MINIFS function to the Kendo UI Spreadsheet. 

Thank you!

Completed
Last Updated: 30 Nov 2023 10:17 by ADMIN
Created by: Alina
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

Hi Team,

I would like to request the Kendo UI Spreadsheet to include JSZip 3.x functionality for future releases. 

Thank you!

1 2 3 4 5 6