### Bug report

The column menu of the Kendo UI Grid widget with componentType set to 'modern' has missing translations in the default filter menu.

### Reproduction of the problem

1. Create a filterable grid and enable the column menu with componentType 'modern';

2. Include the localization script for "fr-CA" in the document from the CDN;

3. Open the column menu and expand the filter menu of a specified column. The logic operators "And" and "Or" are not translated.

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

### Expected/desired behavior

When the column menu type is set to "modern", the operators of the filter menu should be translated as in the "classic' column menu.

### Environment

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

Hiding the first column in Grid will show a 2 pixels left border instead one.

Dojo Sample to replicate the issue: https://dojo.telerik.com/ubaLiYEN

Steps:

1. Hide the first column (OrderID) from the Column Menu.

2. Notice the doubled left-border on the left hand side of the Grid.

Bug report

In a Grid with virtual row and column scrolling enabled, if there are large number of hidden columns, the horizontal scrolling is very slow.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/EWeVaQOc/12
2. Try to scroll horizontally

Current behavior

Horizontal scrolling is slow

Expected/desired behavior

Horizontal scrolling should be smooth

Environment

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

Bug report

In a navigatable Grid with a custom ComboBox cell editor, clicking the clear button closes the cell instead of clearing the value in the ComboBox.

Regression introduced with 2023.2.606

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/OgEBOGoz/2
2. Edit a cell
3. Click the ComboBox clear button

Current behavior

The cell exits the edit mode when the button is clicked and the value is not cleared

Expected/desired behavior

The cell should remain in edit mode and the value should be cleared

Environment

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

Cannot read property 'groupHeaderColumnTemplate' of undefined.

I have my grid, with 4 columns:

When i grouping for Date field, the browser run this error: 

kendo.all.js:65435 Uncaught TypeError: Cannot read property 'groupHeaderColumnTemplate' of undefined
    at HTMLTableRowElement.<anonymous> (kendo.all.js:65435)
    at Function.each (jquery.min.js:2)
    at I.fn.init.each (jquery.min.js:2)
    at init._renderGroupRows (kendo.all.js:65417)
    at init.hideColumn (kendo.all.js:64983)
    at Function.KendoUtils.hideGridColumns (kendo.utils.js:330)
    at init.dataBound (eval at <anonymous> (jquery.min.js:2), <anonymous>:77:32)
    at d (jquery.min.js:2)
    at init.handlers.<computed> (kendo.all.js:9520)
    at init.trigger (kendo.all.js:124)

Hi, 

Here is the dojo to reproduce. In this dojo I've created imitation of data, that coming from server in our case. The main idea is to have a grid with lazy loading - it has 10 groups (page 1) and after scrolling down it loads 10 more groups (page 2) and etc.

Issue 1. 

After scrolling down, data from the last group is updated with some data, that is not belongs to it. Please see 'Issue1.png' attached.

Issue 2.

Groups from the first page are duplicated after scrolling down. For example, there is a group named 'C3'. After scrolling down, it is duplicated once again. Please see 'Issue2.png' attached. New groups are placed after these duplications. By the way, as groups from the 1st page are duplicated, there is more than 20 groups is shown, but the counted at the bottom of the grid says that '20 of 137' elements are show.

So it would be great, if you could fix that. Or even provide temporary fix for us.

Thank you!

Bug report

In a Grid that has locked columns, if you tab through the content and then tab back using Shift-Tab, the first column is not completely visible when you reach it.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/eKuKoFaN
2. Navigate through the first row using Tab key.
3. Navigate back to the cell in the CustomerID column using Shift+Tab

Current behavior

The column, including the header, is not completely visible.

Expected/desired behavior

The whole column should be visible.

Environment

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

When the grid is configured for InCell editing and frozen columns, it is expected the first editable cell to be opened for editing when a new record is added. 

However, when there is not an editable cell in the locked columns, it would not search in the main content. Here is an example:

https://dojo.telerik.com/ucEraQOW

A temporary workaround would be to override the editModel function and check in the second table as well:

https://dojo.telerik.com/aJEsAnud

Dear Sir / Madam,

At grid PDF export, in case of allPages: false --> Actual rows are rendered to multiple pages properly, but all pages are written on the first page.

It works well, if I set "options.pdf.multiPage" to "true", but it is not in API reference.

A solution might be if this variable is fixed to true in grid prototype "saveAsPDF" function:
          "options.multiPage = true;" instead of "options.multiPage = options.multiPage || options.allPages;"

Please see this example: https://dojo.telerik.com/usUnUziL/2

Step 1: press "Export to PDF" --> Result: wrong pdf

Step 2: press "Set multiPage: true"

Step 3: press "Export to PDF" --> Result: good pdf

Best Regards,

Szabolcs Tóth

If you configure a Kendo Grid with client-side paging, each time you call setDataSource to update the data source then a new .k-pager-numbers-wrap DIV is added to the page controls. I've replicated the problem in Dojo at https://dojo.telerik.com/UTolOzer by taking a basic client-side paging demo, moving the dataSource configuration into a separate function (with data("kendoGrid").setDataSource), and calling that function 25 times. At the end, the source shows the UL element with the page buttons inside 25 .k-pager-numbers-wrap DIV elements.

I first noticed this problem because in my own environment, each nested DIV was shifting the page buttons left 1 pixel and overlapping the "previous page" buttons. In my Dojo example, with 25 nested DIVs the page buttons disappear completely.

I've added the following in my own code as a workaround in the dataBound event of the grid:

                            var trueParent = e.sender.pager.element.find(".k-pager-numbers-wrap").first();
                            e.sender.pager.element.find("ul").appendTo(trueParent);
                            trueParent.find(".k-pager-numbers-wrap").remove();

Enhancement

Excel files generated by Kendo Excel Export cannot be imported by the MS ODBC Driver. The error reported in this forum thread is: External table is not in expected format.

Current behaviour

If the file is opened and resaved with Excel or if the styles.xml file is replaced with any styles.xml generated by MS Excel, the error does not occur. When compared the styles.xml of Excel does not contain a numberFormat, no other obvious major differences at first glance:

E.g.:

<numFmts count="2">
<numFmt formatCode="#" numFmtId="165" />
<numFmt formatCode="#" numFmtId="166" />
</numFmts>

Expected/desired behavior

If possible, modify the styles.xml template to enable seamless use with OleDB

### Bug report

When the adaptive rendering of the Kendo UI Grid is enabled, the filterMenuOpen event is not triggered.

### Reproduction of the problem

1. Set mobile: true.

2. Attach the filterMenuOpen.

Dojo sample for reproduction:

https://dojo.telerik.com/uhiToseD

### Expected/desired behavior

filterMenuInit event should be triggered regardless of the adaptive rendering mode of the grid.

### Environment

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

Disclaimer: I'm running an older version of Kendo UI for jQuery, so this may have been fixed. I'd like confirmation if so before updating.

Kendo version: 2017.1.118.545

I am creating a grid from a table data source rather than an endpoint call. Other pages that use endpoints to populate the datasource export Excel with no problems.

Example HTML:

<table class="table table-responsive" id="tblReportSummary">
<colgroup>
<col />
<col />
<col />
<col />
<col />
</colgroup>
<thead>
<tr>
<th data-field="date">Date</th>
<th data-field="totalForStatus">Count</th>
</tr>
</thead>
<tbody>
@foreach (var item in ViewBag.ReportDataSummary as IEnumerable<UtilizationListViewModel>)
{
<tr>
<td>@item.Date</td>
<td>@item.TotalForStatus</td>
</tr>
}
</tbody>
</table>

The jQuery is as follows:

             $("#tblReportSummary").kendoGrid({
                sortable: true,
                toolbar: ["excel"],
                excel: {
                    allPages: true,
                    fileName: "Utilization Data Export.xlsx"
                },
                pageable: {
                    pageSize: 20,
                    pageSizes: [20, 50, 100]
                }
            });

When I click Export, all I get is an empty Excel file.

Why isn't the data there, please?

Bug report

The following article shows how to set the cells font size to 30: https://docs.telerik.com/kendo-ui/knowledge-base/grid-excel-export-custom-font. Up to R1 2019 the font size was properly exported. Since R1 2019 the font size in the generated Excel file has a wrong value.

Reproduction of the problem

1. Export the Grid
2. Open the generated Excel file.

Current behavior

Font size is 22.5

Expected/desired behavior

Font size is 30

Environment

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

Bug report

Ticket ID: 1472456

Reproduction of the problem

[Dojo]

Current behavior

Using the setOptions() method in an MVVM bound grid causes 2 read requests

Expected/desired behavior

A single request should be issued.

Workaround

programmatically remove the kendo binding from the element before calling the `setOptions()` method.

   grid.element[0].kendoBindingTarget = null;
   grid.setOptions(options);

Environment

Kendo UI version:** 2020.2.617

Bug report

When there is horizontal scrolling in RTL Grid, the scroll starts from the last column, instead of the first one.

Reproduction of the problem

1. Open the following Dojo example - https://dojo.telerik.com/oJataqac
2. Observe the scroll of the RTL Grid

Current behavior

The scroll starts from the last column.

Expected/desired behavior

The scroll should start from the first column.

Environment

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

Bug report

Remote data source is not correctly "in sync" when page up/page down buttons are used in Grid with Endless scrolling of remote data

Expected/desired behavior
Endless scrolling shall behave as when the mouse scrolling is used

Environment
Kendo UI version: [all]
jQuery version: [all]
Browser: [all] 

Bug report

The row reordering functionality does not work correctly when the draggable column has a small width.

Reproduction of the problem

https://dojo.telerik.com/@user192/ipOyacoH

Open the Dojo and try to reorder a row. The icon inside the hint will keep changing and in some cases you won't be able to drop the row to the expected position.

If you move the hint a bit to the right(towards the next column) this behavior disappears.

Current behavior

The reorder hint shimmers and in some cases does not allow for reordering. This occurs when the column width is small(30px in the example).

Expected/desired behavior

Reorder should work as expected, regardless of the column width.

Environment

• Kendo UI version: 2022.2.621
• jQuery version: 1.12.4
• Browser: [all]

Hi team,

To reproduce that, go to https://demos.telerik.com/kendo-ui/grid/persist-state

- first, inspect the TH element of the "Contact Name" column, no headers attribute. (screenshot 1)

- then click on "Save State" button and click on "Load State" button.

- now, inspect again the TH element and you will find the attribute "headers"="undefined", on each column actually. (screenshot 2)

Not a big deal but this makes an entry (serious) with the Axe plugin accessibility checker.

Please advise and propose a workaround if any.

Best regards,

Laurent.

Bug report

The icons for 'Move previous' and 'Move next' in the 'Set Column Position' ColumnMenu item in RTL Grid are not correct.

Reproduction of the problem

1. Open the Dojo example - https://dojo.telerik.com/arOKEreq
2. Open the column menu of a random column.
3. Expand the 'Set Column Position' item.

Current behavior

The previous and next icons do not correspond to the correct direction.

Expected/desired behavior

The positions of the previous and next icons should be switched.

Environment

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