E-PC: Issue When Using PSSpreadsheet Class Methods SetCellString and/or SetFieldFormula on Date Columns: as of Certain Number of Rows/Columns, it Loses The Formatting.
(Doc ID 2612424.1)
Last updated on AUGUST 13, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
When using PeopleCode's PSSpreadsheet Class Methods SetCellString and SetFieldFormula on date columns, the pre-defined formatting of the cells are lost, after a number of processed rows/columns.
The issue can be reproduced at will with the following steps:
1. Create Application Engine that generates an Excel spreadsheet, through PeopleCode Class PSSpreadsheet, using SetCellString and/or SetFieldFormula on date columns.
2. Run the Process to generate a file that handles over 10000 rows
3. At around line 6545, the dates cells lose their formatting.
What was supposed to be shown as: 10/16/2015, shows as 42293.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document