The issue you're having with scientific notation is, I think, an Excel issue.

Open a new workbook and type a long numeric string into a cell - it will be displayed as scientific notation. Change the Format of the cell to Number and it is displayed as a normal number.

Might want to SORT your data.

Also, your USAGE=value does not include a decimal, AND is very large - P19

EXCEL is interpreting this as SCIENTIFIC.

FIELDNAME=INDEMNITY, ALIAS=INDEMNITY, USAGE=P19, ACTUAL=P10,

is also missing a $ sign at the end - ALL your fields are.

Unless this was copied incorrectly, your MASTER may be a problem

This message has been edited. Last edited by: Tom Flynn,

Has this been resolved or is it now an issue for IBI to address due to quirky format returns from WF?

Just curious.

I am in a training class so I have not been able to keep up with this.

Dazed are you using IIS or tomcat standalone?

The binary issue with excel is not uncommon if you are using tomcat.

The behavior is due to the fact that microsoft excel is not configured as standard in the
tomcat web.xml mime configuration section.

add the following to web.xml and .xls should work.

 
    <mime-mapping>
        <extension>xls</extension>
        <mime-type>application/excel</mime-type>
    </mime-mapping>

(note the application/excel may be application/ms-excel in earlier versions of tomcat)

You will need to recycle tomcat for it to take effect.