DO NOT REPLY [Bug 17474] New: - Method cloneSheet not working on sheets with diagrams

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17474>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17474

Method cloneSheet not working on sheets with diagrams

           Summary: Method cloneSheet not working on sheets with diagrams
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: ndz43wv02@sneakemail.com


If I have a simple Excel file with a single sheet with a diagram in it,
try to clone it, I get the following Exception:

java.lang.RuntimeException: The class org.apache.poi.hssf.record.ProtectRecord 
needs to define a clone method
	at org.apache.poi.hssf.record.Record.clone(Record.java:247)
	at org.apache.poi.hssf.model.Sheet.cloneSheet(Sheet.java:291)
	at org.apache.poi.hssf.usermodel.HSSFSheet.cloneSheet
(HSSFSheet.java:149)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.cloneSheet
(HSSFWorkbook.java:351)

There is no encryption used in the book, it is a simple Excel file created from 
scratch (Using Excel 2000 SR-1). I read and write the file using the following 
code:

HSSFWorkbook book = new HSSFWorkbook(new FileInputStream(path));
book.cloneSheet(0);
FileOutputStream fOut = new FileOutputStream(XLS_PATH + XLS_OUT);
book.write(fOut);
fOut.close();

The POI version I use is
jakarta-poi-1.11.0-dev-20030225.jar