Bug 20269 - [RFE] Unable to hide cells on Excel sheet
Summary: [RFE] Unable to hide cells on Excel sheet
Status: RESOLVED WONTFIX
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.0.2
Hardware: All All
: P3 normal with 4 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-27 18:41 UTC by deepak
Modified: 2008-12-16 09:45 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description deepak 2003-05-27 18:41:21 UTC
Hi,
 
I am trying to use POI APIs for my project .... I want to hide & lock
particular cells on the Excel sheets 
I know that there are methods in HSSFCellStyle class namely, setLocked() and
setHidden() ......
 
But , they aren't working somehow .....
 
Can you please help me on this 
 
Thanks,
 
Deepak
Comment 1 Andy Oliver 2003-06-04 20:58:09 UTC
To start with: upgrade, you're SEVERAL releases behind and there is NO chance we'll be 
changing 1.0.x code ever.  Changing severity to normal, this isn't any more serious than 
anything else that we don't do (assuming that we don't).  
Comment 2 Yegor Kozlov 2008-12-16 09:45:57 UTC
setLocked() and setHidden() have no effect until you protect the worksheet.
That is, you should call sheet.protectSheet to turn on these options.

Yegor