BI Publisher (MOSC)

MOSC Banner

Excel output not displaying all '0' digits

edited Feb 23, 2017 7:22AM in BI Publisher (MOSC) 3 commentsAnswered ✓

Hi,

So I have XML publisher RTF template working fine in Excel output format. One of the fields in the template - 'SHIP_TO_ADDRESS_LINE3', can often be a combination of text and numbers or just one of them, depending on the territory the customer is from.

When it is just text - it displays fine, however when it is just a number and the last digits are 0's, the output is shortened and displayed as '4.01216E+11' instead of the full number '401216000000' - which is what needs to be displayed.

The text form field is set up as type 'regular text' and the form field help text form is simply put as '<?SHIP_TO_ADDR3?>'.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center