Bug report

If the datasource of a Grid with "autoBind: false" configuration is sorted using the below code, the data sorting in the component is correct but no sorting arrows appear in the headers of the sorted columns.

var grid = $("#grid").data("kendoGrid");
var sort = [{field: "Freight", dir: "desc"}, {field: "OrderDate", dir: "asc"}];
grid.setOptions({ dataSource: {sort: sort }});
grid.dataSource.read();

• This is a regression introduced in version 2020.1.114

Reproduction of the problem

1. Open this Dojo example and run it
2. See the headers of the "Freight" and "Order Date" columns

Current behavior

The sorting arrows are missing for both the "Freight" and "Order Date" columns

Expected/desired behavior

The arrows should appear as shown in the image below. The correct behavior can be observed in this Dojo example

Environment

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

The Kendo Grid has select() method, but is missing unselect() method. I believe that it will be a good and useful addition to the grid.

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]

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?

 

The pager navigation buttons shift position when going from page 10 to page 11 (see paging actual image), because the pager now has to accommodate for the dots at the left side. This is annoying when going through the pages. If the pager would already leave some space for the dots when on page 1 to 10 (see paging desired image), the buttons would be fixed, making the navigation better to use.

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

Reproduction of the problem

1. In the SASS Theme builder, create а theme based on the Default theme
2. Download it and load it on a page with a Grid

 

Current behavior

On desktop there is a page number duplication: screenshot.
On mobile the page numbers disappear: screenshot

Expected/desired behavior

The pager should look like in the Default theme.

Since the 2019 R1 release k-pager-sm (k-pager-lg, k-pager-md) classes are assigned dynamically based on the width of the page to make the component responsive (as I understood from https://www.telerik.com/forums/kendo-ui-grid-pager-not-displaying-properly-in-sass-mode#wn92di5BakmHqrrMfViFxA)

When grids are used on bootstrap tabs (both boostrap 3 and 4) the k-pager-sm class is added incorrectly, causing the pagers on tabs other than the first to be displayed only partially.

A JSFiddle to demonstrate this: https://jsfiddle.net/nqjc4mbu/

The pager on the 1st tab:

And on the 2nd and 3rd tab:

 

(we've solved it with a workaround by dynamically removing the k-pager-sm class again on dataBound, but this shouldn't be necessary)

Dear support,

I've found a bug in kendo ui grid concerning the combination of grouping, multi-column headers and showing/hiding columns. To reproduce the issue, please use the "Multi-column headers" demo on your kendo ui demos page. Now please use the column menu to hide both child columns of the 'Locatiion' column header ('Country' and 'City'). Now please group the data by the column 'Contact Title'. If you now use the column menu to show one of the previously hidden columns (e.g. 'Country'), you will see that it is shown at the wrong position (left site, index 0).

I've attached an image showing the issue.

 

Kind regards

Iggy 

 

 

Starting from a Grid's "endless scrolling demo" on: https://demos.telerik.com/kendo-ui/grid/endless-scrolling-remote

Edit grid configuration to set smaller page size. All items of the first page need to be visible on the screen plus some free space. A grid height needs to be set. See this DOJO: https://dojo.telerik.com/amiNohIx

The vertical scroll bar is disabled and there is no way to get/see next pages of data.

Interesting is that use of the horizontal scrollbar (if one is available) starts some background operation (looks as data page load) and then the vertical scrollbar is OK.

Take this Dojo: https://dojo.telerik.com/iCECeXeC

1. Press 'Run'
2. Remove the filter for Contact Title
3. Press 'Save State'
4. Reload page (F5)
5. Press 'Run'
6. Press 'Load State'

Result: The filter for Contact Title is not removed.

 

On the other hand if I do the following:

1. Press 'Run'
2. Change the filter for Contact Title to 'Sales Representative'
3. Press 'Save State'
4. Reload page (F5)
5. Press 'Run'
6. Press 'Load State'

Result: The filter for Contact Title is changed correctly to 'Sales Representative'

 

Why is the first example not working? Is this intended behaviour or a bug? Is there a workaround?

 

Kind regards.

Hi, 

 

There is a bug on the kendo grid when you have inline editing and a filter applied

So what's happening is that when you apply a filter and then click on "add new record" it doesn't show the new record, even worst it actually add the new empty record in the datasource, so you see new empty line when you remove the filter ....

it's really easy to demonstrate, i make you a dojo : https://dojo.telerik.com/EJIhohuf

this dojo is actually the editing inline demo (https://demos.telerik.com/kendo-ui/grid/editing-inline) with just the filtering enabled like so :

filterable: {
        mode: "row"
    }

to reproduce :

- apply any kind of filtering

- try to add a new record

- here you see nothing is happening, we expect to see a new empty line to add a new record (also the beforeEdit event is not fired but not sure this is a bug)

- remove the filtering

- you can see the empty lines (if click 5 times on add new record you get 5 empty lines)

 

Best regards,

you have a great product hope you can improve it even more 

When resizing column widths have an option to lock the last column to the right hand border of the grid when sum of columns total width is smaller than grid. This way the grid will always fill the columns to the width of grid. For example if user reduces column 2's size in a 3 column grid then increase the size of column 3 so that it keeps the grid full width.

 Instead of this:

 

It would look like this:

 

 

Hi Guys,

I have just tripped over a problem in the 2020 R1 release whereby the sort indicator is not being shown when autoBind is set to false.

To illustrate the problem run the following dojo

    https://dojo.telerik.com/eMELiMut

which will show a sort indicator on the 'Ship Country' column.

Now if you uncomment 'autoBind:true' and 'dataSource.read();' and re-run you will see that although the data is being sorted correctly the 'Ship Country' column is missing the indicator.

Regards
Alan

We have few of dynamically created grid controls. I like to change the grid header style for all of them. I found this solution on the forum however there is an issue with this. If I override ".k-grid-header th.k-header" the change effects column filter popup content as well. See this example on dojo: https://dojo.telerik.com/@ssharifi/AvayONaQ all text and drop down texts are also effected.

I just need to override the title text. What style can I set so the title text is bold but not the filter options?

Thanks,

Shawn

Bug report

Grid's layout breaks when having columns with defined widths which sum exceeds 960px and the scrollable property is set to false.

Regression introduced in 2020.1.114

Reproduction of the problem

Open this Dojo in fullscreen and see Grid's layout.

If you change the Kendo UI version to 2019.3.1023, Grid's toolbar is correct

Current behavior

Grid's layout is breaking

Expected/desired behavior

Grid's layout shouldn't break.

Environment

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

grid column virtualization issue with hidden column.

When you scroll further in your grid having one or multiple hidden column(s) the value of the hidden column appears in a side column.

 

 

<!DOCTYPE html>
<html>
<head>
    <base href="https://demos.telerik.com/kendo-ui/grid/column-virtualization">
    <style>html { font-size: 14px; font-family: Arial, Helvetica, sans-serif; }</style>
    <title></title>
    <link rel="stylesheet" href="https://kendo.cdn.telerik.com/2020.1.114/styles/kendo.default-v2.min.css" />

    <script src="https://kendo.cdn.telerik.com/2020.1.114/js/jquery.min.js"></script>
    <script src="https://kendo.cdn.telerik.com/2020.1.114/js/kendo.all.min.js"></script>
    

</head>
<body>
<div id="example">
    <div id="grid"></div>
    <script>
        $(function() {
            var columns = [];
            var data = [];
            var numberOfColumns = 500;
            var numberOfRows = 100;
            var field;
            var row;
            var i;
            var j;
               
            for (i = 1; i <= numberOfColumns; i++) {
                field = ("Field" + i);
              if(i==2)
                columns.push({ field: field, title: field, width: 200, hidden: true });
              else
                columns.push({ field: field, title: field, width: 200 });
            }
            for (i = 1; i <= numberOfRows; i++) {
                row = {};
                for (j = 1; j <= numberOfColumns; j++) {
                    field = ("Field" + j);
                    row[field] = "R" + i + ":C" + j;
                }
                data.push(row);
            }

           var dataSource = new kendo.data.DataSource({
               pageSize: 10,
               transport: {
                   read: function(e) {
                       e.success(data);
                   }
               }
           });
           
           $("#grid").kendoGrid({
               dataSource: dataSource,
               sortable: true,
               scrollable: {
                   virtual: "columns"
               },
               width: 1000,
               navigatable: true,
               filterable: true,
               columnMenu: true,
               pageable: {
                   refresh: true,
                   pageSize: 10,
                   pageSizes: true,
                   buttonCount: 5
               },
               columns: columns
           });
        });
    </script>
</div>


</body>
</html>

Would it be possible to add an option for a top scroll on the grid?

How to implement SearchRow in RadGrid for ASP.Net similar to SearchRow in WinForms RadGridView

The SearchRow in RadGridView WinForms is extremely good.

https://docs.telerik.com/devtools/winforms/controls/gridview/rows/search-row 

How can we implement the same in Kendo UI RadGrid?