E-QR: Query To Excel Data Does Not Fit Within Default Column Width (Doc ID 2142784.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Symptoms

The content cells are stretched in the downloaded excel, so the entire content of the cells is not shown. The width is the width of the column label.


Steps:
---------
The issue can be reproduced with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Create a new PS Query (e.g. SB_TEST_AUTOFIT)
4. View Query SQL:
SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, TO_CHAR(A.ACCOUNTING_DT,'YYYY-MM-DD'), A.VCHR_BAL_ERR_FLG
 FROM PS_VOUCHER A
5. Hit Run tab
6. Download the results to Excel(xlsX) - The column width does not Autofit properly.

Changes

Cause

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