My Oracle Support Banner

E1: GRID: Cannot Export More Than 20 Grid Rows to Excel or CSV by Range in Any Supported Browser (Row Selection) (Doc ID 2590974.1)

Last updated on SEPTEMBER 20, 2019

Applies to:

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


When using the Export to Excel or Export to Comma Separated Values (CSV) by Range option, if user selected more than 20 rows of records for the Range (using row header to select rows in Export Assistant), only the first selected row is actually exported. 

This issue occurs in all supported browsers. 

Issue does not occur if user selects Starting Cell and Ending Cell by clicking on the Cell instead of clicking on the Row Header in Export Assistant.

Issue does not occur if user selected less than 20 - 25 records for export.

Below shows the steps to duplicate this issue: (Note: Issue occurs in any application grid)

Error 1

  1. Enter P0411 in fast path.

  2. On Supplier Ledger Inquiry form, click Find.

  3. Click on the > Next icon above the grid to bring in more records into the grid (example Records 1 - 70)

  4. Click on the Export Grid Data icon .

  5. On Export Assistant screen, selects Export Options = Export to Excel and Define Cell Range = Range.

  6. The data will appear in the grid at the bottom for selection.

  7. Select the starting row. Example, click on Row Header for Row 3. (Note: Click on the Row Header, not in the cell. System will populate Starting Cell:  Col A Row 3 and Ending Cell: Col AZ Row 3)

  8. Select the end row. Example, click on Row Header for Row 68.  (Note: Click on the Row Header, not in the cell. System will change Ending Cell to:  Col AZ Row 68) 

  9. Click Continue.

  10. Click Save for the message “Do you want to save Book1.xls from xxxxxxxx?”.

  11. Click Open for the message “The Book1.xls download has completed.

  12. Click Yes to open the file for the message "The file you are trying to open, 'Book1.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

  13. When the saved file is opened, only the first selected row is actually exported into the Excel file.  NOTE: If user selects less than 20 rows, the export works correctly.


Error 2

  1. Repeat steps 1 to 8 above.

  2. Click Reset Selection button.

  3. Once user click Reset Selection, user cannot select any row or any cell on the available grid data. 




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

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