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 46547] New: ClassCastException in HSSFSheet.shiftRows(...)
Date Fri, 16 Jan 2009 08:30:24 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=46547

           Summary: ClassCastException in HSSFSheet.shiftRows(...)
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: matthew.knl@gmail.com


I use following code to execute shiftRows(...) method in HSSFSheet instance, it
throws ClassCastException.

--

FileInputStream fis = new FileInputStream("9000000001.xls");
POIFSFileSystem fs = new POIFSFileSystem(fis);
Workbook wb = new HSSFWorkbook(fs);
Sheet sheet = wb.getSheet("HouseShippingInstruction");
sheet.shiftRows(1, sheet.getLastRowNum(), 1, false, true);

--

java.lang.ClassCastException:
org.apache.poi.hssf.record.aggregates.DataValidityTable cannot be cast to
org.apache.poi.hssf.record.Record
        at
org.apache.poi.hssf.model.RecordOrderer.findInsertPosForNewCondFormatTable(RecordOrderer.java:163)
        at
org.apache.poi.hssf.model.RecordOrderer.findSheetInsertPos(RecordOrderer.java:102)
        at
org.apache.poi.hssf.model.RecordOrderer.addNewSheetRecord(RecordOrderer.java:90)
        at
org.apache.poi.hssf.model.Sheet.getConditionalFormattingTable(Sheet.java:493)
        at
org.apache.poi.hssf.model.Sheet.updateFormulasAfterCellShift(Sheet.java:448)
        at
org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows(HSSFSheet.java:1238)
        at
org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows(HSSFSheet.java:1133)

--

Thanks a lot!


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