Thanks. I'll apply it shortly and test it (if glen doesn't beat me to it)
-Andy On Mon, 2002-03-18 at 11:57, Laubach, Shawn - TAFB/LAB NCC (SAIC) wrote: > Posted. > > Shawn Laubach > SAIC - Web Developer > B-1B System Support Management Division > OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma > dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562 > > > -----Original Message----- > From: acoliver [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 18, 2002 9:44 AM > To: [EMAIL PROTECTED] > Subject: Re: Headers and Footers > > > Lemmie see the patches and I'll run some unit tests and I'll letcha know if > they're right :-) Post them to bugzilla (see "bug database" on the left nav > of poi website) with [PATCH] prefixing the subject. Thanks a million for > your help! > > Thanks, > > Andy > > >On Mon, 18 Mar 2002 09:39:05 -0600 "Laubach, Shawn - TAFB/LAB NCC (SAIC)" > wrote. > >Are you sure that the header and footer records are 100ccurate. Whenever > >I run Biff Viewer and look at the records, it cuts the last two characters > >off. Also, the length for the strings seem to be 3 less than the length > for > >the record. 1 byte for the length of the string, x number of bytes for the > >string, and 2 bytes for what. In all the Excel files I looked at, the two > >bytes after the string length are nulls. I'm needing to insert headers and > >footers so I wrote some code that updated the record and got some trailing > >gibberish. After playing around, I made the record insert the two null > >bytes after the string length. Updated all the places then can happen and > >everything seemed to work. > > > >If you think that this understanding of the record is valid, I'll send the > >patches for the code. > > > >BTW, the unsigned byte problem occurs in the headers and footers. I fixed > >this also. > > > >Shawn Laubach > >SAIC - Web Developer > > > > > > -- 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
