There's a discrepancy between the header and rest of the rows when the selected rows are coppied and pasted in Excel.

Bug report

When using specific themes for a scrollable Kendo UI Grid which have long titles within the column header, the sort icon are partially shown or not shown.

Reproduction of the problem

1. Please check out this Progress Kendo UI Dojo
2. Sort the first column

Current behavior

The sort icon is not shown upon sorting.

Expected/desired behavior

The sort icon should be shown as expected with every theme.

Environment

• Kendo UI version: 2021.3.1109
• jQuery version: 3.6
• Browser: all

Hi Team,

I would like to request the functionality to easily modify group and sub group headers with specific templates for aggregation, and have it built-in to the API.  For example, the group header could contain the total within the large group, and the sub group would contain each individual section.  Additionally, it would be nice to be able to reference each to better select each section.

Thank you!

You guys do such a great job of allowing us to extend your product for our needs. And I know that you have recently added the Search Panel to allow us to perform a search against the dataSource. However, I would like to put that search box/button somewhere else completely on my page.

I've been able to get around this by using the code in kendo.grid.js to use my own click/keypress events to invoke the filter based on the new search options.

configureSearch(inputSelector: string, clickSelector: string) {
    const searchFn = this.search;
    if (this.grid.options.search == null) {
        throw "search field(s) not set for grid.";
    }

    const inputElement = $(inputSelector).keypress(function (this: HTMLElement, e) {
        const keycode = (e.keyCode ? e.keyCode : e.which);
        if (keycode === 13) {
            searchFn($(this));
        }
    });
    $(clickSelector).click(e => {
        searchFn(inputElement);
    });
}
private search(inputElement: JQuery<HTMLElement>) {
    const options = this.grid.options;
    const dsOptions = this.dataSource.options as kendo.ui.GridScrollable;  // HACK: dataSource.options isn't really a GridScrollable, but it's similar
    let searchFields: string[] | any = options.search ? options.search.fields : null;
    let expression: kendo.data.DataSourceFilters = {
        filters: [],
        logic: "or"
    };
    const value = inputElement.val();
    if (!searchFields) {
        searchFields = getColumnsFields(options.columns);
    }
    // NOTE: Thankfully we don't use endless
    if (dsOptions.endless) {
        dsOptions.endless = null;
        //(this as any)._endlessPageSize = this.dataSource.options.pageSize;
    }
    if (value) {
        for (let i = 0; i < searchFields.length; i++) {
            expression.filters.push({
                field: searchFields[i],
                operator: "contains",
                value: value
            });
        }
    } else {
        expression = {};
    }
    this.dataSource.filter(expression);

    // from Telerik:
    function leafColumns(columns: kendo.ui.GridColumn[]): kendo.ui.GridColumn[] {
        /* Hiding ... go see Telerik source code */
    }
    function getColumnsFields(columns: kendo.ui.GridColumn[]): string[] {
        /* Hiding ... go see Telerik source code */
    }
}

Hi Team,

I would like to request the Kendo UI Grid to allow virtual scrolling with smaller pagesizes.  I understand right now it is a limitation, but I would like to see this functionality in the future if possible.

Thank you!

Hi,

The buttons And/Or in the column menu filter are not translated. They are in English even if the language is set to Swedish.

This is only when componentType is set to "modern". When it is set to "classic" the button language is correct.

See Dojo and attached screenshots.

Untitled | Kendo UI Dojo (telerik.com)

Hi Team,

I would like to request to set the Grid's toolbar overflow to visible or a way to modify it's configuration within the API rather than it's current configuration to allow Kendo UI Menu items and other dropdown components from hiding behind the Grid body. 

For now, I'm using the following:

          .k-grid-toolbar {
            overflow:visible;
        }

Thank you!

We are using the functionality included with the grid (mvc and .net core) to save and set filters, sorts and groupbys.  Where the functionality fails is if the grid or columns change in any way (including toolbars).  the getoptions() and setoptions() is a snapshot in time and is not very adaptive.  Our users had 1000's of saved grids and was really not allowing us to change the grid data or columns or even change the default order of the columns.  What we ended up doing to allow the saved grids to work and the developers to have the freedom to change the grids was:

1.  Getting the grid that is passed down to the screen and saving it for a clear functionality (and knowing what the default was supposed to be).

2.  Looking at the sort, groupby and filter subcomponents of the saved grid objects by column and looking for a column match in the grid that was passed to the screen.

3.  If a column in the saved grid does not exist, do not apply those filters, sorts and groupby's and alert the user

4.  Only apply/change the filters, sorts and groupbys via a setOptions() on the grid that is passed down as opposed to a set of the entire object.

6.  If a column is added to the grid alert the user that the column is added

7.  If the grid has changed, use a getOptions() to resave the users selections with the modifications above

8.  Load the data 

We have javascript that does the column compare, with differences in the grid if your developers would like to see how we solved this issue. 

Hi Team,

I would like to ask for the functionality to access the worksheet tabs to be able to format/change the contents of them.  I understand the title can be set, but I would like to be able to change the background color.

Thank you!

Create grid as groupable and try to set column title as "<span class='glyphicon glyphicon-cloud'></span>"

$("#grid").kendoGrid({
  groupable: true,
  columns: [{
    field: "name",
    title: "<span class='glyphicon glyphicon-cloud'></span>"
    //, groupable: false
  }, {
    field: "age",
    title: "Age"
  }]  
});

Expected result - column title as glyphicon glyphicon-cloud but actual is wrong

To fix the problem - set up column as groupable: false (just uncomment) and title will be ok

But if I want to use such title and groupable: true - I cannot

Full example:

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8"/>
    <title>Kendo UI Snippet</title>

    <link rel="stylesheet" href="https://kendo.cdn.telerik.com/2021.3.914/styles/kendo.default-v2.min.css"/>

    <script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
    <script src="https://kendo.cdn.telerik.com/2021.3.914/js/kendo.all.min.js"></script>
  <!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

</head>
<body>
<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  groupable: true,
  columns: [{
    field: "name",
    title: "<span class='glyphicon glyphicon-cloud'></span>"
    //, groupable: false
  }, {
    field: "age",
    title: "Age"
  }]  
});
</script>
</body>

and on dojo: https://dojo.telerik.com/EWUnarUf/2

Hi Team,

I'd like to request the functionality to include event handlers and/or functions with the kendo.Stringify() method.  I understand event handlers are not included in JSON.stringify, but I would like to ask for future implementation from Kendo to be able to include them. 

Thank you!

Hi Team,

I'd like to request the functionality to include the input value within a Kendo UI Grid's search panel within the getOptions method.  This would allow for the search panel's input to be populated with the loaded state.  

Thank you!

The Kendo Grid multi checkbox filter has the same sort order as the column it belongs to.  There is a example of how to correct that and provide a sort here:

https://docs.telerik.com/kendo-ui/knowledge-base/sort-multi-checkbox-filter

Hi Team,

I would like to request your consideration to add support for date fields to be filtered via the Kendo UI Grid's search panel when utilizing server operations.  I understand currently this is a limitation but would like this to be incorporated in future releases. 

Thank you!

Hi Team,

This may be more of a bug, but kendo grid's copySelectionToClipboard and exportSelectedToExcel doesn't work with multi column headers. Unfortunatley for us, our grid completely configured with muktiple multi-column headers. Please look into this.

Thanks,

Indu

The problem can be observed in the following Dojo:

https://dojo.telerik.com/UHAdoNIL 

The filter row appears on top of the Sticky Column.

Hi All,

We are facing a weird issue in kendo grid when both group paging and virtual scrolling are enabled for local data. Please see https://dojo.telerik.com/ICoDAleN/2 as example.

Steps to reproduce:

1. Run the code from https://dojo.telerik.com/ICoDAleN/2.

2. Try to group "DateTime" column by drag and drop to grouping header

3. After "DateTime" column is grouped, then un-group it by click cross icon of DateTime button.

4. Now you try to scroll down the grid, until ID column reach around 40, you will see the ID will jump back to around 0, and you will never see the rows which IDs are greater than 40.

5. If you open Developer Tools of browser, you will see following errors.

6. If you group other columns, for example, group "Subject" column, and then un-group it, then scroll down the grid, you will not see this issue.

How to fix it? is there any workaround?

Thanks,

David

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

### Bug report

When the column menu of the Kendo UI Grid widget with componentType set to 'modern' is used in a hierarchical grid, it expands behind the bottom of the page.

### Reproduction of the problem

1. Use the detail template feature of the Grid to create a child Grid;

2. Enable the "columnMenu" in the "modern" render mode;

3. Expand the last row and open the column menu;

4. Expand the filter menu. It is partly hidden.

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

### Expected/desired behavior

The  "modern" column menu should be rendered as the "classic" column menu - its position should be changed based on the available space.

### Environment

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