Kbase P52374: Dynamics: ExportToExcel and character value looking like exp
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/11/2003 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.X
SYMPTOM(s):
BrowseToolBar Export to Excel does not handle well character data that look like numeric exponential notation
CAUSE:
Known issue development aware. When a Character field has a value like '111E3' (digits, and one 'E' in the middle), Excel takes it as an exponential notation and converts it to a numeric 1.11E05 (1.11 x 10 to power 5)
FIX:
To fix it, change the following in adm2/exportdata.p/exportToExcel:
WHEN "CHARACTER":U THEN
ASSIGN ttTable.cCell = '"':U + ttTable.cCell + '"':U /* csv file wants quotes around characters */
to
WHEN "CHARACTER":U THEN
ASSIGN ttTable.cCell = '="':U + ttTable.cCell + '"':U /* csv file wants quotes around characters */
=> notice the equal sign before the first double quote
Prior 2.1A, the export to Excel procedure was located into adm2/data.p