1. The top tab section (with the Home, Insert, Data, Undo, Redo) button of the toolbar should be configurable to be hidden, i.e. "single toolbar" configuration should be supported. Since it is possible to configure the toolbar to show custom items, it should also be possible to hide other tabs and the undo/redo button and only have a single toolbar as the configuration.

/* Style hack to hide the "Home/Insert/Data" tabstrip at the top of the spreadsheet. */
.k-spreadsheet-tabstrip.k-tabstrip {
    & > ul {
        display: none;
    }

    & .k-content {
        border-top: 0px;
    }
}

/**
 * Style hack to hide the undo/redo buttons in the quick-access toolbar.
 */
.k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
    display: none;
}

Set an indicator same way that grid already does but now in sheet cells when a record is 'dirty'.

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

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 .

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.

Hi Team,

Please add the MINIFS function to the Kendo UI Spreadsheet. 

Thank you!

Hi Team,

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

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!

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]

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.

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.

Hi Team,

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

Thank you for the consideration!

Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.

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.

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.