Hi Team,

When I add comments to enabled columns(product)it is allowing me to add and after reopening the comments it is retained. But when I add comments to disabled columns(ID) it is not adding to it and no messages are added like it is disabled and comments are not allowed.

demo: https://dojo.telerik.com/ISIvATiN

thanks.

Describe the bug

To reproduce
Steps to reproduce the behavior:

1. Go to https://dojo.telerik.com/avuXEJUV/2
2. Scroll the Spreadsheet horizontally to the "J" column.
3. Click the header of the "J" column to select it.
4. Activate the "Freeze Panes" tool from the toolbar.
5. The Spreadsheet re-renders. The scroll bar does not scroll the columns past "G". A browser scrollbar appears. Use it to scroll horizontally beyond the right border of the Spreadsheet. Some of the columns are displayed outside the Spreadsheet. Once they are visible, scroll horizontally to the far right using the Spreadsheet scrollbar. Column A is duplicated after column AX.

Expected behavior
The panes are frozen without breaking the layout of the Spreadsheet and without cells/column duplication.

Affected package (please remove the unneeded items)

• theme-default
• theme-bootstrap
• theme-material

Affected suites (please remove the unneeded items)

• Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

• All

Build system information (please remove the unneeded items)

• Not Applicable

Additional context
Add any other context about the bug.

Scrolling to a column that is not visible initially and using the Freeze Panes tool, makes the scrollbar of the Spreadsheet unusable. This valid for both horizontal and vertical scrolling. It is observable in the demos: https://demos.telerik.com/kendo-ui/spreadsheet/index

Scroll right to the "R" column. Select it and click on the the "Freeze panes" tool in the toolbar.

Alternatively, scroll down to row 30. Select a cell and click on the the "Freeze panes" tool.

As a result, scrolling the columns (respectively the rows) becomes impossible.

Consider a way to enhance the Freeze panes functionality, so that is is usable in these scenarios.

The spreadsheet currently relies on the <v> tag and doesn't accept cell type "inlineStr". Here is an article with more info regarding the inlineStr type:

https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_c_topic_ID0E1XM4.html 

A cell of type "inlineStr" which is currently not accepted in SpredSheet

<c r="F2" s="4" t="inlineStr">
        <is>
          <t>1005131528</t>
        </is>
      </c>

while the format saved from excel is accepted:

<c r="F2" s="2" t="s">
        <v>12</v>
      </c>

Ticket ID: 1517963

Bug report

When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget

Reproduction of the problem

1. Run this dojo
2. Note the space below the horizontal scrollbar:
   

Expected/desired behavior

The horizontal scrollbar should be adjusted to the bottom of the widget.

As a possible workaround, when hiding the Sheetsbar add the following styling:

<style>
    .k-spreadsheet-sheets-bar {
      padding: 0;
      border-style: none;
    }
</style>

Environment

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

Bug report

When you copy a formatted cell with value "0", pasting the content in the Spreadsheet results in an incorrect value in the formula input.

Reproduction of the problem

1. Open the attached file in the Spreadsheet.
   CopyPaste-CellFormatIssue.xlsx
2. Open the attached file in Excel.
3. Copy the content from C3 to C5 and paste it in the Spreadsheet.

Current behavior

The value of the cells containing "-" are incorrectly changed to "-" in the formula bar.

Expected/desired behavior

The value of the cells containing "-" should remain "0" in the formula bar.

Environment

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

When there is formatting and decimals are rounded negative numbers that round to zero show a negative sign. In Excel those are shown without the negative sign. 

Dojo example: https://dojo.telerik.com/@iankodj/azEMIRUv/21

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

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]

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!

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]

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]

Hello

When we have filtered rows in a spreadsheet (some rows are hidden) and we copy a single cell and paste into a range containing the hidden rows....

The spreadsheet copies the value into all cells in the range including those that are hidden.  This is not the same functionality as Excel.

That said, is the any way to skip hidden cells in the paste range?

Is there a way to override the Kendo past function to do this?  Can you provide an example?

Thank you

Jeffrey Suffet

Bug report

When pasting content to a Spreadsheet that has only one column(columns: 1), the data is not pasted in the targeted cell and a JS error appears in the browser's console.

The issue appears only in scenarios where the columns configuration is set to 1.

• The reported behavior is a regression bug introduced in 2021 R1 SP1 - version 2021.1.224
  Here is a Dojo example with 2021 R1 in which the described above issue is not replicable.

Reproduction of the problem

1. Open this project and run it
2. Copy random text
3. Select a random cell(do not double click the cell) and press Ctrl + V to paste the copied content

Current behavior

No data is pasted in the selected cell and the below error appears in the console:

Expected/desired behavior

The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.

Environment

• Kendo UI version: 2022.1.301
• jQuery version: x.y
• Browser: [all]