Digital Output Format Conversion

Modify the digital output format.

<Td style = "mso-number-format:'' \ @ '';"> '| NVL (L_H.E_NUMBER,' & nbsp ') |

'</Td>

If you want to output the ID card number in BI Pulbisher report Excel and do not display the scientific notation, you can modify the defined rtf template as follows:

Find the ID card number code, right-click Properties-> Add help text, you can see the content in the automatically typed field is as follows:

<? NATIONAL_IDENTIFIER?>

Modify it:

<Fo: bidi-override direction = "ltr" unicode-bidi = "bidi-override"> <? NATIONAL_IDENTIFIER?> </Fo: bidi-override>

 

By default, all exported files in the simple Jsp export html Version execl are text files, which brings unnecessary operations to the business staff. We recommend that you use the following method, you can adjust the exported format type.

 

Mso-number-format: "0"	NO Decimals
Mso-number-format: "0 \. 000"	3 Decimals
Mso-number-format: "\#\,\#\# 0 \. 000"	Comma with 3 dec
Mso-number-format: "mm \/dd \/yy"	Date7
Mso-number-format: "mmmm \ d \, \ yyyy"	Date9
Mso-number-format: "m \/d \/yy \ h \: mm \ AM \/PM"	D-T AMPM
Mso-number-format: "Short Date"	01/03/1998
Mso-number-format: "Medium Date"	01-mar-98
Mso-number-format: "d \-mmm \-yyyy"	01-mar-1998
Mso-number-format: "Short Time"	5: 16
Mso-number-format: "Medium Time"	5: 16 am
Mso-number-format: "Long Time"	5: 16: 21: 00
Mso-number-format: "Percent"	Percent-two decimals
Mso-number-format: "0%"	Percent-no decimals
Mso-number-format: "0 \. E + 00"	Scientific Notation
Mso-number-format :"\@"	Text
Mso-number-format :"\#\??? \/??? "	Fractions-up to 3 digits (312/943)
Mso-number-format: "\ 0022 bytes \ 0022 \#\, \#\# 0 \. 00"	Limit 12.76
Mso-number-format: "\#\,\#\# 0 \. 00 _ \; \ [Red \] \-\#\, \#\# 0 \. 00 \"	2 decimals, negative numbers in red and signed (1.56-1.56)