E-PIA: 8.59.22, 8.60.10, 8.60.11 Download To Excel File on Grid Pages is Displaying Incorrect Amount
Applying PeopleTools patches: PT 8.59.22, PT 8.60.10, or PT 8.60.11 can result in the following use cases:
The downloaded Excel file on any grid page is showing incorrect values.
USE CASE 1
The first comma (digit separator) is displayed as a decimal point in Excel and the values after the first comma are displayed as three zeros. For example: an amount of 120,000.00 is downloaded as 120.000.
USE CASE 2
If there is a currency symbol in the grid, the downloaded value in Excel is 0.
NOTE: This issue can be replicated on any page that has a grid and Download to Excel function.
For example, it can be reproduced with the following steps: