My Oracle Support Banner

Excel, Cell Formatting for a Template (Doc ID 1528415.1)

Last updated on MARCH 30, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version to [Release 11.1]
Information in this document applies to any platform.


The cell size is not correct for dynamic Excel output.

In XLS (Excel 2003) output, the report is generated with all its columns
with content adapted to the size or set in the template without considering
the size of the template defined within Word (sheet layout settings).
If the same template is generated with an XLSX output, it considers septate
layout settings in Word, and then if the report contains several columns,
not all are generated.

Code used in the template is:

Reproduced in BIPublisher Desktop
Excel 2000 preview is ok
Excel preview errors
RTF and PDF preview error as well



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

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