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 2013/06/24 11:35:35 UTC
[Bug 55130] New: provide method HSSFSheet.lockSelectLockedCells
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
Bug ID: 55130
Summary: provide method HSSFSheet.lockSelectLockedCells
Product: POI
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: stefan@endrullis.de
Method XSSFSheet.lockSelectLockedCells allows to disable the cell selection for
locked cells. I wonder why this method is not available for HSSFSheets since
the old Excel format (1997-2003) also supports this feature. It would be great
if we could set this flag via Apache POI.
--
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 55130] provide method HSSFSheet.lockSelectLockedCells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
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 55130] provide method HSSFSheet.lockSelectLockedCells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
--- Comment #6 from stefan@endrullis.de ---
Created attachment 30480
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30480&action=edit
Protected Excel sheet where cells are unselectable
--
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 55130] provide method HSSFSheet.lockSelectLockedCells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
--- Comment #5 from stefan@endrullis.de ---
Created attachment 30479
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30479&action=edit
Protected Excel sheet where cells are selectable
--
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 55130] provide method HSSFSheet.lockSelectLockedCells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Are you able to work out what record is involved, and what needs setting on it?
(If not, best way to find out is probably to create a file with that lock set
in excel, then open a copy and change it to a lock format POI does support,
then use BiffViewer to see what records changed)
--
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 55130] provide method HSSFSheet.lockSelectLockedCells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
--- Comment #3 from Nick Burch <ap...@gagravarr.org> ---
Hmm, how odd. Might be worth trying one other kind of locking just to be sure.
Otherwise, do please upload the two files, and hopefully at some point someone
will work out what has changed...
--
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 55130] provide method HSSFSheet.lockSelectLockedCells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
--- Comment #4 from stefan@endrullis.de ---
I made two more experiments with BiffViewer:
1) Comparing a protected document with an unprotected document.
2) Comparing two protected documents (one with "Format cells" check and one
without this flag).
In case 1 I see a lot of differences in the BiffViewer output. In case 2 the
output is equal again.
So we know that BiffViewer is unable to recognize at least 2 of these options:
http://www.lytebyte.com/wp-content/uploads/2009/06/protectsheetinexcel2007.png
--
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 55130] provide method HSSFSheet.lockSelectLockedCells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55130
--- Comment #2 from stefan@endrullis.de ---
OK, I created two xls files: one with the selection lock and one without.
Unfortunately BiffViewer returned exactly the same output for both files. :(
If you like, I can send you both xls files.
--
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