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

5 posts, 0 answers
  1. JUNGGON
    JUNGGON avatar
    6 posts
    Member since:
    May 2013

    Posted 31 Dec 2014 Link to this post

    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 ?


  2. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 01 Jan 2015 Link to this post

    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.

     
  3. JUNGGON
    JUNGGON avatar
    6 posts
    Member since:
    May 2013

    Posted 02 Jan 2015 in reply to Dimitrina Link to this post

    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 ?  

  4. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 02 Jan 2015 Link to this post

    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.

     
  5. JUNGGON
    JUNGGON avatar
    6 posts
    Member since:
    May 2013

    Posted 05 Jan 2015 in reply to Dimitrina Link to this post

    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.
Back to Top