Bug 59920

Summary: Unexpected change in behaviour for XSSFWorkbook.setWorkbookPassword
Product: POI Reporter: David North <dtn-asfbugs>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Linux   

Description David North 2016-08-01 10:00:29 UTC
At some point between 3.14 and current trunk, the behaviour of the following code changed:

XSSFWorkbook.setWorkbookPassword("");

Previously this would result in no password on the workbook, but protection enabled. Now, a password is set which renders the workbook impossible to un-protect (Excel doesn't accept the empty string as a password).

Passing null disables protection entirely; we want an option which protects the workbook but not with a password.

Fix to follow shortly.
Comment 1 David North 2016-08-01 12:51:33 UTC
Fixed r1754744