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 27511] - [PATCH] New Enhancements and some buggs fixed
Date Tue, 20 Jun 2006 14:31:01 GMT
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 juanignaciosl@gmail.com  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: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message