My Oracle Support Banner

E1: GRID: Columns with ( Formula, Function, Cell Formatting ) are Not Imported from Excel into the Grid or a Blank Screen Appears when ActiveX is Set to False or OLEONLY in jas.ini - and Higher (Doc ID 2820763.1)

Last updated on MARCH 28, 2024

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.


Per E1: GRID: Enhanced Browser Support for Grid Import and Export to Replace ActiveX with Tools Release (Doc ID 2782216.1), following issues are observed :

Symptom 1

Import from excel is working with activeX set to false or OLEONLY in jas.ini but the columns containing formula are not imported, as shown in below screen print. In the excel sheet, the third column is using the formula "=TODAY()" and hence that column is not getting imported into the grid.

Steps to replicate

Symptom 2

Excel sheet contains following :


Cell Formatting
• Number - Custom

After click Upload and Continue, blank screen is displayed. Click Home button, then click <Application> - Import Assistant" in Open Applications. "An error occurred in parent dispatcher." message on-screen is displayed.

Steps to replicate



Updated html instance tools release to or higher and set activeX to False or OLEONLY in jas.ini.


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.