the Kendo grid does't accept cell value changes when using android mobile phone with the Chrome browser. You can test it on the telerik demo https:demos.telerik.com/aspnet-mvc/grid/editing.
for example change the value of the Unit Price and go to the other cell. you will see that the value will become the original value.
just by touching some where outside the border of the grid the value will change.
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!
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:
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
At the moment only the Kendo UI Grid with enabled mobile option will generate a header which can react to the touch and hold gesture.
This makes column resizing impossible when a web grid is used on mobile/tablet. Can you check internally if the grid is used on a mobile browser and create the mobile headers that work with the touch and hold gesture even when the grid does not have the mobile property enabled. This should work out of the box for all grids:
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();
Currently, you cannot disable all columns in the column menu - it requires that at least one column is enabled.
However, if the grid contains any non-hidden columns which have IncludeInMenu=false, then it should be possible to disable all the remaining columns using the column menu.
I'd like the ability to choose the behavior of mutli-row selection on a virtual grid with persisted selection.
For purpose of example, assume we have a virtual grid with 50 rows (pager controls not shown), a page size of 10, and persisted selection.
1. Select row 1 on page 1.
2. Scroll down to trigger page 2 to load (rows 11-20).
3. Select row 11, page 2.
4. Current Behavior: Both row 1 and row 11 remain selected.
5. Desired Behavior: Only row 11 remains selected.
Reasoning: I believe that a virtual scrolling grid should have selection behavior identical to a single page. That means that the only way to add rows to the selection is holding down control/shift during selection. In other words, on page 1 of the above example, if I select row 1, then row 2, only row 2 remains selected. If I select row 1, then Ctrl+click/Shift+click row 2, both remain selected. For virtual scrolling where multiple pages are displayed fluidly as if a single page, it seems odd to have the selection behave differently.
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.
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>
If possible, modify the styles.xml template to enable seamless use with OleDB
On desktop there is a page number duplication: screenshot.
On mobile the page numbers disappear: screenshot
The pager should look like in the Default theme.
### 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?
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.
Font size is 22.5
Font size is 30
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();
The sorting arrows are missing for both the "Freight" and "Order Date" columns
The arrows should appear as shown in the image below. The correct behavior can be observed in this Dojo example
Grid's footer is moving together with its pager based on the configuration of the pageable.position property.
The footer of the Grid is positioned above its pager
With pageable.position set to "top" only the pager should be moved above Grid's rows. Its footer should stay at the bottom of the component, below its rows.
Bug report
Ticket ID: 1472456
Using the setOptions() method in an MVVM bound grid causes 2 read requests
A single request should be issued.
programmatically remove the kendo binding from the element before calling the `setOptions()` method.
grid.element[0].kendoBindingTarget = null;
grid.setOptions(options);
Kendo UI version:** 2020.2.617
Hi!
I've found that column menu doesn't work properly when both columns.selectable and columnMenu are enabled. Just run this code snippet and try to enable/disable columns in column menu.
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>
<title>Kendo UI Snippet</title>
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2020.2.617/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/2020.2.617/js/kendo.all.min.js"></script>
</head>
<body>
<div id="grid"></div>
<script>
$("#grid").kendoGrid({
columnMenu: true,
columns: [
{ selectable: true },
{ field: "name" },
{ field: "age" },
{ field: "pet" }
],
dataSource: [
{ name: "Jane Doe", age: 25, pet: 'dog' },
{ name: "John Doe", age: 71, pet: 'cat' }
]
});
</script>
</body>
</html>