This is observed also in online demos:

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

Steps:

1. Open demo
2. Edit a cell and enter text
3. Press Alt+Enter and enter more text
4. Press Alt+Enter
   
   Result: the last letter of the row is transferred to the new row

Hi Support Team,

When select multiple cells continuously and right click, it will have more options. But when select multiple cells without continuously and right click, there is only 1 option

Would like to have a feature to have more options when select multiple cells without continuously and right click and also to able to detect which cells are selected if multiple cells are selected without continuously.

Select multiple cells continuously:                                   Select multiple cells without continuously:

### Bug report

When the property "useCultureDecimals" is enabled in a culture where the decimal separator is the comma, the function Text() does not format numbers correctly.

### Reproduction of the problem

1. Set a culture where the decimal separator is the comma (i.e. "da-DK");

2. Create a Spreadsheet and enable the property "useCultureDecimals";

3. Enter a number with a decimal separator comma (i.e. "0,1141");

4. Format the cell by using the Text() function ( =TEXT(A1; "##0,00%") );

5. The number is not formatted properly - "011%"

A Dojo sample for reproduction: https://dojo.telerik.com/AsiLiKil/12

### Expected/desired behavior
"0,1141" should be formatted as "11,41%" as in Excel.

### Environment

* **Kendo UI version: 2021.3.914
* **jQuery version: 1.12.4
* **Browser: [all]

I have a first example using the Kendo Toolbar widget and I was able to get an Angular button rendered in the toolbar:
http://dojo.telerik.com/ucIfin
When I tried to do the same thing in the Kendo Spreadsheet widget toolbar, it failed to compile my template:
http://dojo.telerik.com/UseWI

In general Angular directives are not compiled properly when specified in the template of a Spreadsheet Toolbar item.  I am aware of a workaround for the kendo-button specific case, but I would like the template to work for custom Angular directives as well.

Presently in Spreadsheet tooltip is not working for filter applied range 
so tooltip should display for each cell in which the range of filter is applied

Right now, a List based validation is strict on case, it'd be nice to have a toggle for when it is appropriate.

Add menu item that allows end users to style background and text color based on rules (if cell value > 0 then green)

Add a watermark in each worksheet.

I know it seems like a small thing, but I work with complex spreadsheets, and supporting coloured sheet tabs would really help 
Love this control.

Hi Progress - just some quick feedback: 1. Telerik Control Panel updates - it feels like a lot of the time, when the TCP needs updating the user has to manually uninstall the old version and the install the new one using the .exe installer. If the TCP could automatically handle this process, that would be appreciated. 2. The various Telerik Spread Processing libraries (and other document processing libraries) can only be installed as an included component of the Telerik "UI for X" library installations. It would be great if there was an option in the TCP to do a standalone installation of just the Spread Processing libraries. Thanks and kind regards, - Lawrence

Bug in js\spreadsheet\numformat.js makeDateFormat

You appear to be using the wrong indices inside a nested loop.

if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {

Should be (switch i to j)

if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {

Getting error

Uncaught TypeError: Cannot read property 'type' of undefined
     at Object.<anonymous> (numformat.js:630)

Note: Version is actually 2018.3.1114 from npm

We are using the Kendo UI spreadsheet in a real-world website. We have a design team who are providing a visual design which fits in with our company's corporate standards.

HTML5 aims at separating styling from the layout design, which enables different teams to build the syle, with very little development experience, but more artistic experience.

For some reason, the Spreadsheet control can only be styled via the API (javascript code)! This means our design team needs to write their style in javascript, which is completely unrealistic.

It should be a fairly simple change to allow a range object to have a CSS class associated, and let HTML work like it should.

I need the way to get a user the opportunity to set the columns headers. Moreover, the columns headers should be saved separately from the main spreadsheet data.

Of course, the possible variant is to have two spreadsheets: the one – for the data, the second (with one row) – for the headers.

But the better way is to get a user the opportunity to set the spreadsheet columns headers.
It would be ideally if a user could change “A”, “B”, “C” for “ID”, “Product”, “Quantity” …
Not to have a first row for headers, but change the spreadsheet columns headers!
Moreover, we have the context menu on the columns headers and it is possible to add one more item “Edit” in it.

The spreadsheet doesn't provide any configuration options for the font size unit; it is always in pixels. I need to be able to specify other CSS units, such as points or ems.

This will help doing data entry in column for scenarios like entering tax details for different years in columns and also user can keep on entering new year info in rew-row right most column.

It would be great if there is a cell (and column) type that lets you choose from a defined list (manually defined list or based on a cell-range). It should be possible to make multple selections and the output should be put into the cell separated with semi-colons.