Friday, 1 July 2016

Prevent Excel from suppressing leading zeros



Oracle BI Publisher - Leading zeros truncated for excel reports - format numbers as text


The Problem is that building groups has a fixed length of four characters, only digits from "0000" to "9999". Excel suppresses all leading zeros, therefore the first building groups are to short, e.g. instead of "0010" only "10" is displayed

Method 4 Here is another way to set format style ‘Force LTR’ in a programmatic way to prevent Excel from suppressing leading zeros:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?XML_ELEMENT?>
</fo:bidi-override>


<fo:bidi-override direction=”ltr” unicode-bidi=”bidi-override”> <?format-number:INVOICE_NUMBER;’09999999′?> </fo:bidi-override>” 

3. Instead of the using the tag < ? INVOICE_NUMBER? >
use  =”<?INVOICE_NUMBER?>”. 


Open the RTF Template in MS Word. Go to Data -> Load XML Data. Once the data is loaded successfully, double click on that field. Under field properties window set the field formatting type as “Regular Text” and set the check box “Force LTR”.

Method 3 This is the best method I have found, In this method we need to use an equal-to symbol before the field and enclose the field in double quotes for example:- =”ENUM” This works only in excel however it will allow you to cut and paste (ie to use the value to search in Oracle) and also to do vlookups. Enum with equalto and quotes

http://oracleappsdna.com/wp-content/uploads/2013/07/Enum-with-equalto-and-quotes.png

Method:

No comments:

Post a Comment