‎20-09-2017 07:57 PM
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
‎12-04-2018 02:36 PM
I would also like to know how to set a default format for an meta attribute like in my case only "yyyy".