My Oracle Support Banner

EDQ Issue When Importing Excel Spreadsheets That Contains Formulas (Doc ID 2459231.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Enterprise Data Quality - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

When importing data from Excel spread sheet which contains formulas using EDQ Studio, null values are loaded instead of the actual values.

Also the preview using EDQ Studio shows null.


This behavior is not consistent across the Excel files (especially the small sized files, or the files not using formulae within spreadsheets)

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
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.