My Oracle Support Banner

E-PIA: The Last Zero After The Decimal Is Getting Stripped In Excel Sheet When Using Download Grid To Excel Functionality (Doc ID 2781673.1)

Last updated on JUNE 08, 2021

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.

Symptoms

When using Download Grid to Excel, the last number zero is getting truncated after the decimal.

For example the data in Peoplesoft grid is 90.0 whereas in Excel it's showing as 90.


Replication steps:
----------------
1. Have data in the Peoplesoft grid something like 90.0
2. Click on "Download to Excel" icon on the Grid.
3. Observe the Excel sheet.
4. The number shows as 90 instead of 90.0.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.