Export Data Store Entity to Excel - Date Format Issue

There is an issue with the Export Data Store Entity to Excel Plugin.

Use Case:

  • There are 2 tables that needs to be exported to excel in order Table 1 at sheet 1, and table 2 at sheet 2
  • Both the tables have one column each defined as date

Issue:

When I export the data,  the date column for Table 1 gets converted to type "General" hence users are not able to do filters on this column. However the column of table 2 retain the type as "Date"

Analysis:

I observed that, the last sheet persist the column type. Meaning, suppose if I add Table 3 as well, the column for Table 1 and Table 2 will become as "General" and Table 3 column will behave correctly.

Please let me know if there is any solution for this.

Thanks.

  Discussion posts and replies are publicly visible