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.
In a Grid with virtual row and column scrolling enabled, if there are large number of hidden columns, the horizontal scrolling is very slow.
Horizontal scrolling is slow
Horizontal scrolling should be smooth
Cannot read property 'groupHeaderColumnTemplate' of undefined.
I have my grid, with 4 columns:
var dataSource = new kendo.data.DataSource({
transport: {
read: {
url: Utils.getUrlServices() + "getGrid",
dataType: "json",
}
},
requestEnd: function (e) {
},
schema: {
model: {
fields: {
id: {type: "number"},
name: { type: "string" },
namecompany
: { type: "string" },
hours: {type: "number"},
date: {type: "date"}
}
}
},
pageSize: 500,
group: [
{
field: 'name',
aggregates: [
{field: "hours", aggregate: "sum" }
]
}, {
field: 'nomeImpresa',
aggregates: [
{field: "hours", aggregate: "sum" }
]
},
{ field: "hours",
aggregates: [
{field: "hours", aggregate: "sum" },
{field: "name", aggregate: "sum"},
{field: "nameCompany", aggregate: "sum"},
{field: 'date', aggregate: 'sum'}
]
},
{field: 'date',
aggregates: [
{field: "hours", aggregate: "sum" }
]
}
],
aggregate: [
{field: 'hours',aggregate: 'sum'}
]
});
self.Grid.set("source", dataSource);
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!
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
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();
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
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
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]
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
Selecting a row on a parent grid with selectable enabled unticks checkboxes from the selectable column in child grids
Reproduction of the problem
Dojo: https://dojo.telerik.com/ilOCAJeg
1. Select rows in a child Grid
2. Select a row in the parent Grid
Expected/desired behavior
The checkbox ticks shall be persisted when the user selects a row in the parent grid
Environment
**Kendo UI version: [all]
**jQuery version: [all]
**Browser: [all]
When the Kendo UI Grid is initialized with the bind method utilizing MVVM, the columns.template is correctly bound based on the data-role, but the columns.headerTemplate does not render like the template.
Please take a look at the following Progress Kendo UI Dojo.
The column.headerTemplate does not render the elements containing a data-role.
The elements which contain a data-role should become widgets upon binding.
Hi everyone,
i have a kendo Grid with columns virtualization enabled. It works perfectly but comes a weird behaviour when I add aggregate columns.
The problem consists in the constant relocation of aggregates cells values when scrolling horizontally the grid, i.e aggregate cell keeps changing column : the more you scroll, the more it jumps from a column to another.
I provided this jsFiddle sample to help you reproducing the problem.
Keep scrolling horizontally and keep an eye on "Field6" and "Field8" columns where aggregates have been configured and you will see that the corresponding aggregates values will constantly go on wrong columns.
When using the Selection and Export Grid Demo in Safari, and pasting the cells in Excel, there appears to be some extra empty lines below the paste.
The pasted lines should not include any additional empty lines beneath the specific content.
The row reordering functionality does not work correctly when the draggable column has a small width.
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.
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).
Reorder should work as expected, regardless of the column width.
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.
The column, including the header, is not completely visible.
The whole column should be visible.
Environment (OS, Application, Versions): Chromium Edge Version 119.0.2151.72 (Official build) (64-bit)
Repro Steps :
Actual Results: User is not able to group/ungroup the table column header using keyboard with CTRL + SPACE key.
Expected Results: User should be able to group/ungroup the table column header using keyboard with CTRL + SPACE key.
In a Grid where custom filterable ui is configured, and the filterable.extra is set to false, the data is not filtered correctly.
Regression introduced with 2025.1.211
No data is shown in the Grid, as it appears that the logic for the filterable.extra is not applied
The data should be correctly filtered with the above configuration.