This is a migrated thread and some comments may be shown as answers.

format cell when exporting to csv

2 Answers 124 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
abinav
Top achievements
Rank 1
abinav asked on 28 Jun 2011, 12:45 PM
hi

i have enabled the csv option in the grid and i have a column which consists of data in this format 28:30 but when i export it to csv the data gets changed to 28:30:00 i need to display it as 28:30

2 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 28 Jun 2011, 01:37 PM
Hello Abinav,

I cannot reproduce the issue you are facing. Try setting the DataFormatString as shown below.

aspx:
<telerik:GridBoundColumn UniqueName="BirthDate" HeaderText="BirthDate" DataField="BirthDate" DataFormatString="{0:t}">
</telerik:GridBoundColumn>

If it doesn't help, check the following documentation which explains more about CSV export.
CSV export.

Thanks,
Shinu.
0
abinav
Top achievements
Rank 1
answered on 29 Jun 2011, 10:35 AM
hi Shinu

when i export the data 28:30 to csv it displays it 28:30:00 in hh:mm:ss but i want it as 28:30
Tags
General Discussions
Asked by
abinav
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
abinav
Top achievements
Rank 1
Share this question
or