We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Export to Excel - rendered data

Thread ID:

Created:

Updated:

Platform:

Replies:

121017 Nov 3,2015 08:46 AM Nov 4,2015 06:02 AM JavaScript 1
loading
Tags: ejGrid
Rob ONeill
Asked On November 3, 2015 08:46 AM

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 [Syncfusion]
Replied On November 4, 2015 06:02 AM

Hi Rob,


Query #1Decimal 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 #2in 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.


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;