excel error when exporting a column that uses scientific notation

LabKey Support Forum (Inactive)
excel error when exporting a column that uses scientific notation Ben Bimber  2013-04-26 09:46
Status: Closed
 
We have a table where the format string on a numeric column is: '0.###E00'. When we export this grid to excel (both 97 and 2007 formats), excel gives errors, complaining about bad formatting. The excel error is kinda cryptic:

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error022040_01.xml</logFileName>
<summary>
Errors were detected in file 'C:\Users\bimber\Desktop\Data_2013-04-26_09-40-38.xlsx'
</summary>
<repairedRecords summary="Following is a list of repairs:">
<repairedRecord>
Repaired Records: Format from /xl/styles.xml part (Styles)
</repairedRecord>
</repairedRecords>
</recoveryLog>

however, i think I narrowed the problem down to having a column that uses scientific notation (the format string above). seems like a bug?
 
 
jeckels responded:  2013-04-29 13:38
Hi Ben,

Yes, this seems to be a mismatch between Java and Excel format strings for scientific notation. Excel wants it to be something like "0.##E+00", which Java doesn't support.

https://www.labkey.org/issues/home/Developer/issues/details.view?issueId=17735

Thanks,
Josh