Excel export formats

[Rezo]

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?

[Stef]

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

[Rezo]

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. 

 

 

[Stef]

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