My Oracle Support Banner

Issue when Importing Excel Spreadsheets Containing Formulas (Doc ID 2459231.1)

Last updated on JUNE 30, 2023

Applies to:

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

Symptoms

When importing data from Excel spread sheet which contains formulas using Enterprise Data Quality (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!

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