In APEX 20 leading zeros are dropping from CSV export reports when open in Excel
(Doc ID 2729155.1)
Last updated on FEBRUARY 10, 2023
Applies to:
Oracle Application Express (APEX) - Version 20.1 and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
In Previous APEX versions (before APEX 20) below workaround (forcing Excel to interpret a made up column as a string) worked to avoid the removing of leading zeros when a file is downloaded as CSV and imported to Excel
decode(nvl(:REQUEST,'FOO'),'CSV', '="' || col_name || '"', co_name) col_name_excel,
eg: ="089407"
but is not working anymore as
Changes
Upgrade to APEX 20.X
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 |
Changes |
Cause |
Solution |