For a more complete answer take a look at org.apache.poi.hssf.record.FormatRecord http://cvs.apache.org/viewcvs/jakarta-poi/src/java/org/apache/poi/hssf/record/FormatRecord.java
Lo�c Lef�vre wrote: >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). > yes > >and what about that 0xA4 byte? > See the above mentioned record. > >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? > The undocumented formats we'll just have to figure out ourselves and document them. From there we should adapt the usermodel to work with different defaults for different localities. I think you need to familiarlize yourself with the low level model in order to work with this. Start at the stuff in usermodel and then work backwards to "model" and then the acutal records that make it up. If you haven't bought the Excel 97 Developer's Kit then do so, it will answer a lot of questions for you before you know you have them. :-) Some of those undocumented formats will be troublesome, and we should endevour to back-document them to the OpenOffice.org documentation. Does that help? -Andy > >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 > >
