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? |
|||||||||||
| |||||||||||