Excel export formats

4 posts, 0 answers
  1. Rezo
    Rezo avatar
    2 posts
    Member since:
    Aug 2012

    Posted 29 Aug Link to this post

    Hello,

     

    When I export result in excel(xls) all cell formats are "custom", how can I keep date format on cells where dates are written?

  2. Stef
    Admin
    Stef avatar
    3037 posts

    Posted 29 Aug Link to this post

    Hi Rezo,

    Format strings are always saved as custom in order to avoid the incorrect interpretation by machines due to their custom culture settings.

    For more details, please check Design Considerations for Excel Rendering.

    Regards,
    Stef
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Rezo
    Rezo avatar
    2 posts
    Member since:
    Aug 2012

    Posted 29 Aug in reply to Stef Link to this post

    Hi and thanks Steff,

     

    Is there any workaround? I have to import output excel in some third party tool, which is crashing because of custom formats on dates. 

     

     

  5. Stef
    Admin
    Stef avatar
    3037 posts

    Posted 30 Aug Link to this post

    Hello Rezo,

    It must be an issue with the used Datetime format string. Please test using the standard format strings, where the field must be of DataTime type. Or format the field in the expression, where the result can be string instead of a DateTime object e.g.:
    TextBox.Value = "=Fields.Date.ToString('dd/MM/yy')";


    Regards,
    Stef
    Telerik by Progress
    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 Feedback Portal and vote to affect the priority of the items
Back to Top