Issue when Importing Excel Spreadsheets Containing Formulas
(Doc ID 2459231.1)
Last updated on JUNE 30, 2023
Applies to:Oracle Enterprise Data Quality - Version 22.214.171.124.0 and later
Oracle Enterprise Data Quality on Marketplace - Version 126.96.36.199.3 and later
Information in this document applies to any platform.
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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!