Sorry to hear that James but there are other lockXXX() methods decalred on the workbook. Have you tried any of those? I do not know if they will work but it should be worth trying them out and I am sorry to sound so uncertain but I have bot yet had the opportunity to play around with XSSF in earnest.
Yours Mark B PS. One thing you could do is to produce a very simple workbook using POI and try to lock it as you are doing now. Next, do the same thing using Excel and have a look at the files to see if you can spot any obvious difference; the files are simply zipped xml so you can unpack the archive and then use a simple text editor to have a dig around and anything you discover will nhelp the developers if you have to log this as a bug. James Fedor wrote: > > Thanks, but Unfortunately that doesn't seem to work either. I still can > find no examples of how to do this on the web... > > -----Original Message----- > From: MSB [mailto:[email protected]] > Sent: Friday, January 29, 2010 6:57 AM > To: [email protected] > Subject: RE: POI 3.6 XSSFSheet - how can I lock specific user edit actions > on a given sheet? > > > I think that may be the answer James. Have a look at the lockStructure() > method defined on the XSSFWorkbook class. I have not tried it but I reckon > that you need to call this method in addition - and most likely last of > all > - to actually 'activate' the lock. > > Yours > > Mark B > > > James Fedor wrote: >> >> Thanks Dave, I did try that too and it didn't seem to make a difference. >> Any other ideas? >> >> -James >> >> >> > > -- > View this message in context: > http://old.nabble.com/POI-3.6-XSSFSheet---how-can-I-lock-specific-user-edit-actions-on-a-given-sheet--tp27345689p27373113.html > Sent from the POI - User mailing list archive at Nabble.com. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/POI-3.6-XSSFSheet---how-can-I-lock-specific-user-edit-actions-on-a-given-sheet--tp27345689p27511485.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
