Protected by Copyscape Web Copyright Protection Software

Search This Blog

Monday, November 25, 2013

Not displaying Zero in Excel in Oracle apps

I have to display my XML output in Excel format. I want the output of INVOICE NUMBER column to be displayed as is it is from the data base.

But the problem is if invoice number having zero with prefix then the zero’s are not displaying…

i.e 002345 is displaying as 2345 only (EXCEL)

But this will works fine in PDF output, but its not working for Excel output.
Use below Syntax.


<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?INVOICE_NUMBER?></fo:bidi-override>