Excel Crashes When Sorting Code Below And

I am having a crashing issue with excel after I add a auto filter thru java.

After adding the filter to excel columns if I open the excel sheet and attempt to sort, using the drop down arrow on the column header, it crashes every time.

If I first filter, like unchecking the blanks option from the drop down, then I can sort and use the sheet like normal with no crashes.

If I try to sort using the Sort Filter button in the editing section at the top of excel it will sort just fine but remove the auto filter.

Also if I remove and re-add the filter it doesnt crash and works as expected.

Excel Crashes When Sorting Code Below And

Is there a way to make it to where we can add the auto filter thru java then be able to sort before making any other changes to the sheet I have pasted my code below and I have attached both the excel sheet that is create thru java and pre and post fixing it.

FileInputStream fileIn new FileInputStream(C:UsersgriaDesktopFleet Manager Summary.xls).

If POI is generating a file that makes Excel crash, then thats something you need to report to Microsoft They generally are quite keen to make fixes that avoids their software crashing, especially as some crashes may turn out to have security implications above and beyond the DoS effects of the crash.

We can certainly take a look at the issue on the POI side, especially if we can find out what specific bit Excel dislikes, but talking to Microsoft needs to be your top priority here.

I have went to Microsofts community page and posted about the crash as of now.

As far as we see Apache POI is writing the format correctly here, also LibreOffice correctly opens and sorts this document.

If this is still an issue you likely need to use more official Microsoft support channels where you receive more responses.

Excel For Mac Crashes When Sorting