Direct links to fixes
APAR status
Closed as fixed if next.
Error description
Go to My Reports and select the report name triPeople - Filter - Active Users Run the report and export to Excel In Excel, highlight the blank fields, in the lower right hand corner, if you are using 3.5.0.3, you will not see a count. And if you are looking at 3.5.1.2, you will see a count. This count that gets displayed, is throwing off pivot tables when they are created from an exported report.
Local fix
Problem summary
Null data was being placed into the xlsx as an empty string ("")
Problem conclusion
The new formatting to Excel in xlsx format now handles blank/null data as it did before with the xls format. This is targeted to the 1h2017 release.
Temporary fix
Comments
APAR Information
APAR number
IV92427
Reported component name
TRI APPLCATION
Reported component ID
5725F26AB
Reported release
351
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-01-19
Closed date
2017-01-20
Last modified date
2017-01-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
999
Fix information
Applicable component levels
R352 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"351","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
30 March 2022