Decision table export changes 5D to 5
When exporting a decision table to xlsx through the out of the box (OOTB) export functionality cells of the format <numeric> + D (for example 5D) are interpreted as just the numeric portion "5" in the exported file even if the property type of the column set is text. This causes loss of information on import.
Steps to Reproduce
- Create a decision table and add a property set for a text property.
- Enter a 5D (or other numeric string with a trailing D or d) to a cell in some row of the text property column.
- Export the data using the Export button on the Table tab for the decision table rule.
- Open the xlsx file and observe the value for that column is changed to 5.
A defect in Pegasystems’ code or rules where the type of the property is not considered for export. The cell's value is determined to be numeric if it's a valid double for the Java language, which 5D satisfies.
Perform the following local-change: Use "5D" with the double quotes in the cell to indicate it is a string value.