poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 47090] New: Error in "createSheet()" / "cloneSheet()" After "removeSheetAt()"
Date Fri, 24 Apr 2009 04:25:26 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=47090

           Summary: Error in "createSheet()" / "cloneSheet()" After
                    "removeSheetAt()"
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: POI Overall
        AssignedTo: dev@poi.apache.org
        ReportedBy: ytakahashi@bbreak.co.jp


Created an attachment (id=23534)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23534)
Test Spreadsheet

I encountered the following errors when I use "createSheet()" / "cloneSheet()"
after "removeSheetAt()". The test spreadsheet is a .xlsx file which has two
blank sheets.


Case 1
===============
    Workbook workbook = WorkbookFactory.create(new
FileInputStream("Book1.xlsx"));
    workbook.removeSheetAt(0);
    workbook.createSheet();

 Error: java.lang.IllegalArgumentException: The workbook already contains a
sheet of this name


Case 2 
===============
    Workbook workbook = WorkbookFactory.create(new
FileInputStream("Book1.xlsx"));
    workbook.removeSheetAt(1);
    workbook.createSheet();

 Error: org.apache.poi.POIXMLException:
org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the
name '/xl/worksheets/sheet2.xml' already exists : Packages shall not contain
equivalent part names and package implementers shall neither create nor
recognize packages with equivalent part names. [M1.12]


Case 3
===============
    Workbook workbook = WorkbookFactory.create(new
FileInputStream("Book1.xlsx"));
    workbook.removeSheetAt(0);
    workbook.cloneSheet(0);

 Error: org.apache.poi.POIXMLException:
org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the
name '/xl/worksheets/sheet2.xml' already exists : Packages shall not contain
equivalent part names and package implementers shall neither create nor
recognize packages with equivalent part names. [M1.12]


Case 4
===============
    XSSFWorkbook workbook = new XSSFWorkbook();
    workbook.createSheet();
    workbook.removeSheetAt(0);
    workbook.createSheet();

 Error: org.apache.poi.POIXMLException:
org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the
name '/xl/worksheets/sheet1.xml' already exists : Packages shall not contain
equivalent part names and package implementers shall neither create nor
recognize packages with equivalent part names. [M1.12]

-- 
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


Mime
View raw message