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

Hi Telerik Team,

We are using latest version (2022.1.412) of the Kendo jQuery tool set. The latest version of Kendo jQuery is using one of the older version of jszip 2.6.1, which is being tagged a vulnerable by our scanning tool. Can you please upgrade the version of jszip in your latest Kendo jQuery (KendoUIProfessional and Telerik.UI.for.AspNet.Mvc5)  

It is possible to add new inline rows to grid even though they are not valid. 

Steps to replicate in attached dojo:

https://dojo.telerik.com/oJEMAPoJ

1. Apply any search in search panel

2. Click Add New Record (one or mutiple times)

3. Click SaveChanges

4. Delete search phrase

The result is that new rows have been added with empy ProductName column, which supposed to be required.

Hello again Kendo Support,

I believe I have found a bug with the kendo grid when using column virtualization. When turning on selectable rows, row selection is lost upon horizontal scroll. The bug can be easily reproduced using the following sample: https://dojo.telerik.com/osUKOZol

Is there any work around or plans to fix this bug in the future? Turning on virtual columns was a performance boost for our application and we'd hate to have to turn it off. 

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]

Bug report

Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.

Reproduction of the problem

Issue 1

1. Open the Spreadsheet Index demo on a Microsoft Surface device.
2. Click in a cell and try to drag the selection to select multiple cells

Issue 2
In the Spreadsheet Index demo select a column. Try to place the mouse in between columns for the icon to be changed and to will be able to resize the column.

Current behavior

Currently, the selection in the Spreadsheet could not be expanded to multiple cells and the columns could not be resized when the Spreadsheet is used on a Microsoft Surface device.

Expected/desired behavior

The Spreadsheet should allow selecting multiple cells and resizing columns when opened on a Microsoft Surface device.

Environment

• Kendo UI version: 2022.2.510
• 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

Hello Telerik Team,

we at COPA-DATA have a supposed problem with the results of the Whitesource Scanner.

According to Whitesource the Kendo UI LIbrary is including a Sub Library called "DocSuitePA".

According to Whitesource this is the Library Owner:

This Library is released under "European License 1.2" terms, which means for us a commercial distribution is not possible.

Could you please verify if this is a false / positive of the White source scanner or if this is an real issue inside the KendoUI Library.

Best Regards

Reinhard Mayr

It would be nice if tasks could be added to gantt that are missing a start date, end date or both dates.

For our use case this feature is not only useful, but mandatory. We are visualising a project workflow that goes through several phases and steps. Within our application, the client fills in the dates for these tasks and milestones as the project progresses. Not all dates are filled-in at all times, however when a project manager creates a gantt chart, he wants to see all the tasks. A task without a date is an information in itself. 

Currently we have to create a fake date entry for tasks without dates.

Bug report

The floating label overlaps the value of the Textbox when it is set programmatically.
Workaround: https://dojo.telerik.com/iWOxEweJ

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/EfiTuNIP/2

Current behavior

The floating label is placed over the text and the latter becomes unreadable.

Expected/desired behavior

The floating label should be displayed over the input field.

Environment

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

The DataBound event fires for each node that has children, but does not fire for the bottom-level nodes.  This is the same behavior as the hierarchical data source Change event.  It fires for each datasource level, which includes a parent and its children, but does not fire for the children unless they also have children.

Since there also is no event that triggers when the entire tree is loaded, there is no good way to perform an operation on each TreeView node after the TreeView is refreshed.  The only way is to traverse the tree after using a timeout to wait for the datasource to load.  This is a brittle arrangement.  Incident 1041348 provides a test case for this scenario.

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]

Reproduction of the problem

https://dojo.telerik.com/AGaceyAD

Current behavior

Tabs exceeds parent container.
https://www.screencast.com/t/H4lCTxwwr

Expected/desired behavior

Tabs should wrap to the next row.

Environment

• theme: less themes
• Kendo UI version: 2022.2.510
• Browser: all