Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Export to excel displays the data in exponential form

SA-83760

Summary



After Export to Excel, large numbers displays the data in exponential form.


Error Messages



Not Applicable.


Steps to Reproduce

  1. Create a report definition with a column with more than 15 characters)
  2. Set the column as a key column
  3. Generate the Excel file from the report definition


Root Cause



A software use or operation error.

In Microsoft Excel, a number more than 12 characters is converted to exponential form. If user converts the number from exponential to regular decimal format, it rounds off the number.



Resolution

Perform the following local-change: 
  1. Open the report definition for columns which displays as text in the Excel file
  2. Click the cog icon which is next to the Delete icon. This opens a popup to edit column options
  3. Enter pxDisplayText in the column format autocomplete field and submit
  4. Save the report and Export to Excel


 
Suggest Edit

Published December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us