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
"Oracle XML Publisher Report: Number/Date format in Excel"
2 Comments -
Awesome! Great command for developers
July 21, 2015 at 5:13 AM
Thanks a lot my friend...
March 7, 2016 at 5:03 AM