4) Fills a gridview
GridView1.DataSource = myData
GridView1.DataBind()
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
DataType ="System.Int32" DataFormatString="{0:N0}"
The format works fine when it is displayed.
As per business logic I make column A as readonly in the code behind(I am doing this for the first time when Radgrid is loaded)
As I mentioned display is fine, but when I go into edit mode ColumnA (which is in readonly now) is loosing format and display the number with no formatting. When I come out of edit mode everything looks fine
Am I missing some setting here
Thanks for your help