asked on November 12, 2025
FM does not retain default format of the date while exporting to MS Excel. In one of the tickets here the issue was raised and FM team member provided the link. There was no follow up but the link produced the same error.
https://jsfiddle.net/flexmonster/s48e6jah/
This is the view inside the report produced by FM in the browser
When the document is exported to MS Excel on a US-based computer, the date format breaks. We spent countless hours trying to resolve it.
The post on jsfiddle was supposed to show how it formats the dates consistently, but is does not.
⋅ November 12, 2025
We opened the file generated by Excel export. Below is the style.xml
Notice how numFmtId="164" is forced to the choice for date format. This is a bug and needs to be fixed.
In your source code you have the following
S.ud.format.Ht(164,"dd.mm.yyyy h:mm:ss")
which prevents Excel to use locale for date formatting.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<styleSheet
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac"
xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">
<numFmts count="1">
<numFmt numFmtId="164" formatCode="dd.mm.yyyy h:mm:ss"/>
</numFmts>
<fonts count="2" x14ac:knownFonts="1">
<font>
.....
⋅ November 13, 2025
Any input?
⋅ November 14, 2025
Hello,
Thank you for contacting us.
When exporting to Excel, Flexmonster defaults the resulting date format to the one used by the user's operating system. It means that the displayed date format in the exported file is determined by the regional settings of the user's operating system and Excel configuration.
Currently, Flexmonster cannot override this behavior out of the box during export, as Excel and the local environment control it. However, your suggestion to set the format sounds reasonable. As a workaround, you can customize the exported sheet with the exportTo method and destinationType parameter set to "plain". With this configuration, the exported sheet is passed to a callback handler as an Uint8Array that can be manually customized and downloaded using an external library, such as SheetJS.
Additionally, you can customize the Toolbar to add the custom Excel export handler to the existing UI: https://jsfiddle.net/flexmonster/tan7kco6/. This sample only includes adding the custom export handler; further export implementation is expected to be done on your side.
We hope it helps.
Kind regards,
Nadia
⋅ 7 days ago
With all due respect, it does not. We have developers in 3 countries and export from FM is exactly the same. There are number of tickets highlighting the issue. We ended up cloning the file serving different library for different locale, but that is a hack(ish) solution.
Again, in the code you have a hardwired format, establishing all dates to be posted as 164 and dd.mm.yyyy h:mm:ss
We were able to resolve as we have created our own Excel export of the HTML tables. But FM team needs to look at the code and fix it.
⋅ 4 days ago
Hello,
Thank you for the response.
We are glad to hear that you resolved this issue. Regarding the format, we will add this to our backlog.
We hope this information meets your needs.
Kind regards,
Nadia
