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
>
>
>
