When values in the sheet are updated using the batch method the DataSource does not update according to changes.

Dojo: https://dojo.telerik.com/@iankodj/IRUdufOx

1. Run the example

2. Check the console showing "no data" and an empty array.

Expected: https://dojo.telerik.com/@iankodj/EKoziCic 

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]

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

Bug report

In Spreadsheet, the cell format is lost when you change its value.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/@martin.tabakov@progress.com/EWUdUDUp/2
2. Change the value of cell C3 to 5.5678

Current behavior

The new value is not rounded as per the preset format.

Expected/desired behavior

The new value should respect the format set for the cell.

Environment

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

Bug report

When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.

Reproduction of the problem

1. Go to the Basic Usage example - https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Enter "SS0012" as value in a random cell.
3. Grab the handle at the bottom right of the cell and drag down.

Current behavior

The value entered for the cells below is SS13, SS14 etc.

Expected/desired behavior

The value entered for the cells should be SS0012, SS0013 etc.

Environment

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

Hi,

There are multiple formats for date and time in kendo and in different cultures the count increases. Is there a function in which i pass spreadsheet cell value and format and it returns that it is a date format or number format. I just want to know the type of format so i can parse the dates on my own from json on server side.

Regards,
Faraz

### 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]

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]

Hi Team,

I'd like to request the functionality to be able to filter null and whitespace items more easily with the built-in API for the Kendo UI Spreadsheet. 

Thank you!

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.

Hi there,

I'd love the ability to specify regex validation for the spreadsheet component. I saw a forum post (https://www.telerik.com/forums/spreadsheet-regex-validation) someone else had made relating to this, but couldn't find a feature request made based off of it.

(taken from the post) Ideally it'd look something like this:

var columnSens = spreadsheet.activeSheet().range("A2:A10");

columnSens.validation({
  dataType: "custom",
  from: 'REGEX("^(()|((?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[^\da-zA-Z]).{8,60}))$")',
  type: "warning",
  allowNulls: true,
  titleTemplate: "Invalid Password",
  messageTemplate: "Passwords must be between 8 - 60 characters long and contain the following: 1 number, 1 uppercase letter, 1 lowercase letter, and 1 special (non letter or number) character."
});

Bug report

When trying to select multiple cells in Spreadsheet, an error "n._ref.height is not a function" occurs.

Regression introduced with R3 2021.

Reproduction of the problem

1. Open this demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Try to select multiple cells using CTRL.

Current behavior

An error "n._ref.height is not a function" occurs and cells are not selected.

Expected/desired behavior

No error should occur and cells should be selected.

Environment

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

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.

Bug report

Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/UwexICot/4

Current behavior

The value of the B1:B2 merged cell is not displayed.

Expected/desired behavior

The value of the B1:B2 merged cell should be displayed.

Environment

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

Bug report

Spreadsheet: Improper copy paste to Excel when merged cells are present and one column in the merged cells range is hidden. If the column containing the first merged cell is hidden all the rows on that row will be shifted to the left.

Reproduction of the problem

• Run the following Dojo;
• Select Range A1:D3 (note that column B is hidden)
• Press Ctrl + C;
• In Excel workbook press Ctrl + P;

Current behaviour

After pasting, the merged cell consists of 4 cells, as expected, but the cell data is shifted to the left and the hidden column contains the cell data of the next column

Expected/desired behavior

The cells after the merged cell should not be shifted.

Environment

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