Hi,
I have date column on igx grid with date filter with column data as (6/30/2021, 3/16/2020....).
While exporting to excel this date column is exporting as text in excel (shows text filter in excel column).
Please advise.
Thank you for contacting Infragistics Community!
I believe you will find the Export to Excel topic in our official documentation very helpful. As you can observe within the first example of this topic you can export the igxGrid to Excel. Once you do this, you will find that the values in the OrderDate column are of type Date and that the correct date filtering strategy is being used. Having this in mind, I assume two possible reasons for the described behavior:
In case that you are using IgniteUI for Angular 12.x, have the dataType property set to 'date' and the issue still persists I suggest modifying the following sample so that it reproduces the described behavior and send it back to me. This will give me the opportunity to debug it on my side and to provide you with solution as soon as possible.
Looking forward to hearing from you.
Best Regards, Martin Evtimov Associate Software Developer Infragistics, Inc.
I am on "igniteui-angular": "^8.2.3",
Below is my igx column: