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 49023] New: Various Protection options while protecting sheet is not available
Date Tue, 30 Mar 2010 14:35:57 GMT

This is the reason as I understand it. It may not in actula fact be accurate
so do not take what I say next as a defintive statement of fact.

Those protection options were added to the application - I think - when
Excel 2007 was released. This coincided with the introduction of the xml
file format and Micrsosoft took the opportunity to extend the binary file
format to accomodate these new options. If POI modifies the binary file
format parser - HSSF - in line with what Microsoft has done, then it will
mean that the library cannot any longer be used to create files that are
compatible with - readable by - versions of Excel prior to 2007.

Yours

Mark B


Bugzilla from bugzilla@apache.org wrote:
> 
> https://issues.apache.org/bugzilla/show_bug.cgi?id=49023
> 
>            Summary: Various Protection options while protecting sheet is
>                     not available
>            Product: POI
>            Version: unspecified
>           Platform: PC
>         OS/Version: Windows XP
>             Status: NEW
>           Severity: normal
>           Priority: P2
>          Component: HSSF
>         AssignedTo: dev@poi.apache.org
>         ReportedBy: naginkothari@gmail.com
> 
> 
> In Excel when we protect sheet using password there are various option
> available to protect e.g 'select locked cell' , 'Format cells', 'delete
> rows'
> etc. These options while protecting sheets are not available in HSSFSheet
> protection.
> 
> -- 
> 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-49023--New%3A-Various-Protection-options-while-protecting-sheet-is-not-available-tp28081375p28083470.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


Mime
View raw message