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>
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
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:
Hi,
I am facing a case like this:
Source: https://stackblitz.com/edit/angular-v6xzlw-vrqmxj
I am using kendo grid.
The data displayed on the grid is ok but when exporting excel, the data is missing.
I've been trying to find a way for a few days but still can't solve it.
Please support.
Thanks!
Hi,
I have the scenario where I have to implement a three-layered master-detail as shown in the snapshot.
Is there any possibility of exporting?
Thanks in advance.
I wanted to span a column for a single row (the last row) and have it be sticky. Basically if I have a table with 5 columns and 5 rows, I want to have the 5th row span the full length of the 5 columns. I've looked at kendo-grid-span-column but I don't see a way to specify a row of data. I've also looked into using kendoGridFooterTemplate but it doesn't seem like there is support for spanning that quite yet.