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
