RE: POI 3.6 XSSFSheet - how can I lock specific user edit actions on a given sheet?

[James Fedor <jf...@axian.com>]

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:markbrdsly@tiscali.co.uk] 
Sent: Friday, January 29, 2010 6:57 AM
To: user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

RE: POI 3.6 XSSFSheet - how can I lock specific user edit actions on a given sheet?

[MSB <ma...@tiscali.co.uk>]

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:markbrdsly@tiscali.co.uk] 
> Sent: Friday, January 29, 2010 6:57 AM
> To: user@poi.apache.org
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org