|Summary:||Various Protection options while protecting sheet is not available|
|Product:||POI||Reporter:||Nagin Kothari <naginkothari>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
|Attachments:||The excel sample files|
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.