I'm not keen on chasing bugs with handling spreadsheets that I don't know what generated them. If this was generated with some incorrect/obsolescent piece of software, on option is to just not support files generated with that software. (StarOffice 5.1 was such a case). Regardless we should make sure the file is a valid BIFF8 file before changing anything to accommodate it.
On Tue, 2002-04-02 at 05:58, Marc Johnson wrote: > Well, it's plain to me, then, that what SST record needs to hold is not > plain strings (too bad) but the entire string data elements. > > We still need to figure out what the deal is with Stefan's spreadsheet ... > it's just plain wrong. > > > >From: "Glen Stampoultzis" <[EMAIL PROTECTED]> > > > >Regardless of whether the spreadsheet from Stefan came from SO or not I > >found another case that we do not handle correctly. Attached is a > >spreadsheet I created manually with plain old Excel. > > > >It has the word TEST with various formats applied. > > > >It comes out as: > > > >-------------------------------------------- > >00000000 17 00 00 00 06 00 00 00 04 00 00 54 45 53 54 01 ...........TEST. > >00000010 00 00 41 03 00 00 42 42 42 04 00 00 74 65 73 74 ..A...BBB...test > >00000020 04 00 08 01 00 54 45 53 54 03 00 06 00 04 00 08 .....TEST....... > >00000030 02 00 54 45 53 54 01 00 06 00 03 00 00 00 ..TEST........ > > > > > >Stephans SST record is a different case however: > > > >-------------------------------------------- > >00000000 6B 00 00 00 6B 00 00 00 04 00 00 4D C4 52 5A 07 k...k......M.RZ. > >00000010 00 00 46 52 45 49 54 41 47 04 00 00 54 45 53 54 ..FREITAG...TEST > >00000020 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 ...TEST...TEST.. > >00000030 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 .TEST...TEST...T > >00000040 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 EST...TEST...TES > >00000050 54 03 00 00 4E 45 57 04 00 00 54 45 53 54 04 00 T...NEW...TEST.. > >00000060 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 .TEST...TEST...T > >00000070 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 EST...TEST...TES > >00000080 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 T...TEST...TEST. > >00000090 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 ..TEST...TEST... > >000000A0 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 TEST...TEST...TE > >000000B0 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 ST...TEST...TEST > >000000C0 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 ...TEST...TEST.. > >000000D0 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 .TEST...TEST...T > >000000E0 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 EST...TEST...TES > >000000F0 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 T...TEST...TEST. > >00000100 00 00 3F 3F 3F 3F 04 00 00 54 45 53 54 04 00 00 ..????...TEST... > >00000110 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 TEST...TEST...TE > >00000120 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 ST...TEST...TEST > >00000130 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 ...TEST...TEST.. > >00000140 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 .TEST...TEST...T > >00000150 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 EST...TEST...TES > >00000160 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 T...TEST...TEST. > >00000170 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 ..TEST...TEST... > >00000180 54 45 53 54 04 00 00 3F 3F 3F 3F 04 00 00 54 45 TEST...????...TE > >00000190 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 ST...TEST...TEST > >000001A0 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 ...TEST...TEST.. > >000001B0 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 .TEST...TEST...T > >000001C0 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 EST...TEST...TES > >000001D0 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 T...TEST...TEST. > >000001E0 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 ..TEST...TEST... > >000001F0 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 TEST...TEST...TE > >00000200 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 ST...TEST...TEST > >00000210 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 ...TEST...TEST.. > >00000220 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 .TEST...TEST...T > >00000230 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 EST...TEST...TES > >00000240 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 04 T...TEST...TEST. > >00000250 00 00 54 45 53 54 04 00 00 54 45 53 54 04 00 00 ..TEST...TEST... > >00000260 54 45 53 54 04 00 00 54 45 53 54 04 00 00 54 45 TEST...TEST...TE > >00000270 53 54 04 00 00 54 45 53 54 04 00 00 54 45 53 54 ST...TEST...TEST > >00000280 04 00 00 54 45 53 54 08 00 00 4E 4F 52 30 30 31 ...TEST...NOR001 > >00000290 41 31 04 00 00 54 45 53 54 04 00 00 54 45 53 54 A1...TEST...TEST > >000002A0 08 00 00 45 55 52 30 31 39 41 31 04 00 00 54 45 ...EUR019A1...TE > >000002B0 53 54 04 00 00 54 45 53 54 08 00 00 4C 41 4E 30 ST...TEST...LAN0 > >000002C0 30 38 42 31 04 00 00 54 45 53 54 04 00 00 54 45 08B1...TEST...TE > >000002D0 53 54 08 00 00 4D 45 54 30 30 31 41 31 04 00 00 ST...MET001A1... > >000002E0 54 45 53 54 04 00 00 54 45 53 54 08 00 00 50 45 TEST...TEST...PE > >000002F0 50 30 31 30 42 31 04 00 00 54 45 53 54 04 00 00 P010B1...TEST... > >00000300 54 45 53 54 08 00 00 4C 45 49 54 41 30 30 31 TEST...LEITA001 > > > > > ><< workbook.xls >> > > > "Touch passion when it comes your way ... it's rare enough as it is. Don't > walk away when it calls you by name." > Marcus Cole, Babylon 5: Lines of Communication > > _________________________________________________________________ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > -- http://www.superlinksoftware.com http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound Document format to java http://developer.java.sun.com/developer/bugParade/bugs/4487555.html - fix java generics! The avalanche has already started. It is too late for the pebbles to vote. -Ambassador Kosh
