Bug 57170

Summary: BusinessPlan-Example failes Microsoft Office Binary File Validation
Product: POI Reporter: Alexander Roskamp <roskamp>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: 3.10-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Attachments: Validation-Output / BiffViewer-Output / Sample-File

Description Alexander Roskamp 2014-10-31 09:47:38 UTC
Created attachment 32170 [details]
Validation-Output / BiffViewer-Output / Sample-File

We are creating Excel-XLS files with Apache POI (Version 3.10.1-20140818). Now one of our customers is having some problems with these files. When he tries to open it with Microsoft Excel 2007, he gets a warning "Sicherheitswarnung - Office-Dateiüberprüfung" (see warning.png in zip-archive) and he has to click on "Öffnen" (open) each time he tries to open one of our excel-documents. I guess that this warning is like what is described in http://support.microsoft.com/kb/2501584/de respectively http://support.microsoft.com/kb/2501584/en

So i created a simple demo file and tested it with the "Microsoft Office File Validator". The file failed the validation test. Also the "Business Plan"-Example (http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/ss/examples/BusinessPlan.java) failed this validation test.

The output of BiffViewer was no help to me.

Can You help me?

You will find all files (concerning the BusinessPlan-Example) in the attached ZIP-file.

Kind regards,
Alexander Roskamp
Comment 1 PJ Fanning 2022-08-28 11:00:24 UTC
This is not much use without the code that was used to produce the xls file