Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Wednesday, April 17, 2013

BI/XML Publisher: Leading and Trailing zeroes truncated for excel reports


Microsoft Excel is too smart and it identifies whether the value in the cell is a Text or number and applies formatting accordingly. This sometimes becomes an issue for us when we are trying to generate an excel report. For example item number 0003463262360 has all the numbers and starts with zero, this when printed in excel report displays it as 3463262360. Hence all the leading zeroes are truncated. Same issue happens when we have decimal and trailing zeroes.

FO formatting options can be used to get away with this problem. Below is the syntax for same.
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?ITEM_NUMBER?>
</fo:bidi-override>
Posted by at
Labels:

2 comments:

  1. UnknownJuly 10, 2016 at 10:35 PM

    This comment has been removed by the author.

    ReplyDelete
  2. AnonymousMay 9, 2018 at 6:11 AM

    Nice blog,good information.Fore more details to check our website.for more information about oracle fusion financials training visit our website.Oracle R12 Financials Training

    ReplyDelete

Subscribe to: Post Comments (Atom)