Hey everyone, 

I'm having some problems with the Export to Excel functionality on android, it's working properly on my web app, but when I use cordova to build the app on android and test the same function there seams to be an issue. I'm not getting any errors but the tables are not beeing exported as expected.

Does anyone know if there's a compatibility issue with Kendo and Cordova or if I have to set any especific configuration for this function to work?

Thanks!

Hey guys,

I have an angular form that contains two tree lists: the first one is hierarchal and the 2nd is flat.  Both are populated using [kendoTreeListFlagBinding] and both render correctly.  The first tree list is hierarchal and the second is flat.  Yay Kendo!!

The issue is when I go to export from the flat treelist, it exports hierarchal and not flat.

First Treelist

code for the column defs etc

second Treelist

code for the column defs etc

What I need is the "directive" to tell excel to export the data as a flat list.

What am I missing from the doc

Thanx Kyle

Hi

I'd like to fix an issue we have about the columns using dates, we have a dashboard and when user export the dash to Excel. 

seems like there's no problem or something, however when we proceed to open the Excel file. 

if we take a look to those columns displaying dates,  then we select any of these cells,  right click, "format cell"

Catogory is displayed as "General",  instead of date and any of the possible types-formats

so when user is trying to apply filter in excel, values for date columns are not recognized as dates.

I have been trying to modify the date format like these

 //attempt3

this is how it looks like in the front end,

<kendo-grid-column
    field="pcagatecurrentdate"
    [columnMenu]="true"
    title="{{ getTitle('pcagatecurrentdate') }}"
    tooltip=""
    [locked]="false"
    width="110"
>
    <ng-template
        kendoGridFilterMenuTemplate
        let-filter
        let-column="column"
        let-filterService="filterService"
    >
        <app-date-range-filter
            [field]="column.field"
            [filter]="filter"
            [filterService]="filterService"
        >
        </app-date-range-filter>
    </ng-template>
    <ng-template kendoGridCellTemplate let-dataItem>
                    <span
                        [ngClass]="{
                            okProjectStatus:
                                dataItem.projectConceptApprovedStatus ==
                                'ok',
                            warningProjectStatus:
                                dataItem.projectConceptApprovedStatus ==
                                'warning',
                            dangerProjectStatus:
                                dataItem.projectConceptApprovedStatus ==
                                'danger'
                        }"
                    >
                        {{
                        dataItem.pcagatecurrentdate != null
                            ? (dataItem.pcagatecurrentdate
                                | date : 'dd-MMM-yyyy')
                            : ''
                        }}
                    </span>
    </ng-template>
</kendo-grid-column>

but at the end all the dates still displayed as "General"

and this is the target I would like to reach

I appreciate any suggestions you may have

Thanks

Victor M.

Hello,

How can we use dropdown buttons to show export to excel and export to pdf options in grid's header? I'm not able to visualize how to use kendoGridExcelCommand and kendoGridPdfCommand in dropdown button.

I have a kendo grid that contains data that comes from a DB call.
Currently the export excel button extracts all the data equal to the datasource.
It is mapped into java.
I would like that when compiling the filters of the kendo grid when I click on the button it extracts only the filtered data

 <kendo-grid
                            [data]="gridData"
                            [pageSize]="state.take"
                            [skip]="state.skip"
                            [sort]="state.sort"
                            [filter]="state.filter"
                            [sortable]="true"
                            [pageable]="true"
                            [filterable]="true"
                            [selectable]="true"
                            [style.minHeight.px]="minMaxHeight"
                            [style.maxHeight.px]="minMaxHeight"
                            (dataStateChange)="dataStateChange($event)">
                            <kendo-grid-column field="name" title="{{'name' | translate}}"></kendo-grid-column>
                            <kendo-grid-column field="month" title="{{'month' | translate}}"></kendo-grid-column>
</kendo-grid>

Hi,

I am trying to export multiple treelists which has same columns and treelists are generated by *ngFor  (from an external button request) into one Excel sheet. I cannot get it quite right, and cannot find any example that can help me.

Any examples or assistance would be greatly appreciated.

Thank you,

Mahidhar.

Hello

I want to add a dropdown button with both options i.e. a) Export Current page, b) Export All pages

Is this possible , as I could see only the two excel buttons Export to Excel and Export to PDF to appear

Regards

Hay

We're trying to export the data from the Chart component into excel format as a copy/pastable (the data, not the chart).  The Chart supports exporting the chart itself as an image, but what I'm trying to get after is to use the ExcelExportComponent to take the data I am feeding to the chart, format as an excel document, and then copy it to the clipboard so the user can paste it into excel themselves, similar to what can be achieved with the Grid component. I understand the ExcelExportComponent is set up for saving data as an excel file, but can I access it somehow to get that data copied?

I have the following situation, a component with treelist where the column receives an array by ngTemplate referencing the field.

 <kendo-treelist-column
    *ngIf="!isHidden('progress')"
    field="progress"
    title="Progress"
    [width]="320">
    <ng-template kendoTreeListCellTemplate let-dataItem let-group="cellContext">
      <app-okrprogress-bar
        [showButtonOk]="true"
        [value]="dataItem.progress.slice(-1)[0].value"
        [valuePercentagel]="dataItem.progress.slice(-1)[0].value"
        [showSlider]="!dataItem.contents ? true : false"
        [showValue]="dataItem.typeProgress == 'Values' ? true : false"
        [showChecbox]="dataItem.typeProgress == 'Boolean' ? true : false"
        [stepSlider]="dataItem.typeProgress"
        [viewValue]="dataItem?.values"
        (newPercentageActive)="
          changePercentage($event, group.viewItem.parent.data, dataItem)
        "></app-okrprogress-bar>
    </ng-template>
  </kendo-treelist-column>

Now I have to export this column in excel, but the field only waits for a simple variable or objects.

  <kendo-treelist-excel>
    <kendo-excelexport-column fild="keyName" title="Objective"></kendo-excelexport-column>
    <kendo-excelexport-column fild="progress.slice(-1)[0].value" title="Progress"></kendo-excelexport-column>
    <kendo-excelexport-column fild="status.status" title="Status"></kendo-excelexport-column>
  </kendo-treelist-excel>

I did some tests of different calling modes but none of the results were effective.

This is the interface:

interface ObjectiveResult {
  keyName: string;
  progress: Progress[];
  status?: Status;
}

interface Progress {
  value: number;
  date: Date;
}

interface Status {
  name: string;
  color: string;
}

Current results: