Bug 18454 - Protecting an excel file
Summary: Protecting an excel file
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: Other All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2003-03-28 08:20 UTC by Vikranth
Modified: 2005-03-20 17:06 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Vikranth 2003-03-28 08:20:08 UTC
I wanted to generate a protected excel files in which only a few fields will 
be editable. Howerver on reading the FAQ on the HSSF I find it is not possible 
to protect the sheet because MS encrpyts the file, but fields can be  locked.
  To circumvent this problem, I am using an blank excel file which is 
protected, and using my program I am creating a copy of this file first and 
then inserting values into this newly created file using POI. I find that I can 
acheive the desired results.
  Since I plan to extensively use this, has any one used these technique 
before, and encountered any issuses.

Comment 1 Andy Oliver 2003-03-28 13:59:51 UTC
Join the mail list.  Bugzilla isn't the place to ask questions.