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
- Export the Grid
- 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?
### 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
- In the SASS Theme builder, create а theme based on the Default theme
- 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:
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>
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?
In the popup edit grid, when the editable: false option is displayed, the portion of the value is at the top rather than horizontal. Can you change it horizontal?
Bug report
When the horizontal scroll of the grid is shown and is configured for RTL, the resize handle is mispositioned.
Reproduction of the problem
1. Make the grid scrollable and set explicit widths to all columns.
2. Make the grid RTL.
3. Introduce multi-column headers.
4. Notice that the columns cannot be resized due to the disposition of the handler.
5. Dojo for replication:
https://dojo.telerik.com/IZInOVUd
6. Notice that whenever the horizontal scroll is not present, the resize handle is positioned correctly.
Environment
* **Kendo UI version:** 2019.3.1023
* **jQuery version:** 1.12.4
* **Browser:** [all]
Hi,
the adaptive rendering in the grid control is not working in the current version(2019.3.1023).
To reproduce go to https://docs.telerik.com/kendo-ui/controls/data-management/grid/appearance/adaptive#configuring-panes-on-mobile --> Open in Dojo --> Run and the 2 rows are not displaying. If you switch to version, choose Library dropdown, 2018.3.1017 or up to 2019.1.220 the 2 rows are ok.
Similar behaviour is inspected to the scheduler control agenda view. To reproduce go to https://docs.telerik.com/kendo-ui/controls/scheduling/scheduler/adaptive-rendering#configuring-panes-on-mobile --> Open in Dojo --> Run --> change view from week to Agenda and the 2 events are not shown. If you switch to version, choose Library dropdown, 2018.3.1017 or up to 2019.1.220 the 2 events are ok.
Tried in chrome, safari and mobile phones.
thanks,
Kostas Vlachakis