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

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

4 Answers 68 Views
This is a migrated thread and some comments may be shown as answers.
JUNGGON
Top achievements
Rank 1
JUNGGON asked on 31 Dec 2014, 07:09 AM
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 ?


4 Answers, 1 is accepted

Sort by
0
Dimitrina
Telerik team
answered on 01 Jan 2015, 12:43 PM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
JUNGGON
Top achievements
Rank 1
answered on 02 Jan 2015, 07:44 AM
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 ?  

0
Dimitrina
Telerik team
answered on 02 Jan 2015, 08:14 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
JUNGGON
Top achievements
Rank 1
answered on 05 Jan 2015, 07:23 AM
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.
Asked by
JUNGGON
Top achievements
Rank 1
Answers by
Dimitrina
Telerik team
JUNGGON
Top achievements
Rank 1
Share this question
or