Hi Team,

I would like to request to include the PMT function for the Kendo UI Spreadsheet.

Thank you!

We are using a sheet with a datasource

if the user only selects one column and then sorts it only sorts the data in that column and mixes the rows data. 

Suggestion: the filter button should act like the Excel filter button where it auto selects the entire sheet before applying the filter.

Maybe only when using a datasource?

Hi Team,

We are using the Kendo Spreadsheet and would like to request a feature to display a character limit indicator while the user is entering data in the cell. This is to prevent users from exceeding the character limit of a cell.

Requirement:

• When the user starts typing in a cell, it should display a live character count e.g. "10/100" if the user has entered 10 characters and limit is 100.
• Once the user reaches the maximum limit (e.g. 100/100), further input in the cell should be restricted.

Thank you!

Hi Team,

I would like to request emf image support for the Kendo UI Spreadsheet.  If that is not possible, I would like to request a way to handle if the image is in a non-supported image type - such as a console error.  

Thank you!

Hi Team,

I would like to request a built-in way to set a reject type validation when a value is programmatically set in the Kendo UI Spreadsheet.  Currently, it only sets a warning type as shown in this Kendo UI Dojo.  

Thanks!

When a cell is copied to another cell by using the 'auto-fill' option, the format and validation from the initial cell is applied to the target as well, as described in the documentation.

- https://docs.telerik.com/kendo-ui/controls/spreadsheet/end-user/user-guide#other

I would like the possibility to persist the format and validation of the targeted cell and if for example non-valid data is dragged and dropped in a cell, the content to be rejected based on the targeted cell validation. 

Hi Team,

I would like to request to include the Embed function for the Kendo UI Spreadsheet to include objects such as PDF files into the Spreadsheet. 

Thank you!

Hi Team,

I would like to request the open button for the Kendo UI Spreadsheet's toolbar to fully utilize a Kendo UI Button rather than a native input button.  One benefit would be to help provide a localization message with ease.  

Thank you!

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]

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

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.

Structured references in MS Excel: 

• https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e   

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 .

Hi Team,

Please add the MINIFS function to the Kendo UI Spreadsheet. 

Thank you!

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?

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!

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!