radgrid export to excel bot accepting double white space

[Raja Rajeswari Mohan Venkataraman]

Hi,

I have a radgrid in which I'm binding the data. For instance I have the column "SER" in the grid. The value of "SER" in the grid is
"NG  101101". The length is fixed i.e 10.

When i export the above data using export to excel, the radgrid exports the above data to "NG 101101".  It removes one space. I don't want the excel to remove the space. I need to maintain the data as such.

Could you please help me achieve what I want.

Thanks,
Raji

[Shinu]

Hello Raji,

Try setting mso-number format as explained in this documentation.
Word/Excel export (HTML-based).

-Shinu.

[Daniel]

Hi Raji,

I suppose that you are using the HTML format. In this case, Excel will display the whitespaces in the exported file in the way they are presented in RadGrid.
Under normal circumstances, two or more whitespaces will be merged into one, single character. You could work around this if you disable the HtmlEncoding property for the given column and then use & nbsp ; as empty characters.

Kind regards,
Daniel
the Telerik team

[Raja Rajeswari Mohan Venkataraman]

Hi Daniel,

The "SER" column that I have in the radgrid is an autogenerated column. The value of "SER" in the grid is "NG  101101". The length is fixed i.e 10.

When i export the above data using export to excel, the radgrid exports the above data to "NG 101101".  It removes one space. I don't want the excel to remove the space. I need to maintain the data as such.

Could you please help me to achieve what I want?

Thanks,
Raji

[Daniel]

Hi Raji,

You could set the HtmlEncoding property of your autogenerated columns in the ColumnCreated event handler.
Give it a try and let me know what happens.

Regards,
Daniel
the Telerik team

[Raja Rajeswari Mohan Venkataraman]

Hi Daniel,

Could you please give me an example of how to disable the HTML encoding for the autogenerated column.

Thanks,
Raji