Yes. Lo�c Lef�vre wrote:
>Hemm (hope someone will answer my question), >What is the aim of the method *createFormat* in the >jakarta-poi\src\java\org\apache\poi\hssf\model\Workbook.java file? > >Is this the one that creates the formats I'm speaking about in the >precedent mails? > >TIA >Loic > >-----Message d'origine----- >De : Lo�c Lef�vre [mailto:[EMAIL PROTECTED]] >Envoy� : mercredi 3 avril 2002 15:51 >� : [EMAIL PROTECTED] >Objet : RE: Excel Binary header: english and french formats... > > >The problem, is that I don't understand some of the informations >in the header, if you take the last format: >1E 04 0E 00 A4 00 09 00 00 > >- code: 0x0E >- length: 0x09 >- string: mmm\-yyyy > >does this format overrides the 0x0E format that we can find in >jakarta-poi\src\java\org\apache\poi\hssf\usermodel\HSSFDataFormat.java ? >(eg: m/d/yy). > >and what about that 0xA4 byte? > >In fact I'm a little disapointed finding different code formats: >- english: 0x18, 0x1D, 0x1E, 0x23, 0x35, 0x2C, 0x3D, 0x34, 0x0E >- french: 0x1C, 0x21, 0x22, 0x27, 0x3B, 0x38, 0x43, 0x40, 0x19, 0x1E > >Some are in the set [0x17, 0x24] but some aren't! :( > >Any idea? > >TIA >Loic > >-----Message d'origine----- >De : Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >Envoy� : mercredi 3 avril 2002 15:25 >� : Poi Dev >Objet : Re: Excel Binary header: english and french formats... > > >So can you match those up and parse out the strings and merge them >and/or create the earlier mentioned class structure into the >HSSFCellFormat stuff? > >On Wed, 2002-04-03 at 08:30, Lo�c Lef�vre wrote: > >>Hi, >>Since I didn't find anything on the 0x17-0x24 formats, I've >>studied a little the binary headers of a french and english >>Excel file (.xls) (See attachment for the headers). >> >>As you can see, the red underlined chars specify the formats >>code (0x17-0x24) but I'm not sure of that and I'm searching >>for some confimations... The green underlined chars represents >>the length of the format. >> >>Example (1st french format): >>- code: 0x001C >>- length: 0x0017 (23 chars) >>- string: #,##0\ "F";\-#,##0\ "F" >> >>Waiting for comments, ideas... >>Loic >> >-- >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 > >
