Leading zero issues/ Number Formatting while opening in Excel
In case of Oracle XML Publisher report which needs to be opened in Excel, Excel tends to manipulate with the formats of Number and Date. This is really annoying as all the formatting that has been achieved through the Program or Formatting tags in Template don't seem to work.
A simple solution for this problem is to override the Excel formatting, by enclosing your XML tag in the template with below XML code
Before:
<?STAT?>
After:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?STAT?></fo:bidi-override>
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database
In case of Oracle XML Publisher report which needs to be opened in Excel, Excel tends to manipulate with the formats of Number and Date. This is really annoying as all the formatting that has been achieved through the Program or Formatting tags in Template don't seem to work.
A simple solution for this problem is to override the Excel formatting, by enclosing your XML tag in the template with below XML code
Before:
<?STAT?>
After:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?STAT?></fo:bidi-override>
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database
4 comments:
Awesome! Great command for developers
Thanks a lot my friend...
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Post a Comment