Bug 57170

Summary:	BusinessPlan-Example failes Microsoft Office Binary File Validation
Product:	POI	Reporter:	Alexander Roskamp <roskamp>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED WONTFIX
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