Summary: | provide method HSSFSheet.lockSelectLockedCells | ||
---|---|---|---|
Product: | POI | Reporter: | stefan |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | NEW --- | ||
Severity: | enhancement | ||
Priority: | P2 | ||
Version: | unspecified | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Attachments: |
Protected Excel sheet where cells are selectable
Protected Excel sheet where cells are unselectable |
Description
stefan
2013-06-24 09:35:35 UTC
Are you able to work out what record is involved, and what needs setting on it? (If not, best way to find out is probably to create a file with that lock set in excel, then open a copy and change it to a lock format POI does support, then use BiffViewer to see what records changed) OK, I created two xls files: one with the selection lock and one without. Unfortunately BiffViewer returned exactly the same output for both files. :( If you like, I can send you both xls files. Hmm, how odd. Might be worth trying one other kind of locking just to be sure. Otherwise, do please upload the two files, and hopefully at some point someone will work out what has changed... I made two more experiments with BiffViewer: 1) Comparing a protected document with an unprotected document. 2) Comparing two protected documents (one with "Format cells" check and one without this flag). In case 1 I see a lot of differences in the BiffViewer output. In case 2 the output is equal again. So we know that BiffViewer is unable to recognize at least 2 of these options: http://www.lytebyte.com/wp-content/uploads/2009/06/protectsheetinexcel2007.png Created attachment 30479 [details]
Protected Excel sheet where cells are selectable
Created attachment 30480 [details]
Protected Excel sheet where cells are unselectable
|