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.
no solution for this Problem i have the same
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.
Created attachment 26791 [details] The excel sample files The excel sample files
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.