TimeStamp format Issue

When exporting data to excel, the "Timestamps" format differ between Qlik Sense straight table and Excel file. 

Example Wrong format
Expected format Result
Environment

• Qlik Sense All versions
• Qlikview All versions

Known issue, bug QLIK-83478 
This bug was closed by R&D as WAD,

”--------------
Working As designed:
Using milliseconds in Excel requires that a specific custom format is being defined and aligned with the correct locale of the Excel instance. Furthermore, in Excel, milliseconds are normally expressed as seconds and tenths ("s.0"), seconds and hundreds ("s.00"), second and thousands ("s.000") and this is somewhat different from our fraction (“s.f”), (“s.ff”) and (“s.fff”) that does not automatically translate into its Excel counterpart.

In order to correctly export and interpret milliseconds from QlikView / QlikSense to Excel, a custom format that requires correct decimal separator as defined by locale (example: ",") must be established in Excel. Example for local Swedish, the correct custom format would be: “mm:ss,000” since locale Swedish use comma as decimal separator.

Please note that:
a) Our internal fraction (“.fff”) is compatible with some databases and programmatic millisecond formats, but unfortunately not with Excel.
b) Exporting the values a text strings may be a perfectly valid option unless further arithmetic’s are required (it’s simple and does not require any interpretations).

Example solution
data:
Load timestamp(Timestamp, 'DD/MM/YYYY HH:mm:ss.fff') as Timestamp, Date(Date, 'DD/MM/YYYY') as Date, Dim1, Value;
Load * Inline [
Timestamp, Date, Dim1, Dim2, Value
01/01/2019 00:00:00, 01/01/2019, A, B, 1.0
01/01/2019 00:10:00, 01/01/2019, A, B, 1.0
01/01/2019 00:20:00, 01/01/2019, A, B, 1.1
];
--------------------