Bug report

When defaultCellStyle is used the configured font is applied to the cells in the Spreadsheet. However, the font is not applied when adding new rows.

Reproduction of the problem

1. Open the Dojo.
2. Enter some text in the cells
3. Insert a new row
4. Enter text in the newly inserted row.

Current behavior

The configured font in the defaultCellStyle is not taken into account. The font in the newly inserted row is Arial 12, while in the example it should be 'Courier New' 18.

Expected/desired behavior

The font configured by using the defaultCellStyle option should be applied to all cells in the Spreadsheet, even if inserted after initialization.

Environment

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

Bug report

When MultiSelect is used inside Grid columns filter, it is closing immediately after clicked in the MultiSelect filter input.

Reproduction of the problem

1. Open the Knowledge Base article - https://docs.telerik.com/kendo-ui/knowledge-base/multiselect-used-for-column-filtering
2. Click on the 'Name' column filter icon to open the filter popup.
3. Click in the MultiSelect input filter.

Current behavior

The filter popup is closing first time when clicked. Next time when the filter popup is opened it is not rendered properly.

Expected/desired behavior

The filter popup should not be closed when clicking in the Multiselect filter input. The MultiSelect list items should be rendered below the filter input.

The issue is a regression introduced in 2022.1.301 with the following commit telerik/kendo@bb73744

Environment

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

Hi,

I would like to report a bug with Spreadsheet control. The problem is when trying to import from JSON data into a specific sheet and there are more than 200 rows for import.

If number of rows to import is up to 200, it works correctly, but if number of rows is 201 or more, import is not correct - data starts to import into new columns.

See this simple reproduction: https://dojo.telerik.com/IFuxijEZ/2

Bug report

When there are items selected in the MultiSelect and the close icon is clicked the popup is opened for a moment

Reproduction of the problem

1. Open the Demo - https://demos.telerik.com/kendo-ui/multiselect/index
2. Click the close icon in the first MultiSelect

Current behavior

The popup is opened for a moment

Expected/desired behavior

The popup should not get opened unexpectedly.

The issue is a regression introduced in 2022.1.412 version with the following commit - telerik/kendo@7953a90

Environment

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

Bug report

If the read() method of the data source of the TreeList widget is called, the pager is not refreshed. It retains the only pages and information.

Reproduction of the problem

1. Update the data source of the TreeList widget.

2. Notice that the pager is not completely refreshed.

A Dojo sample for reproduction:

https://dojo.telerik.com/aHIPUgIz

Expected/desired behavior

Refresh the pager whenever the data source of the TreeList is refreshed.

Environment

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

Reproduction of the problem

The height of the TextBox is too small when using a LESS theme

Current behavior

Open the TextBox demo and use the Default LESS theme
The height of the widget is too small:

Expected/desired behavior

The height should be the same as the one used in the SASS themes.

Environment

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

### Bug report

The Grid is filtered initially and no records are displayed. When a specified filter is cleared through the column filter menu, the column with the checkbox filter menu does not show any checkboxes and there is an error in the browser console.

### Reproduction of the problem

1. Create an initially filtered grid and enable the checkbox-filter menu on the first column.

2. When the grid is loaded and no records are displayed (based on the applied filters), clear any of the filters manually through the column menu.

3. Click on the column menu of the first column.

4. An error is logged in the browser console. The checkbox-filter menu contains no options, but the column has data.

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

### Expected/desired behavior

The options in the checkbox filter menu should be loaded properly when any column filters are reset.

### Environment

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

When the autofitcolumn method is used together with multi-headers and hidden columns, some of the columns are either not visible at all or shrunken.

The problem can be observed in the following Dojo:

https://dojo.telerik.com/EJezUyeg 

The CompanyName column should be visible, however it is not. If the example is ran in fullscreen, the column will be visible, however it will shrink if the Browser window gets smaller.

The current version of Kendo UI no longer allows you to align column headings as described in the demo https://demos.telerik.com/kendo-ui/grid/cell-alignment

It occurs because a nested tag (k-link) is set as display: flex;

You can see an example of it on your own demo site (link above) - Ship City header should be centered but isn't.

{
    field: "ShipCity",
    title: "Ship City",
    headerAttributes: { style: "text-align: center" },
    attributes: { style: "text-align: right" }
}

Bug report

A js exception is thrown on selecting a row with the select method, when the Grid's scrollable option is disabled. The exception started appearing since R3 2020 SP1.

Reproduction of the problem

1. Go to: https://dojo.telerik.com/adExIfAp/6
2. Run the example

Current behavior

A js exception is thrown on calling the select method.

Expected/desired behavior

No exception is thrown.

Environment

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

Hi,

I seem to have unearthed a bug in the Kendo spreadsheet control. When the spreadsheet has only 1 row and there is column validation somewhere on the sheet, if I then edit a cell (without validation), 8 rows are created.

See the following Dojo

Kendo UI Snippet | Kendo UI Dojo (telerik.com)

Steps to reproduce.

1. Run the Dojo

2. Edit the UnitPrice cell to, say 20

3. Save changes

4. Observe in the browser console (F12) 8 rows created.

Expected results are 0 rows created and 1 updated

Thanks

Ian

### Bug report

When reordering expanded rows, the "rowReorder" event does not return a correct "oldIndex".

### Reproduction of the problem

1. Create a hierarchical grid and enable the reorderable.rows property;

2. Expand all rows;

3. Handle the "rowReorder" event and log the event data in the browser console;

4. Move the second row above the first row. The property "oldIndex" returns a wrong value. It should be "1".

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

### Expected/desired behavior

The "rowReorder" event of the grid should return the correct indexes of the moved row.

### Environment

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

Bug report

When ToolBar with buttons is initialized in kendo.mobile.Application an error Maximum call stack size exceeded is thrown in the browser console

Reproduction of the problem

1. Open the Dojo example.

Current behavior

Currently, Maximum call stack size exceeded is thrown in the browser console

Expected/desired behavior

There should be no errors in the browser console when initializing a Toolbar in the mobile Application. - Working Dojo

The issue is a regression starting with 2022.1.119, introduced with commit: telerik/kendo@b728b2b

Environment

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

Hi, I'm using the spreadsheet control and i'm having an issue with date columns.

When I enter a valid date, it works fine.

but when I enter an empty date (clicking delete on date column, or emptying out the contents)

the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]

obviously, this is incorrect, and it should store the value as NULL.

it happens regardless of whether the schema/model has nullable=true.

If I manually modify the dataItem via JS, it stores it correctly as null. 

I have a dojo demo set up which replicates the issue.

https://dojo.telerik.com/oFowivUN

Steps:

1. select the ItemDate column of the first row in the spreadsheet
2. type in a valid date (e.g. 1/1/2020)
3. Click View ItemDate button (It should show the correct date)
   
4. Select the ItemDate column and empty it out (e.g. click delete)
5. Click View ItemDate button. (it should now show the incorrect date!)

Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.

Thanks

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]

Use case:
My app doesn't know how many rows of data the excel spreadsheet will be prior to upload.  I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others.  The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition.  

As a workaround, I'm destroying and reloading the widget instance after the initial load.

The API docs for CheckboxGroup (https://docs.telerik.com/kendo-ui/api/javascript/ui/checkboxgroup/methods/value) states: "If passing an empty array, the value of the widget will be reset and the checked state will be removed from the selected checkboxes." But if you do this, it does NOT clear out any selections.

Code demo: https://dojo.telerik.com/IJOtaReh

Code snippit:

<ul id="checkboxgroup"></ul>
<script>
    $("#checkboxgroup").kendoCheckBoxGroup({ items: [ "one", "two", "three" ] });
    var checkGroup = $("#checkboxgroup").getKendoCheckBoxGroup();
    checkGroup.value(["two", "one"]);
    checkGroup.value([]);
</script>

Bug report

A Tooltip that fetches its content using AJAX request doesn't render a loading icon while waiting for the response.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/@martin.tabakov@progress.com/onUlEMiT/5
2. Hover the images.

Current behavior

Issue 1. No loading icon is rendered.
Issue 2. The Tooltip doesn't render until the response from the server arrives.

Expected/desired behavior

The Tooltip should render immediately with a loading icon until the response from the server arrives.

Environment

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

The grid does not have a auto generated Serial Number or Row number column built in. Although this functionality can be custom built, but I feel this is a basic thing and when you have to use the grid in different places in your program, then duplicating the same code for a simple functinoality sounds over killing and maintenance overhead.