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:

https://docs.telerik.com/kendo-ui/controls/data-management/grid/appearance/adaptive#resizing-of-columns

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();

 

Enhancement

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.

Current behaviour

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>

Expected/desired behavior

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?

 

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]

When a grid pager is in responsive mode at low resolutions, the user has no indicator that the controls have been hidden.  It would be great if the control had a Kabob to give the user access to the hidden controls, similar to Kendo Menus.

Hi, 

I would like to request the configuration of the Search Panel to have a custom search function.  For example, I could use this to modify search results(ie. ignore accents).  

Thank you!

When there are a lot of columns on the page and a column is shown, it is shown at its original position in the grid columns array. 

It would be much better from a user experience point of view if the column is shown where the user clicked on the column menu to show the hidden column.

Hi Team,

I'd like to request the functionality to allow the user to select the ALL option while using GroupPaging.  

Thank you

would help to get rid of our own implementation of the grid search & make integration with other components more easier 

would be great to have, will help to make logic easier if we want to save the value to share across all the grids in app

 

P.S - also would be great to use pageSize = All in Datasource instead of undefined

Hi Team,

I would like to request an CancelIconClass property for the Kendo UI Grid's toolbar which would allow an easier way to change the cancel icon rather than using CSS. 

Thank you!

Hi Team,

We'd like to ask for the functionality of saving asynchronously records with the Kendo UI Grid in a Batch edit mode that would be non-blocking and not interrupting.  For example, a user can continue to edit without the loading symbol appearing and causing a delay in editing when the dataSource.sync() fires.

Thank you!  

Hi Team, 

I would like to request the built-in functionality to include fixed headers for the Kendo UI Grid.  Specifically, it would be great if it could be included for Hierarchical Grids and Detail Grids.  

Thank you!

Hi Team,

I would like to request the functionality of including a floating horizontal scrollbar.  Specifically, this would be for Hierarchical Grids and Detail Grids.

Thank you!

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] 

Include the option for the Grid to be resized when a column is resized. The functionality would work like the ResizeGridOnColumnResize option in the AJAX Grid - https://demos.telerik.com/aspnet-ajax/grid/examples/columns-rows/columns/column-row-resize-reorder/defaultcs.aspx

I would like to request the updating of multiple records when the grid is in "InLine" edit mode. The changes could be saved through the grid's toolbar "Save" command similar to the "InCell" edit mode.

Currently it is only possible to include some custom header/footer data in an exported Excel worksheet. which is either at the beginning or the end of the rows.

 

It would be nice to have a feature to set the Excel-Header/Footers from Kendo UI while creating the export file. This Excel headers/footers are only visible when the Excel-Sheet gets printed e.g. you can include Report-Name, creation date or page x of y information.

Have a look at the Header/Footer feature in Excel: Headers and footers in a worksheet - Excel (microsoft.com)