asked on November 11, 2021
Good afternoon, we are having a problem with the export to excel.
When exporting a pivot to excel the month column is wrong because it shows dates of the previous month, for example the date is 09/01/2021 and in the excel it comes out 08/31/2021 not so when a csv is exported for example!
We are using the custom server but it does not throw error from loading only when exporting to excel from the front!
When exporting to csv it works fine
I attach an example
Cheers
⋅ November 16, 2021
Hello, Marcelo,
Thank you for reaching out to us.
We couldn't reproduce the described issue on our side. You are welcome to check the following JSFiddle example: https://jsfiddle.net/flexmonster/sym4fd7c/. It seems that everything works as expected.
That is why we recommend updating to the latest version. Here is the tutorial on how to update to the latest version: https://www.flexmonster.com/doc/updating-to-the-latest-version/
In case the issue still occurs, please edit the example above to demonstrate the case.
Please let us know if the solution was helpful. Feel free to contact us if other questions arise.
Kind regards,
Nadia
⋅ November 16, 2021
Hello Nadia,
You can reproduce the issue in the following JSFiddle
https://jsfiddle.net/gac6tjqy/1/
Also, I attached two png and the csv.
Thanks!
⋅ November 16, 2021
Hi again Nadia!
I was testing some changes into the config, and if I change the dateTimePattern property from "dd/MM/yyyy HH:mm:ss" to "GMT:dd/MM/yyyy HH:mm:ss", the export to excel its working fine.
I think the problem is that the settings generated by the export tool do not have the GMT included and there is no option to include it when recording them.
So this make me ask you, how can I add this property when I save them?
Thanks!
⋅ November 18, 2021
Hello, Marcelo,
Thank you for your sample and screenshots.
We have managed to reproduce the described behavior. The issue was caused by dateTimezoneOffset property set to 0 in the options object. This property affects only the date in the component, not the export to Excel.
We are going to provide a fix for this behavior in one of the upcoming minor releases. For now, we recommend not using the dateTimezoneOffset property. If you need to set a specific timezone, please use dateTimePattern instead.
Could you please let us know if it helps?
Kind regards,
Nadia
⋅ December 14, 2021
Hello, Marcelo,
We are glad to inform you that issue with export to Excel when using "dateTimezoneOffset" was fixed.
This is included in the 2.9.14 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-14/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please contact us in case any questions arise.
Kind regards,
Nadia
⋅ December 14, 2021
Hello how are you, thank you very much we will try as soon as we can.
Cheers
Alejandro
