This is what I was afraid of. I had read the javadoc that mentioned this. It's a shame that the Microsoft Spec requires the sheet to be encrypted to produce read only cells. My dilemma is that I need to create dynamic spreadsheets to send to end users that allows them to only fill out certain portions. Altering the format can really throw a kink in the utility I wrote to read in the returned spreadsheet. I have been able to protect the workbook level(non password protected). As I understand this only locks the structure of the spreadsheet.
Thanks for all of the excellent hard work on this project. It has really benefited me! R -----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 16, 2002 9:22 PM To: [EMAIL PROTECTED] Subject: Re: Protected Sheet Unfortunately, that switch actually encrypts the workbook. HSSF does not support any kind of encryption. Encryption scares me because I start thinking of potential jail time. -Andy On Mon, 2002-02-11 at 22:21, Randy James wrote: > Hello, > > I am successfully generating excel files using the hssf package. Now the client is requesting certain cells to be locked or hidden. I have found the methods to hide and lock cells but I understand that the sheet must be protected in order for these properties to take effect. Is there an easy way to protect the sheet with the high level APIs? All I really need to do is flip the switch to protect the Sheet. I hope this is the correct forum to ask this. > > Thanks > > R > -- > > _______________________________________________ > Win a ski trip! > http://www.nowcode.com/register.asp?affiliate=1net2phone3a > > -- www.superlinksoftware.com www.sourceforge.net/projects/poi - port of Excel format to java http://developer.java.sun.com/developer/bugParade/bugs/4487555.html - fix java generics! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh
