Why is this excel file created from my Java code crashing?

Question

I have an excel file that I generate thru SSRS and then have a Java program that opens that file and adds an auto filter, then saves and closes. The problem comes in that when you open the file and attempt to sort using the filter drop down on the column headers excel crashes and gives the following message: "A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available." When you reopen excel it brings up a recovery file that is exactly like the one that crashed but the filter has been removed from all headers. If you first filter using a column header drop down then try to sort it does not crash and works as expected.

I am using the POI 3.13 Library in Java. I have reported this to them as a bug since this works if I add the filter thru regular excel. But they still wanted me to make Microsoft aware of the crash stating that if it was a POI error then I should get a error notification. Link to POI bug report: https://bz.apache.org/bugzilla/show_bug.cgi?id=60651

As a side note if you try to filter by using the Sort & Filter button in the editing section in the top menu it sorts just fine but removes the filters.

Answer 1

Hello, am reply due to still no feed back. Thanks for any and all help.