ProtectSheet and auto-Filter cannot work in same time

[Jammy Cheng Chen <Ja...@dextrys.com>]

Hi guys,

 

I used the following code to enable auto-Filter function. 

 

_sheet.setAutoFilter(CellRangeAddress.valueOf(cellRange)); 

 

It worked so I can filter some row by clicking header row of excel. But
if use password to protect this Sheet(_sheet.protectSheet("password");

). Then the generated excel I cannot click header row to filter, in fact
the header row has disable to click. I want both protectSheet and filter
are available. 

 

Is anybody can help me on this?

 

 

Thanks

Re: ProtectSheet and auto-Filter cannot work in same time

[Nick Burch <ni...@alfresco.com>]

On Tue, 15 Mar 2011, Jammy Cheng Chen wrote:
> I want both protectSheet and filter are available.

I'd suggest you create a very simple file with both from excel and also 
from poi. Then, use hssf.dev.BiffViewer to try to spot what's different 
between the two. That might help track down where the problem lies

Nick

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