Support Article
Round off issues occur while performing Export to Excel
SA-85617
Summary
Export to Excel using the out-of-the-box feature for a data table rounds off to three decimals.
Error Messages
Not Applicable
Steps to Reproduce
- Create a data table with properties containing seven decimal points
- Create instances for the data table
- Perform Export to Excel. Decimal properties are round off to two or three digits
Root Cause
A defect in Pegasystems’ code or rules. PRPC does not honor the pydecimal precision of the decimal property. Hence, always the default value 3 is considered.
Resolution
1) Apply HFix-552712) Restart the server
3) Set the pyDecimalPrecision in the property rule form (advanced tab) for more precision
Published September 6, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.