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

RadGrid Export to CSV ...problem

1 Answer 57 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Anita
Top achievements
Rank 1
Anita asked on 22 Mar 2010, 05:44 PM
Hi all,

I have a column in my radgrid called 'academic year' with values '01/02', '02/03', 03/04'..... etc

When I export to CSV, the above values become '01-Feb', '02-Mar', '03-Apr' .... etc.

Instead of exporting the value as  text, it is considering it as date. Could you  please suggest how can I solve this issue.

Thanks

1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 22 Mar 2010, 08:52 PM
Hello Anita,

The values in your CSV file are automatically parsed by Microsoft Excel and there is no way to avoid it. You can try the following:
- change the date format so it can't recognize it
- change the file extension to TXT and import the file manually

MS Office 2007 Excel Auto-Format Question

Regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Grid
Asked by
Anita
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Share this question
or