Get Free Trial

Problem with export to excel – API Server

Answered
Marcelo Alejandro Gallardo 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

4 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster 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

Public
Marcelo Alejandro Gallardo 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!

Public
Marcelo Alejandro Gallardo 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!

Attachments:
dateTimePattern.png

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster 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

Please login or Register to Submit Answer