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