In APEX 20 leading zeros are dropping from CSV export reports when open in Excel
(Doc ID 2729155.1)
Last updated on NOVEMBER 16, 2020
Applies to:Oracle Application Express (APEX) - Version 20.1 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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,
but is not working anymore as
Upgrade to APEX 20.X
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