Formatting calculated fields in DataSets for Excel extract
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?
Note that in standard HOPEX installation a certificate is installed with expiration on 3rd of February 2020. If your installation cease to work, please have your administrator sign-in and download the new certificate. Thank you for your understanding. Download Certificate+