Consultor Eletrônico



Kbase P118805: Dynamics exports trailing spaces to Excel
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   9/18/2006
Status: Unverified

FACT(s) (Environment):

Dynamics
OpenEdge 10.1x
Dynamics 2.1B

SYMPTOM(s):

Dynamics exports trailing spaces to Excel

Trailing spaces are exported to Excel with Character data

There is a change in behavior with Dynamics. It now exports character field trailing spaces.

This does not happen with Dynamics 2.1B.

CAUSE:

This is a known issue being investigated by Development

FIX:

To resolve the problem modify the tableOut procedure in dataview.p, to trim the value coming back from the columnStringValue function when assigning it to cCell.

For example:

ttTable.cCell = TRIM({fnarg columnStringValue cColumn}).