There are no plans to support protected anything as it would get us in the business of encrypting things. Because much of the development takes place in the USA which has chosen to take a rather medieval view of encryption, and none of the US based committers are interested in seeing the inside of jail cells should we mess up in any way, any development on this would have to be pluggable and either take place in a country with a more enlightened leadership or utilize libraries that users could download on their own.
-Andy On Fri, 2002-04-19 at 13:22, Kennedy, Niall wrote: > Fernando, > For my needs, I chose to protect every xls file I create. > > > To protect every workbook: > > 1) Open Workbook.java inside the model directory. > 2) In the createProtect() method, change the boolean passes to the > setProtect method to true. > > To protect every sheet: > 1) Open Sheet.java inside the model directory. > 2) Copy and paste the createProtect method from Workbook.java > 3) Inside of the createSheet() method, add the line > "records.add(retval.createProtect());" above the createEOF() add. > > > Every xls file you create is now protected. No password is set, so > end-users with motivation and basic knowledge of Excel can unprotect the > sheet and muck it up. If you are just looking for idiot resistance, this > process works well. > > > > Niall Kennedy > [EMAIL PROTECTED] > > > -----Original Message----- > From: fernando wong [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 18, 2002 3:36 PM > To: '[EMAIL PROTECTED]' > Subject: Creating a Protected Spreadsheet > > > Hi, > > Does anyone know how to create a protected Excel spreadsheet using POI? I > tried to overwrite the createProtect() method of the Workbook object to > return true. > > Currently the only way to do this is to create a Protected spreadsheet > first, and then copy from it. > > If anyone can help with the implementation it will be great. > > thanks, > fernando -- http://www.superlinksoftware.com http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound Document 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
