poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Stadler <dominik.stad...@gmx.at>
Subject Re: Auto Filter on Protected Sheet
Date Thu, 11 Feb 2016 15:34:31 GMT

Not sure, but that sounds like Excel itself puts that limitation on
editing/autofiltering here. POI just sets the respective flags in the

If you can create an Excel file with Excel which works like you intend,
then we can guide you how you can find the differences in the format of the
Excel file so you can try to get the same with POI.


On Thu, Feb 11, 2016 at 6:52 AM, Michael <michael.a@electronicscience.com>

> Hello Everyone,
> I was wondering if it is possible to set a filter on a protected sheet on
> ColumnA, Row1 for example even though every single cell is locked from the
> first row up to the last.
> I tried setting an autofilter but the dropdown button cannot be clicked if
> the cell is locked.
> Thanks and regards,
> --
> Michael Ardan
> <https://www.avast.com/sig-email> This email has been sent from a
> virus-free computer protected by Avast.
> www.avast.com <https://www.avast.com/sig-email>

  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message