Currency export to excel

4 posts, 0 answers
  1. Eric Schuler
    Eric Schuler avatar
    6 posts
    Member since:
    Aug 2012

    Posted 10 May 2011 Link to this post

    Hi,

    I have trouble to export currency value to excel.

    in a Table Cell, I data bind a double value to a text box, and set format as {0:C2}

    It works OK when it's displayed in report viewer, and it looks OK when it is exported to Excel, but if I check the "cell format" in excel, the format is defined as "Custom", the Type is: [$-1010409]$#,##0.00;($#,##0.00)

    Our client wants this cell to be exported to the "Currency" type in excel. 

    Could you give me some hint on what I can try?

    I appreciated any help from you.

    Thank you very much.
  2. Peter
    Admin
    Peter avatar
    1649 posts

    Posted 13 May 2011 Link to this post

    Hello Eric Schuler,

    You are correct. Currently the exported excel documents have custom format for currency. This is by design in order to keep the currency type no matter the computer's regional settings. Still we agree that this could be confusing for some of the end users and we have decided to further research for a better approach.

    Best wishes,
    Peter
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Chris
    Chris avatar
    1 posts
    Member since:
    Jun 2013

    Posted 23 Jul 2014 in reply to Peter Link to this post

    Hello, 

    I have a client that would like the exact same as Eric's, and i wanted to know if there was any development on this issue ?

  4. Alena
    Admin
    Alena avatar
    1049 posts

    Posted 28 Jul 2014 Link to this post

    Hello Chris,

    The exported Excel file's text boxes still have a custom format even thought their format in the report definition is set to currency and there is no way to work around the behavior. Format strings are always hard-coded with "Custom Format". This way the formatting from the report definition is preserved and does not depend on the client machine locale.

    This issue is now logged in our system for further investigation and improvement in a future version of the Reporting suite.

    Regards,
    Nasko
    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.

     
Back to Top