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

leading 0 in column value is egnored while grid exported to CSV

1 Answer 659 Views
Grid
This is a migrated thread and some comments may be shown as answers.
VIJAY
Top achievements
Rank 1
VIJAY asked on 27 Feb 2012, 06:57 AM

 

 

while exporting grid to CSV the following column values which starts with 0 ,exclude 0 after they are exported to csv format,where as grid column values are proper with leading 0.
<
telerik:GridBoundColumn HeaderText="Code" DataField="Code" UniqueName="Code"

 

 

 

Visible="false" SortExpression="Code" DataType="System.String">

 

 

 

</telerik:GridBoundColumn>

fro excel,i did

 

e.Cell.Style[

 

"mso-number-format"] = @"\@";

 

in

ExcelExportCellFormatting event ,for the same column,so now in excel columns with leading zero are dispyaing correct values,but i m not able to get the same for CSV

1 Answer, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 27 Feb 2012, 07:13 AM
Hello Vijay,

Check the following forum thread which discussed similar scenario.
Export to CSV - Leading Zeros

-Shinu.
Tags
Grid
Asked by
VIJAY
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or