Bug 49023 - Various Protection options while protecting sheet is not available
Summary: Various Protection options while protecting sheet is not available
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC Windows XP
: P2 enhancement with 4 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2010-03-30 11:49 UTC by Nagin Kothari
Modified: 2015-05-31 21:09 UTC (History)
0 users

The excel sample files (39.47 KB, application/x-zip-compressed)
2011-03-22 22:39 UTC, jammy.chen

Note You need to log in before you can comment on or make changes to this bug.
Description Nagin Kothari 2010-03-30 11:49:22 UTC
In Excel when we protect sheet using password there are various option available to protect e.g 'select locked cell' , 'Format cells', 'delete rows' etc. These options while protecting sheets are not available in HSSFSheet protection.
Comment 1 rachid.harradi 2011-03-17 08:17:55 UTC
no solution for this Problem i have the same
Comment 2 Nick Burch 2011-03-17 08:21:43 UTC
Can you identify which records get changed and to what for these settings?

Firstly, I'd suggest creating a few simple related files with excel:
* Two sheets, each with a few rows and cells
* Then protect one sheet with the default options
* Then protect one sheet but with "format cells"
* Then one sheet with a different protect options
* ....
* And with one sheet with multiple protect options picked

Upload these to bugzilla with descriptions as to which is which.

Now, use BiffViewer (org.apache.poi.hssf.dev.BiffViewer) to identify what records and what record options are involved in delivering these different protection settings.
Comment 3 jammy.chen 2011-03-22 22:39:26 UTC
Created attachment 26791 [details]
The excel sample files

The excel sample files
Comment 4 jammy.chen 2011-03-22 22:47:35 UTC
Here I have prepared a few example files with excel:

They both are protected by empty password.
1). default.xls: this sheet has been protected with the default options
2).auto-filter-selected.xls: auto-filter is select except the default options
3).mutiple_selected.xls mutiple options selected.

Also the dump files are supported by using BiffViewer. I have saw there have some different between these dumps files.