hello 
i`m always using kendo grid in my project
but i can`t import excel to kendo grid 
please make it possible to import excel file and select specific sheet to kendo grid

Hi Team,

We need to add caption on grid table as explained here: https://accessibility.psu.edu/tableshtml/#caption

JAWS should read this caption on pressing T while selecting the table.

Can you guide us how can we add this caption!

Thanks,

Saini

I have a Grid with a command column for edit/remove buttons.

I also have a custom button that has to be hidden while the row is being edited, but there is no variable that exposes that state.

Please provide isEdited field in the kendoGridCellTemplate context.

I had already made an entry in the Foum about it.

https://www.telerik.com/forums/is-there-a-way-for-percentage-column-widths

Link to the demo with the css workaround:

https://stackblitz.com/edit/angular-y8y55s

The main intention is that I want to be able to specify the column width in percentage values rather than fixed pixel values.

There are some edge cases that must be considered:

1. If columns are rearranged, the column width is taken to the new position.
2. If the table is grouped, the columns in the group remain aligned below the column headers.
3. If a column is manually resized, the behavior changes, the table is allowed to grow beyond 100% and gets a scrollbar.

Please provide a frozen column separator as the one for the WPF DataGrid:

https://docs.telerik.com/devtools/wpf/controls/radgridview/columns/frozen-columns

thank you

Please provide an [autoSync] option of the ColumnMenuChooser component as the [autoSync] option for the ColumnChooser component:

https://www.telerik.com/kendo-angular-ui/components/grid/api/ColumnChooserComponent/#toc-autosync

Thank you.

Hi Team

It would be very helpful if Grid allow to prevent focus on cell out-of-box, at the moment, we have to handle focusin event then set focus to other cell, however when using navigation keys or shortcut key, we need to handle differently depend on which cell should be focus next.  

Hello Telerik,

We have implemented a custom reusable filter cell component similar to the example of the multi-select checkbox example from the docs. The difficulty using that example however, is that when the filter is updated, the other filters in the grid are removed due to the use of filterservice.filter. Because the CompositeFilterDescriptor can contain both filters and composite filters, why does the base filter cell component's base methods not allow a CompositeFilterDescriptor to be provided to the UpdateFilter method? 

    protected filterByField(field: string): FilterDescriptor;
    protected filtersByField(field: string): FilterDescriptor[];
    protected removeFilter(field: string): CompositeFilterDescriptor;
    protected updateFilter(filter: FilterDescriptor): CompositeFilterDescriptor;
    protected applyFilter(filter: CompositeFilterDescriptor): void;

Our method for implementing the multi-checkbox filter cell was to build a composite filter using 'Or' logic and each selected value added as a filter descriptor with operator 'eq' and the selected item value as the value of the filter, and use a similar strategy as the base filter cell component to add this composite filter to the filter service's composite filter. 

  private getSelectedFilters(values: Item[]): CompositeFilterDescriptor {
    const selected: FilterDescriptor[] = values.map((value) => {
      return {
        field: this.field,
        operator: 'eq',
        value: value.value,
      };
    });
    return {
      filters: selected,
      logic: 'or',
    };
  }

  public onChange(values: Item[]): void {
    this.selectedValues = values;
    const root = this.filter || {
      filters: [],
      logic: 'and',
    };
    this.removeFilter(this.field);

    if (values !== null && values.length !== 0) {
      root.filters.push(this.getSelectedFilters(values));
    }
    this.filterService.filter(root);
  }

If the base filter cell component allowed the CompositeFilterDescriptor type or the FilterDescriptor type in the updateFilters method, we could simplify the logic in our filter cell component to be similar to the patterns shown in the drop-down list filter component example, as shown below, but with a composite filter descriptor such as the one generated by the above getSelectedFilters function.

this.applyFilter(
      value === null // if value of the default item
        ? this.removeFilter(this.valueField) // remove the filter
        : this.updateFilter({
            // otherwise add/modify the filter for the field with the value
            field: this.valueField,
            operator: 'eq',
            value,
          })
    ); // and update the root filter

I think this would be a beneficial addition to the Kendo Angular2 product, as it would enable many more reusable filter components to be created more easily and also simplify/ enhance some of the existing examples you provide.  If you would like more information or the full multiselect-filter component, I would be happy to supply it.

Thank you!

Can you add "extra" field to FilterableSettings to allow the user to set extra globally for all columns in a grid? 

https://www.telerik.com/kendo-angular-ui/components/grid/api/FilterableSettings/

Currently, if I want to set extra to false for a column, I need to do something like this: 

<kendo-grid-column field="ProductName" title="Product Name">
   <ng-template kendoGridFilterMenuTemplate let-filter let-column="column" let-filterService="filterService">
     <kendo-grid-string-filter-menu [extra]="false" [column]="column" [filter]="filter" [filterService]="filterService">
     </kendo-grid-string-filter-menu>
   </ng-template>
</kendo-grid-column>

But it would be simpler if we can do filterable:{extra:false} just like Kendo UI for jQuery. https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/filterable.extra

Hello,

   You have this jQuery example: Binding to Kinvey Backend Services.  Do you have a similar example for Angular?  I cannot find one.  

Thank you.

Basically whats described in this issue right here: https://github.com/telerik/kendo-angular/issues/2093

It would be nice if column group visibility could be toggleable via the column chooser.

If not, a more elegant workaround would be to indicate in the column chooser that certain columns are part of column groups. The way it is now is too clunky and unclear.

For example, I have the following column groups:

But the above columns show up in the column chooser like so:

It would be nice if the column group name was at least prepended to child columns in the column chooser to at least indicate that it's part of a group. For example, it would show as follows instead:

[x] Latest read - Time

[x] Latest read - Value

[x] Latest write - Time

[x] Latest write - Value

Thanks so much.

Our application uses grouped grids but doesn’t use the built-in collapse feature. We instead hide the collapse arrow to disable the option. This leaves an empty space to the left of the parent grid label (where the collapse arrow would normally sit) and an empty column on the left side of all child grids. We’re looking for a more “official” and supported way of achieving the effect that removing ‘[group]=“groups”’ currently achieves. We’d like to minimize the amount of nonstandard code we’re introducing to our Kendo implementation as well as minimize unintended consequences of altering the grid code.

In the jQuery version of the Angular Grid, it was possible to add row templates to a grid which was useful because you could set attributes directly to the tr.

In my case, I have a scenario where I want to add a title attribute for tooltips for the whole row, not just individual cells. 

I can provide a function for rowClasses, which is great, but it would be nice if there was a similar function I could use to add other attributes as well directly to the tr.

At the moment my work around is to add the title to every column individually, but that's not ideal as it affects the positioning of the tooltip etc

Hey Kendo Team,

you already have a solution in jQuery for my problem (https://docs.telerik.com/kendo-ui/knowledge-base/grid-group-remove-footer-header-one-record).

Unfortunately this solution did not work in Angular.

Desirable solution would be a flag in GroupHeaderTemplate which removes header if group size is one.

Another solution could be; allow a class field in GroupHeaderTemplate, so that we can set display to none if group size is one.

Best regards,

Matthias