poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: DO NOT REPLY [Bug 48900] XSSF doesn't have the method protectSheet as we have for HSSF API
Date Mon, 15 Mar 2010 16:46:55 GMT

This may well sound completely stupid but have you tried using a template
file yet? It may - and that is a big may - be possible to use Excel to
create a template file that is password protected. Then you could open that
file using POI, populate it with data and re-save it away again. I know that
POI passes through anything that it does not recognise and it may well do
the same with this sort of tempate file. If I have the chance later, I will
try it myself to see what happens, after all, what can we lose?


Mark B

PS, the bit of the SpreadsheetML that Yegor is talking about contains the
password for the file but it has been encrypted in some manner. In fact, it
looks something like this;

<sheetProtection password="83AF" sheet="1" objects="1" scenarios="1"
formatCells="0" /> 

where the string 83AF is the password 'password' after encryption.

The best thing you could do would be to conduct some research to find out if
you could identify the encryption algorithm. That sort of information
may/will help the developers to more rapidly address this issue.

Bugzilla from bugzilla@apache.org wrote:
> https://issues.apache.org/bugzilla/show_bug.cgi?id=48900
> --- Comment #2 from viveckrshastri@gmail.com 2010-03-15 15:29:19 UTC ---
> (In reply to comment #1)
>> Please don't abuse Bugzilla. Changing the priority of a bug to Blocker
>> will not
>> help us to fix it sooner. 
>> If you are really interested in fixing this issue - you are welcome to do
>> a
>> research and figure out which bits of the SpreadsheetML are missing. If
>> you
>> need a
>> guidance, please ask, I will be happy to help.
>> Yegor
> Hey Yegor,
> we have the same method sheet.protectSheet("qq"); in the HSSF API and i
> need
> the same for XSSF API.
> Let me know if there is any workaround in XSSF API to protect worksheet
> with a
> password.
> This a kind of show stopper for my project currently. Any help is
> appreciated.
> Thanks,
> Vivek
> -- 
> Configure bugmail:
> https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are the assignee for the bug.
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org

View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-48900--New%3A-XSSF-doesn%27t-have-the-method-protectSheet-as-we-have-for-HSSF-API-tp27878972p27907020.html
Sent from the POI - Dev mailing list archive at Nabble.com.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message