https://bz.apache.org/bugzilla/show_bug.cgi?id=47245
--- Comment #20 from Triqui <[email protected]> --- The bug 41187 was what led to the modification being discussed here. The patch can be seen here: https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java?r1=655278&r2=655277&pathrev=655278 It's nice, and it's working. Except for the fact it throws an exception when everything suggest that it shouldn't. The problem appears when there is one or more RowRecords [ROW] but then there are also one or more cells for a row which has not been defined/declared. For instance, in the document attached there is a single row record: [ROW] .rownumber = 3 .firstcol = 0x0000 .lastcol = 0x0000 .height = 0x0960 .optimize = 0x0000 .reserved = 0x0000 .optionflags = 0x0140 .outlinelvl = 0 .colapsed = false .zeroheight = false .badfontheig= true .formatted = false .optionsflags2 = 0x000F .xfindex = f .topBorder = false .bottomBorder = false .phoeneticGuide= false [/ROW] And then there are several LABELSST records for different rows without a corresponding row record. [LABELSST] .row = 0x0000 .col = 0x0000 .xfindex= 0x0016 .sstIndex = 0x0000 [/LABELSST] [LABELSST] .row = 0x0001 .col = 0x0000 .xfindex= 0x0016 .sstIndex = 0x0001 [/LABELSST] Every comment in this bug and duplicates say that removing the line throwing the exception fixes the problem with no side effects. I really can't see a reason to keep that exception. Maybe Josh Micich could shed some light on this issue. I don't know if he is still involved in the project, though. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
