I'm running into a situation in my MVC app where the Kendo grid seems to be assuming that my date columns are UTC dates and are converting them to local time. Most of my dates are off by one day. 

First of all, is this what the grid is doing? Past posts about issues like this seems to confirm it. If so, can I tell the Kendo grid that my dates are not UTC? We're building an app around an existing database where the dates are not stored as UTC and the dates cannot be converted. If I can't tell the Kendo grid to stop doing this, what alternatives do I have? I know I can represent dates as strings in the grid, but then I lost the ability to sort correctly if the user chooses to sort a date column. Converting all date columns in our database to UTC is not an option.

We are using a custom editor on one of the columns of the kendo spreadsheet. The Kendo spreadsheet contains multiple sheets each having variable number of columns. As of now we are creating all the sheets  with equal number of columns by getting the maximum column count from the sheet having max number of columns and then for the other sheets with less column count , we are hiding them.

I am using the following custom editor code to position the editor with the cells. I am using  ".k-spreadsheet-active-shell.k-right" class to identify the rightmost column and get the position of the column. But now in the current situation because I have some hidden columns after my actual column where I need the custom editor, k-right class is not getting applied .

Is there a workaround for this? Can kendospreadsheet contains sheets with different columns count?

Hi, 

Need customization of  Checkboxes on focus need to add arrow showing below options. 

Currently having close ( X ) icon. Need to be add down arrow as per attachment design.

Please assist. 

Hello!
I need a feature for this chat control that is present in Kendo Angular library (https://www.telerik.com/kendo-angular-ui/components/conversationalui/message-templates/)
I'm talking about message templates: the possibility to add a custom template in normal message.
I need it to implement some advance features, like messages deletion and messages modification.

This feature will be present soon in Kendo jQuery library?

Thanks,
Mattia

Hi,

I have following code, and i could editable field marked as editable: false ?

Why regards

            <div kendo-grid="mygrid"
                             class="customTransBg"
                             uib-collapse="hideDifference"
                             k-data-source="mygridDatasource"
                             k-sortable="true"
                             k-editable="true"
                             k-pageable="true"
                             k-filterable="{mode: 'row'}"
                             k-columns='[
                                {field: "source.<spring:message code="global.description"/>",
                                    title:"<spring:message code="rapport.etatcompte.erreurs.colonne.source"/>",
                                    filterable: filteringConfig, editable: false},
                                {field: "compte", title:"<spring:message code="rapport.etatcompte.errors.colonne.compte"/>",
                                    filterable: filteringConfig, "editable": false},
                                {field: "date",title: "<spring:message code="rapport.etatcompte.errors.colonne.date"/>", editable: false,
                                    filterable: filteringConfig},
                                {field: "facture", editable: false,title: "<spring:message code="rapport.etatcompte.errors.colonne.facture"/>",
                                    filterable: filteringConfig},
                                       {field: "total", title:"<spring:message code="rapport.etatcompte.errors.colonne.total"/>", editable: false,
                                    format:"{0:c}",
                                    filterable: filteringNumberConfig},
                                {field: "codeErreur",
                                    defaultValue: {id:" ",descriptionFr:" "},
                                   title: "<spring:message code="rapport.etatcompte.errors.colonne.codeErreur"/>", attributes: {"class": "k-item noCap"}, editor: codeErrorDropDownEditor, template: "#=codeErreur.<spring:message code="global.description"/>#", nullable: false}
                            ]'>
                        </div>

Is there any way of formating a cell on incell editing and making sure that everytime the user leaves the cell, its value is in hh:mm format?

Similar to the editing custom editor example and the unit price column.

I tried the following but it did not make any difference. I am still able to pass whatever value I want. 

...
columns: [
  { field: "time", title: "Time", width: "40px",  attributes: {style: "text-align:left;"}, headerAttributes: {style: "text-align:left;"}, format: "{0:hh:mm}" },      
],
...

I am guessing I will have to combine both datasource validation and the format option in order to achieve what I want. 

Thank you in advance,

Syian

Hi all

I use a kendo grid to display some datas (with VUE JS 3 ) . This one is pageable.

I use the event "page" called when I change the page. I try to call initContextMenu from this event but I have the error "initContextMenu" is not a function"...

How can I call initContextMenu ? thanks you !

Hi everyone,

I've been banging my head with an issue with KendoUI grid (for JQuery) and I was hoping I could get some help.

I've implemented server side pagination and filtering in my project and I send all the filtering parameters to a stored procedure.

It works fine, both the filtering and the pagination. The problem is when the data is returned to the grid if I had made a date range filtering.

ONLY with date range filtering. If I search only by string columns, I have no issues. If I search by only a date (not a range), it works too.

My guess is that it doesn't like to have two filters with the same key.

Here's my filter function:

const DatagridFilter = (e) => {
    const grid = datagrid.getGrid();
    let CurrentFilters = grid.getOptions().dataSource.filter?.filters || [];

    let filters = []; 

    if (e.filter == null) {
        angular.forEach(CurrentFilters, function (value, key) {
            if (value.filters.some(item => item.field !== e.field)) {
                filters.push(value);
            }
        });
    } else {
        let NewFilter = { logic: e.filter.logic, filters: [] };
        e.filter.filters.map(f => {
            NewFilter.filters.push({
                field: f.field,
                operator: f.operator,
                value: f.value
            });
        });

        let exist = false;
        angular.forEach(CurrentFilters, function (value, key) {
            if (value.filters.some(item => item.field === e.field)) {
                exist = true;
                filters.push(NewFilter);
            }
            else {
                filters.push(value);
            }
        });
        if (!exist) {
            filters.push(NewFilter);
        }
    }

    datagrid.setGridFilters(kendo.stringify(filters));
    if (filters.length > 0) {
        GridBind(1);
    } else {
        datagrid.resetGridFilters();
    }
}

And here's my DataGrid definition:

$("#grid").kendoGrid({
        excel: {
            allPages: true
        },
        filterable: {
            extra: false,
            operators: {
                string: {
                    contains: "Contains",
                    startswith: "Starts with",
                    endswith: "Ends With",
                    doesnotcontain: "Doesn't contain",
                    doesnotstartwith: "Does not start",
                    eq: "Is equal to",
                    neq: "Is not equal to",
                    isempty: "Empty",
                    isnotempty: "Not empty",
                },
                number: {
                    eq: "Equal to",
                    neq: "Not equal to",
                    lt: "less than",
                    lte: "less than or equal to",
                    gt: "greater than",
                    gte: "greater than or equal to",
                    startswith: "Starts With",
                    contains: "Contains",
                    doesnotcontain: "Doesn't contain",
                    doesnotstartwith: "Does not start",
                    endswith: "Ends With",
                    isnull: "Is Null",
                    isnotnull: "Is Not Null",
                },
                date: {
                    gte: "From Date",
                    lte: "To Date"
                }
            }
        },
        filter: (e) => DatagridFilter(e),
        sort: (e) => DatagridSort(e),
        page: (e) => GridBind(e.page),
        sortable: true,
        autoBind: false,
        navigatable: true,
        serverPaging: true,
        serverFiltering: true,
        serverSorting: true,
        height: gridAutoHeight,
        toolbar: [{ template: kendo.template($("#templ_toolbar").html()) }],
        columns: datagridColumns
    });

Any ideas of what could be happening?

Thanks!

Hi, we were testing Telerik Server Grouping with virtualization, as it is shown in the example for it and we are seeing strange behaviour.

When I select a group which has enough records inside, the scrolling in the group down to make it request another page will actually append again the same records which are already displayed - from the first page actually.

The easiest steps to reproduce this behaviour is

1. Go to demo page 

https://demos.telerik.com/kendo-ui/grid/server-grouppaging-virtualization and click to Edit in Dojo. It opens https://dojo.telerik.com/afoCefOJ

Then, to get rid of narrow groups I will change grouping from 

group: [{
                        field: "city",
                        dir: "asc"
                    }, {
                        field: "companyName",
                        dir: "asc"
                    }],

to

group: [{
                        field: "city",
                        dir: "asc"
                    }],

and also adjust pageSize to 10:

pageSize: 10,

2. Now, when I Run example, open Chrome Debug tools to Network traffic and expand Shady shores, I get records starting with:

GC30TRSSMTI706Z, Ireland

I can see first request starting wtih Page:1

3. Now I scroll the virtual view just a bit down to get another 10 records. Surprisingly, I get same records again.

GC30TRSSMTI706Z, Ireland

Is it expected behaviour, or how can I fix it to scroll to next records on another request ?

Thank you kindly,

Martin