Export to Excel - rendered data

[Rob ONeill]

Hi,

I am exporting data to Excel, and DateTime fields are not coming out as required, having the time on the end. Excel just shows the date. Also Decimal values are getting rounded, which we don't want.

In the GridProperties, in the columns our DateTime field has Format="{0:dd/MM/yyyy HH:mm:ss}" ... but the dates come out dd/MM/yyyy (no time in the cell, just in the value).

And some of our values are getting rounded ... 7.229479800000001 gets rounded to 7.2294798 .... we want the full value.

Cheers ... Rob.

[Ragavee U S]

Hi Rob,

Query #1: Decimal values are getting rounded

We analyzed the above query and found that it is the default behavior of Microsoft excel that the values get rounded off if the decimal values exceed 11 digits.

Query #2: in the columns our DateTime field has Format="{0:dd/MM/yyyy HH:mm:ss}" ... but the dates come out dd/MM/yyyy (no time in the cell, just in the value).

We considered this query “Format not applied to datetime column while exporting grid to excel” as a bug and a support incident has been created under your account to track the status of this issue. Please log on to our support website to check for further updates.
https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents

Regards,

Ragavee U S.