Bug 63708 - Treat Window2 record as optional
Summary: Treat Window2 record as optional
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2019-08-29 22:37 UTC by Sheet JS
Modified: 2019-08-29 22:37 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Sheet JS 2019-08-29 22:37:23 UTC
Context including sample code and a test file: https://github.com/SheetJS/js-xlsx/issues/1612

The Window2 situation is unclear:

- Excel accepts files without Window2 records
- The [official Binary File Format Validator](https://www.microsoft.com/en-us/download/details.aspx?id=26794) accepts files without Window2 records
- The [official specification](https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/a1b3d8b4-7442-41fd-9c57-bbd2a6394082) claims it is required.

The issue here is that we write files without the Window2 record, based on the fact that Excel and the BFFValidator program both accept them without error.  However Apache POI is apparently erroring.  Since Excel does not require it and since the official validator does not require it, the Window2 record should probably be treated as optional