My Oracle Support Banner

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

Last updated on MARCH 12, 2021

Applies to:

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


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)


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.