My Oracle Support Banner

E1: GRID: Exporting Spaces from the Grid to Excel Appearing as One Space Only (Doc ID 2433531.1)

Last updated on AUGUST 09, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When exporting from the grid to excel and having values of blanks like MCU which has 12 spaces they appear in excel as one space only not respecting what is truly stored in the table.

In Data Browser

 

In Excel any existing value respects the 12 character size for MCU but when the value is blank it only stores one space instead of 12.

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!


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