Dates not showing inside Excel export

Answered
Tiago asked on March 9, 2023

Hi,
 
I have a problem with exporting excel data, all other export formats display the date field normally, except excel.
Attached I will leave the way the script was made, how it is displayed on screen and the return in excel.
Ps: I used this fiddle https://jsfiddle.net/flexmonster/m2kopf9w as an example and it worked normally, however, in my code the field still does not return data.

7 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster March 10, 2023

Hello, Tiago!

Thank you for reporting an issue.

Our team could not reproduce this behavior with the latest version of Flexmonster using the report provided in script.PNG (see the test JSFiddle) We recommend updating the component if you are using an old version of Flexmonster.
If updating Flexmonster did not help, could you please provide more information regarding the issue, including:

  • The code with the exportTo function is used in your project.
  • The Excel file with missing dates returned on export.

Looking forward to hearing your feedback.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster March 23, 2023

Hi, Tiago!

Hope you are doing well.
We are wondering if you were able to fix the issue with exporting to Excel. 
Please let us know if any further assistance is required.

Best Regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster March 30, 2023

Hello, Tiago!

Our team would like to know if you could resolve the Excel export issue.
Looking forward to hearing from you.

Best Regards,
Maksym

Public
Tiago March 31, 2023

Hello, Maksym!
 
Sorry for the delay. I couldn't solve this problem, I've tried several things like updating the component, using the cdn flexmonster component, I tried to make the code as clean as possible and nothing worked. I even performed a test on jsfiddle with angularjs (like i use in my project) and it also worked normally, only in our project that the dates are not displayed in the excel export. Attached are some files that may help you understand the problem.
AngularJS Excel export (exactly like in our project)
Ps: I also couldn't reproduce this error outside my project.
Best Regards,
Tiago

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster April 3, 2023

Hello Tiago,

Thank you for your response.

It seems that the reason for such behavior is located in your project, and we could not reproduce this issue on our side. Please try debugging export in your project. Also, you can check if there are no overriding methods that may conflict with Flexmonster.

Please let us know if it works for you. Feel free to contact us if other questions arise.

Kind regards,
Nadia

Public
Tiago April 20, 2023

Hello Nadia,
I would like to inform you that I found the problem, it seems that the date.js plugin i'm using in the project has some conflict with flexmonster, since date.js is no longer updated I will remove it from my project. Thanks for all the help.
Best Regards,
Tiago

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster April 21, 2023

Hello Tiago,

Thank you for the update.

We are glad to hear that the issue is resolved.

As always, feel free to contact us in case other questions arise.

Kind regards,
Nadia 

Please login or Register to Submit Answer