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
