Hi
This bug appears in IE 11. If filtering and sorting are set to 'applied' in gridFeatureOptions so that the exported excel document keeps the filtering and sorting, the exported excel document seems to keep the sorting but fails to keep the filtering. In Google Chrome, everything seems to work correctly, both sorting and filtering is kept in the exported excel.
Here is a JSFiddle: http://jsfiddle.net/6kwLe7d3/1/
Using IE11, if you filter some data and sort a column and then click on the export button. The exported excel document will keep the sorting but will not keep the filtering.
Thanks,
Armando
Hi Armando,
Thank you for posting in the Infragistics community !
I have created a support case for you with an ID of CAS-157044-L7D4C5. The matter has been determined to be a development issue and has been logged in our tracking system with ID: 201133. The issue has already been fixed and will be rolled out with the RTM version of the igGridExcelExporter with the 15.2 volume of IgniteUI. You can review the following page which will be updated with approximate schedule time for this 15.2 volume release http://www.infragistics.com/support/service-releases.
Meanwhile I suggest that you use the exportEnding event and to apply filtering to columns in the worksheet. You can see this approach demonstrated at http://jsfiddle.net/6kwLe7d3/5/ . I hope this helps.
Please let me know if you have further questions on the matter.
Thank you very much! :)