Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Numbers with decimals get changed to whole numbers after exporting to Excel
Description
When exporting data to an Excel spreadsheet, the numbers lose their decimals and get rounded to a whole number. The number looks correct in the data grid, but not in the Excel sheet after exporting.
Cause
In previous versions, decimal characters were truncated to 4 digit precision (Example: 999.1234). Some users wanted to see all precision values. In Oracle this can be as much as 38 digits and Excel only accommodates 15 digit precision. So, in TDP 3.3 we changed to export decimals as text, so that you can see all values. Using general format exports as 0 decimals (Example: 999) and using standard results in text and all values (999.123456789).
Resolution
WORKAROUND: None
STATUS: Waiting for fix to be released in a future version of Toad Data Point.
Defect ID
ST110495
Additional Information
An option will be added in a future release to allow the precision to be chosen how the customer wants it.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Toad Data Point
Topic(s):
Troubleshooting
Article History:
Created on: 8/8/2013 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.
