cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting calculated fields in DataSets for Excel extract

Highlighted
Contributor

Formatting calculated fields in DataSets for Excel extract

Hi,

 

we are currently using a DataSet in V1R3CP12 to extract data, and export it to Excel via the HOPEX UI. There are 2 fields in particular that appear to cause some issues when exported to Excel:

1) a computed date field: I've set the DataSet PropertyItem to "DateTime". In the DataSet result in the HOPEX UI it shows as expected here in the US - "MM/DD/YYYY". But when I then extract to Excel (using the HOPEX UI), it converts the same date to "DD/MM/YYYY". Is there a way around this?

2) a computed field where we display the objects _HexaIdAbs attribute: when some values get extracted to Excel, Excel reads them as numbers and converts them for example to "7.895E12". Again, is there a way to prevent this?

 

Thanks!

Philippe