DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22939>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22939 Cannot link from a regular xls file to an xls file created by POI. ------- Additional Comments From [EMAIL PROTECTED] 2003-09-11 03:10 ------- What I mean is I ran BiffViewer on the file you attached, which was generated by POI/HSSF. Here is the output. ... Offset 0x992 (2450) recordid = 0x20b, size =20 [INDEX] .firstrow = 0 .lastrowadd1 = 1 .dbcell_0 = a82 [/INDEX] ... Offset 0xa78 (2680) recordid = 0x203, size =14 [NUMBER] .row = 0 .col = 1 .xfindex = f .value = 222.0 [/NUMBER] ============================================ Offset 0xa8a (2698) recordid = 0x203, size =14 [NUMBER] .row = 0 .col = 2 .xfindex = f .value = 333.0 [/NUMBER] ... The INDEX record has a DBCELL pointer to offset 0xa82. (There could be more than one DBCELL pointer in each INDEX record. I don't think BiffViewer necessarily shows them all). But you can see that there is a NUMBER record beginning at 0xa78, and another NUMBER record beginning at 0xa8a. So the DBCELL pointer in the INDEX record is bad -- it doesn't even point to the beginning of any record. After you save the file from Excel, the INDEX records are fixed up, and the DBCELL records are inserted. BiffViewer will show the INDEX record pointing to the beginning of the DBCELL record, as expected. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
