Unplanned
Last Updated: 25 Mar 2024 11:36 by ADMIN
Created by: Jose
Comments: 2
Category: Spreadsheet
Type: Feature Request
17
Set an indicator same way that grid already does but now in sheet cells when a record is 'dirty'.
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.
Unplanned
Last Updated: 07 Mar 2024 07:27 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: 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.

 

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

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: 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: 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: 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: 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: 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: 28 Feb 2023 13:34 by Chanaka
Created by: Chanaka
Comments: 0
Category: Spreadsheet
Type: Feature Request
3

Hi Team,

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

Thank you for the consideration!

Unplanned
Last Updated: 22 Feb 2023 14:55 by Chris
Created by: Martin
Comments: 9
Category: Spreadsheet
Type: Feature Request
40
Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.
Unplanned
Last Updated: 15 Dec 2022 09:39 by ADMIN
Created by: Daniel
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

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.

Unplanned
Last Updated: 11 Nov 2022 15:30 by Jyothi
Created by: Jyothi
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

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.

Unplanned
Last Updated: 01 Nov 2022 07:40 by ADMIN
Created by: Cheng Mun
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

Hi Support Team,

Would like to have a feature below:

  • To allow right-click along row and column headings to insert rows and columns.
1 2 3 4 5 6