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

The autoFitColum method sizes the chosen column to the correct size, but it also reduces all other columns to their width property as shown below. 

I created some examples to show what I'm talking about by editing autoFitColumn - API Reference - Kendo UI Grid | Kendo UI for jQuery (telerik.com)

This behavior works out in cases where the auto fit column exceeds the grid width (see figure 1), but not in cases where the the data is Smaller than the grid (see figure 2). 

The desired behavior, for me, would be for the autoFitColumn method to act like setting the width manually (see figure 3 or dojo example). I need scrollable to be true and grid width to be auto to work on any screen width. Allowing the rows to text-wrap doesn't work for scrolling large data tables.

Is figure 2 the intended behavior, and is there a way to achieve my desired behavior?

<div id="grid"></div><script>
$("#grid").kendoGrid({
  columns: [
    { field: "name", width: 100 },
    { field: "age", width : 50 },
    { field: "quote" }
  ],
  dataSource: [
      { name: "Jane Doe", age: 30, quote: "I like Pi." },
      { name: "John Doe", age: 33, quote: "The FitnessGram™ Pacer Test ... ding" }
  ],
  scrollable: true,
  width: 'auto'
});
var grid = $("#grid").data("kendoGrid");
grid.autoFitColumn("quote");
</script>
figure 1: behavior of autoFitColumn if data is longer than grid is wide.

<div id="grid"></div><script>
$("#grid").kendoGrid({
  columns: [
    { field: "name", width: 100 },
    { field: "age", width : 50 },
    { field: "quote", }
  ],
  dataSource: [
      { name: "Jane Doe", age: 30, quote: "I like Pi." },
      { name: "John Doe", age: 33, quote: "I like Pi too." }
  ],
  scrollable: true,
  width: 'auto'
});
var grid = $("#grid").data("kendoGrid");
grid.autoFitColumn("quote");
</script>
firuge 2: behavior of autoFitColumn if data is shorter than grid is wide

<div id="grid"></div><hr/><div id="grid2"></div><script>
  
$("#grid").kendoGrid({
  columns: [
    { field: "name", width: 100 },
    { field: "age", width : 50 },
    { field: "quote", width : 3272 } //this width should be set by autoFitColumn instead of manually
  ],
  dataSource: [
      { name: "Jane Doe", age: 30, quote: "I like Pi." },
      { name: "John Doe", age: 33, quote: "The FitnessGram™ Pacer Test ... ding" }
  ],
  scrollable: true,
  width: 'auto'
});
  
  
$("#grid2").kendoGrid({
  columns: [
    { field: "name", width: 100 },
    { field: "age", width : 50 },
    { field: "quote", width: 93 }//this width should be set by autoFitColumn instead of manually
  ],
  dataSource: [
      { name: "Jane Doe", age: 30, quote: "I like Pi." },
      { name: "John Doe", age: 33, quote: "I like Pi too" }
  ],
  scrollable: true,
  width: 'auto'
});
  //I left this code in a comment to make switching back and forth between my desired and actual behavior easier
/*var grid = $("#grid").data("kendoGrid");
var grid2 = $("#grid2").data("kendoGrid");
grid.autoFitColumn("quote");
grid2.autoFitColumn("quote");*/
  
</script>
figure 3: desired visual result, but the width should be set using autoFitColumn, not manualy
  

Hi Team,

This is regarding the subjected issue with in our application where we are unable to drag one particular cell value to adjacent/the same/or horizontal cells' , am attaching the replication for the same(file name : bugreplicationhelper.zip), so, could you help us or correct, if some more information needed from us on the same.