My Oracle Support Banner

Spreadsheet Reports Generate Wrong Cell Format for Number Items (Doc ID 562794.1)

Last updated on OCTOBER 30, 2023

Applies to:

Oracle Reports Developer - Version and later
Oracle Forms for OCI - Version and later
Information in this document applies to any platform.


You have used "desformat=SPREADSHEET" when executed a report.

When opening the generated spreadsheet file using a PC that has a local language MS Excel version, some cells displays the value in wrong format - not as number.

The same report is correctly displayed when using an English version of MS Excel.

Selecting the cell and opening "Format Cell" dialog, the Category selected will be "Time".


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.