My Oracle Support Banner

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.

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

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