Bug 56307

Summary: Ordering in autofilter crash the excel
Product: POI Reporter: Ivan Skultety <ivan.skultety>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Source code file

Description Ivan Skultety 2014-03-24 04:26:07 UTC
Created attachment 31431 [details]
Source code file

I created simple excel with JXL and then open it with POI to add new sheet with autofilter feature (see attached source code).
When I try to open the result XLS file and use the "Ordering A to Z" in autofilter then Excel crash with this error in Event viewer>

Faulting application name: EXCEL.EXE, version: 14.0.4756.1000, time stamp: 0x4b9c08e8
Faulting module name: MSVCR90.dll, version: 9.0.30729.8387, time stamp: 0x51ea24a5
Exception code: 0xc0000417
Fault offset: 0x000320f0
Faulting process ID: 0x15f8
Faulting application start time: 0x01cf47181abd6b68
Faulting application path: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE
Faulting module path: C:\WINDOWS\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.8387_none_5094ca96bcb6b2bb\MSVCR90.dll
Report ID: 5f127dfc-b30b-11e3-bf6f-84a6c88d5535
Faulting package full name: 
Faulting package-relative application ID:
Comment 1 Nick Burch 2014-03-24 11:17:47 UTC
If you've accidently created a file that crashes Excel, then you need to report that to Microsoft to get them to fix Excel! If we do something wrong, Excel should give an error prompt or a warning, not a crash...
Comment 2 Dominik Stadler 2016-04-07 20:56:21 UTC
I don't think we can do much here for now, Excel should not crash on any file, but rather indicate what is incorrectly formatted.