https://issues.apache.org/bugzilla/show_bug.cgi?id=51483
Bug #: 51483
Summary: XSSF locking of specific features not working
Product: POI
Version: 3.8-dev
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
The XSSFSheet class has methods to lock only specific features on that sheet,
such as column or row deletion. However, these don't appear to work in
isolation -- either *everything* is locked, or nothing is. If I execute:
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet s = wb.createSheet("Locking");
s.lockDeleteColumns();
s.enableLocking();
wb.lockStructure();
save(wb, "locking.xlsx");
Then I would expect a worksheet that allows all changes except column deletion.
However, the result is a completely locked-down worksheet, similar to what I
would get with a "protectSheet()" call. If I comment out the
"s.enableLocking()" line, then *all* changes are permitted.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
