DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=27511>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=27511 ------- Additional Comments From [EMAIL PROTECTED] 2006-06-20 14:31 ------- Which version should I apply this patch to? I've tried with 2.5.1 final and several 3.0a with the same results: I can successfully write a file, but when I read it gets stuck in the Workbook constructor, in this loop: while (recOffset < records.size()) { Sheet sheet = Sheet.createSheet(records, sheetNum++, recOffset ); recOffset = sheet.getEofLoc()+1; sheet.convertLabelRecords( workbook); // convert all LabelRecord records to LabelSSTRecord HSSFSheet hsheet = new HSSFSheet(workbook, sheet); sheets.add(hsheet); // workbook.setSheetName(sheets.size() -1, "Sheet"+sheets.size()); } recOffset won't increase, leading to an infinite loop. Is this patch being merged in the svn? I've seen no comment about that... (In reply to comment #8) > How to integrate this code with my code where i am trying to manipulate with > Excel file? > It is throwing some errors. (In reply to comment #3) > Just some additional notes from someone in the field: I have applied his > patches to my own copy of the 2.5 final source. There was one compiler error: > compile-main: > [javac] Compiling 383 source files to /devel/jakarta/poi/build/classes > [javac] > /devel/jakarta/poi/src/java/org/apache/poi/hssf/util/HSSFCellRangeAddress.java:162: > unreachable statement > [javac] return 2 + this.field_addr_number*8;; > [javac] ^ > [javac] Note: Some input files use or override a deprecated API. > [javac] Note: Recompile with -deprecation for details. > [javac] 1 error > > Once you remove the extraneous semicolon, it compiles fine. > > For me the new version successfully reads, alters and writes back out Excel > 2000 > files with validation set to: > 1) a list (ie, yes,no,maybe) > 2) a range of cells (ie, $H1:$H4) > 3) a named external reference (ie, =dropDown) > > I suspect this patch will also fix bug# 27929 and bug# 28136 > > -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
