You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2014/03/26 01:10:59 UTC
[Bug 56316] New: No options to selectively lock/unlock components in
a protected worksheet
https://issues.apache.org/bugzilla/show_bug.cgi?id=56316
Bug ID: 56316
Summary: No options to selectively lock/unlock components in a
protected worksheet
Product: POI
Version: 3.9
Hardware: PC
Status: NEW
Severity: blocker
Priority: P2
Component: POI Overall
Assignee: dev@poi.apache.org
Reporter: noel.toms@gmail.com
Hello,
I am trying to add an AutoFilter option to the header row of an excel sheet
created using Apache POI API. The filters are appearing on the header rows, but
unfortunately I am unable to filter the cell value by clicking on the filters.
I know that the excel sheet has an option to enable only the filter option
when we try to protect the worksheet. Am looking for a similar functionality in
Apache POI.
Any help would be really appreciated
Thanks,
Noel
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 56316] No options to selectively lock/unlock components in a
protected worksheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56316
Andreas Beeker <an...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
Component|POI Overall |XSSF
Version|3.9 |3.11-dev
Severity|blocker |normal
--- Comment #1 from Andreas Beeker <an...@gmx.de> ---
Please attach a manually created excel file with the correct settings.
It's not clear, if you want a solution for the binary or xml based format.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 56316] No options to selectively lock/unlock components in a
protected worksheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56316
--- Comment #3 from noel.toms@gmail.com ---
Hi Andreas,
I have ttached a manually created excel sheet which shows the 'Use
AutoFilter' option while i try to protect the sheet. I am looking for exactly
the same solution which i want to code in Java using Apache POI.
I want to protect the sheet and at the same time i need to enable the
AutoFilter for the sheet after protecting it. Hope this helps.
Thanks,
Noel
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 56316] No options to selectively lock/unlock components in a
protected worksheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56316
noel.toms@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |noel.toms@gmail.com
OS| |All
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 56316] No options to selectively lock/unlock components in a
protected worksheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56316
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 56316] No options to selectively lock/unlock components in a
protected worksheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56316
--- Comment #2 from noel.toms@gmail.com ---
Created attachment 31439
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31439&action=edit
Screen shot showing the 'Use AutoFilter' feature while protecting sheet
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org