Excel Output From BI Publisher or XML Publisher is Trimming Leading Zeros in Excel Template
By Jag - August 20, 2013
To implement the solution, execute the following steps:
1. In the rtf template, use the "Insert -> Symbol" function to insert a very small
0xA0 (NO-BREAK SPACE) character (font size 1 or 2pt) in front of the number string field.
2. One can also try:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?format-number:INVOICE_NUMBER;'09999999'?> </fo:bidi-override>"
1. In the rtf template, use the "Insert -> Symbol" function to insert a very small
0xA0 (NO-BREAK SPACE) character (font size 1 or 2pt) in front of the number string field.
2. One can also try:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?format-number:INVOICE_NUMBER;'09999999'?> </fo:bidi-override>"
3. Another option:
During XML template design, Instead of the using the tag < ?TAG_NAME ? >
use ="<?TAG_NAME?>". It wraps the value with double quotes. Now Excel treat value as character and doesn't trim the leading zeors of value.
Note: space between < and ? and tag name is not requried.
4. Retest for the issue
During XML template design, Instead of the using the tag < ?TAG_NAME ? >
use ="<?TAG_NAME?>". It wraps the value with double quotes. Now Excel treat value as character and doesn't trim the leading zeors of value.
Note: space between < and ? and tag name is not requried.
4. Retest for the issue
For more information search in metalink [ID 417811.1]
0 comments