Unplanned
Last Updated: 23 Jul 2024 06:08 by Mansur
Provide a mechanism for disabling automatic recalculation of formulas in cells. In order to augment the widget when a large portion of sheets are and cells are rendered.
Unplanned
Last Updated: 16 Jul 2024 09:31 by Peili
Created by: Peili
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

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]

Unplanned
Last Updated: 20 May 2024 07:02 by Piotr
Created by: Piotr
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be beneficial to add the border styles directly within the default cell style options
Completed
Last Updated: 16 Jul 2024 13:01 by ADMIN
Release 2024 Q3 (Aug)

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]
Completed
Last Updated: 15 Jul 2024 07:23 by ADMIN
Release 2024 Q3 (Aug)

Bug report

When the background tool is displayed in the overflow menu of the toolbar and the user tries to change the background color or text color an error: e[this._property] is not a function is thrown.

Reproduction of the problem

  1. Open the Dojo - https://dojo.telerik.com/@NeliK/IHaRIvoy
  2. Select a cell and try to change its background color or text color

Current behavior

An error e[this._property] is not a function is thrown and the background color is not changed.

Expected/desired behavior

There should be no error in the console and the color should be changed accordingly.

The issue is a regression starting with 2023.1.117 version

Environment

  • Kendo UI version: 2024.1.319
  • 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 ]
Completed
Last Updated: 28 Nov 2024 09:30 by ADMIN

Bug report
SpreadSheet does not apply borderBottom correctly for last row

Reproduction of the problem

Dojo - https://dojo.telerik.com/UGABAnoR

Current behavior
Border is applied at the first row for the next column

Expected/desired behavior

The border shall be applied at the bottom at A2000


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

Unplanned
Last Updated: 18 Mar 2024 07:45 by Peili
Created by: Peili
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

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 ]
Unplanned
Last Updated: 15 Mar 2024 07:26 by Makarand
Created by: Makarand
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Add support for grouping Korean letters as one word within the Spreadsheet.
Completed
Last Updated: 04 Jul 2024 12:56 by ADMIN
Release 2024 Q3 (Aug)

Bug report

The computed range when pasting data into the spreadsheet is incorrect.



Reproduction of the problem

Dojo: https://dojo.telerik.com/eToXOQOL/9

1. Open a Notepad, and create the following structure:

a
b[tab]c[tab]d
e[tab]f[tab]g

Between each element on rows 2 and 3, there is a [tab] character. This will make sure that the data pasted into Spreadsheet will land on different columns.

 2. Copy the entire content of the Notepad document and paste it in cell A1. After the paste operation, you will notice under the Spreadsheet component an output with the range that was passed to the change event.

Problem:
The computed range is A1:A3 while the expected value is A1:C3

Expected behaviour

The expected value is A1:C3

Environment
Kendo UI version: 2021.1.224 or newer
Browser: [all]

Unplanned
Last Updated: 06 Mar 2024 10:12 by Mohd
Created by: Mohd
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

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 ]

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
1

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.

 

Unplanned
Last Updated: 09 Jan 2024 14:35 by Mohd
Created by: Mohd
Comments: 0
Category: Spreadsheet
Type: Feature Request
7

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: 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: 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!

Unplanned
Last Updated: 05 Jul 2024 08:04 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: 24 Nov 2023 06:18 by Mohd

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 ]
Unplanned
Last Updated: 16 Nov 2023 17:36 by David
Created by: David
Comments: 0
Category: Spreadsheet
Type: Feature Request
0

The Spreadsheet supports names that are defined within the global worksheet level (Workbook). However, when uploading a file that contains defined names, which scope is the local worksheet level (for example, Sheet1), the names are not available.

For example, upload the attached file in the Spreadsheet in the following online demo.

https://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export

The name defined in the scope of "Sheet1" is not available:

Please improve the Spreadsheet to support names defined in the scope of the sheet?

Unplanned
Last Updated: 03 Oct 2023 04:55 by Indika Samarasekara (Manager - IT Infrastructure)
Created by: Indika Samarasekara (Manager - IT Infrastructure)
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

When the scale and layout setting of the machine is different than 100% the keyboard navigation does not work properly. The issue occurs with different scales on each machine. For example, on some machines, it could work with all scales, but on others, it may not work with a scale of 125% or 175%, even if this is the recommended value.

Reproduction of the problem

  1. Open the demos - https://demos.telerik.com/kendo-ui/spreadsheet/keyboard-navigation
  2. Set a scale different than 100% to the computer
    image

Note, that you may need to test with different scales to manage to replicate the issue.

  1. Using the arrow keys navigate to the last column of the Spreadsheet (AX)
  2. Go to the previous column (AW)
  3. Try to move up/down/left/right

Current behavior

The navigation does not work. The cell selection does not work or goes to a wrong cell.

https://somup.com/c06nQJBFmV

Expected/desired behavior

The Spreadsheet navigation should work with all screen scales.

Environment

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