Multi line Carriage Returns is not working in a cell when exporting grid using ExcelML

[JUNGGON]

Hi !

I'm developing  grid excel exporting using ExcelML with UI For WPF Q1 2014 SP1 in WPF Application.

There is a problem that multi line Carriage Returns(\r\n or \n) is not working in a cell  when exporting grid using ExcelML.

SpreadML ( Open Xml at office )

I had searched and found a content. 

This is content that was written in 2009 years.

This content is written that newline characters are not supported in ExcelML format by the Telerik team.

http://www.telerik.com/forums/carriage-returns-when-exporting-grid-using-excelml

Please, What is the solution of  this problem ?

[Dimitrina]

Hello,

You can check the following forum thread Carriage returns stripped from cell text during export suggesting on how to directly manipulate the output result from exporting.

Regards,
Dimitrina
Telerik

 

 

[JUNGGON]

Hello.

Thank you very much your fast and kind answer !

It works well with the suggested solution.

Maybe, is there other way that manipulate  changed cell value to cell  per a cell  ?

In excel exporting event , like this

 e.Cell.Value = e.Cell.Value.Replace("\n", "
");

I'm afraid of consuming much client memory with big data..

Or 

is there RadGridView default setting function or property for carriage return ?  

[Dimitrina]

Hello,

I can also suggest you exporting data as illustrated on the SpreadProcessing Integration demo. That way the Environment.NewLine ("\r\n") will be exported fine.

Regards,
Dimitrina
Telerik

 

 

[JUNGGON]

Hello
thank you for your kindness.

I tested the solution of SpreadProcessing and confirmed the result .

I will choice one solution that you suggested .

Additionally ,  I wish  that  carriage return property or function in excel exporting  will be added  at next  Telerik version .

Best regards.