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 2009/02/13 05:08:52 UTC
DO NOT REPLY [Bug 46711] New: java.lang.RuntimeException when trying
to read a sheet having protected cells
https://issues.apache.org/bugzilla/show_bug.cgi?id=46711
Summary: java.lang.RuntimeException when trying to read a sheet
having protected cells
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows Server 2003
Status: NEW
Severity: regression
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: vinu.kumar@gmail.com
Created an attachment (id=23254)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23254)
Repro file for the issue
Trying to read a xls with protected cells give the following exception:
java.lang.RuntimeException: two Page Settings Blocks found in the same sheet
at org.apache.poi.hssf.model.Sheet.<init>(Sheet.java:228)
at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:160)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:287)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:201)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:317)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:298)
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:59)
Tested with the latest trunk
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46711] java.lang.RuntimeException when trying to
read a sheet having protected cells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46711
David Fisher <df...@jmlafferty.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution| |INVALID
--- Comment #5 from David Fisher <df...@jmlafferty.com> 2009-03-11 23:29:01 PST ---
Tomas,
The person that submitted this bug - Vinu - was the one who resolved it as
invalid. I think that he had information in the file which should not be
shared.
Rather than re-opening another issue, you really should submit a new bug. For
instance you say your file was edited in Office 2007 and saved in compatibility
mode. I wonder if you have applied every update to your copy of Office 2007?
How did you edit the file?
Do you get exactly the same error.
Regards,
Dave
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46711] java.lang.RuntimeException when trying to
read a sheet having protected cells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46711
Tomas Prochazka <t....@centrum.cz> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|INVALID |
--- Comment #2 from Tomas Prochazka <t....@centrum.cz> 2009-03-11 00:23:19 PST ---
I have .XLS file which I can normally open by POI library. I open it in Office
2007, edit same values in table and save it. And now I get the same exception
from POI. I really think, that this is big problem. .XLS files which was edited
in Office 2007 can't be open be POI library.
It's really invalid bug report? It's bug in Office 2007?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46711] java.lang.RuntimeException when trying to
read a sheet having protected cells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46711
--- Comment #3 from Tomas Prochazka <t....@centrum.cz> 2009-03-11 00:27:30 PST ---
Created an attachment (id=23368)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23368)
Original file created in old version of Office
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46711] java.lang.RuntimeException when trying to
read a sheet having protected cells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46711
Vinu Kumar <vi...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
--- Comment #1 from Vinu Kumar <vi...@gmail.com> 2009-02-18 09:45:54 PST ---
The sheet had some views specific to some users.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46711] java.lang.RuntimeException when trying to
read a sheet having protected cells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46711
--- Comment #4 from Tomas Prochazka <t....@centrum.cz> 2009-03-11 00:28:14 PST ---
Created an attachment (id=23369)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23369)
File which was edited and saved in Office 2007 with compatibility mode
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 46711] java.lang.RuntimeException when trying to
read a sheet having protected cells
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46711
--- Comment #6 from Tomas Prochazka <t....@centrum.cz> 2009-03-12 00:06:09 PST ---
(In reply to comment #5)
Ok. I entered new issue #46840
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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