Great, can you please see if you can match those up and supply a patch that supports:
1. settable Regions 2. other format strings in HSSFCellFormat? Thanks you kindly, Andy On Thu, 2002-03-14 at 04:16, Lo�c Lef�vre wrote: > Here are the french formats > commonly used in SYLK export: > > ---8<--------------------------------------------------------------- > General > 0 > 0.00 > #,##0 > #,##0.00 > #,##0\ _F;;\-#,##0\ _F > #,##0\ _F;;[Red]\-#,##0\ _F > #,##0.00\ _F;;\-#,##0.00\ _F > #,##0.00\ _F;;[Red]\-#,##0.00\ _F > #,##0\ "$";;\-#,##0\ "$" > #,##0\ "$";;[Red]\-#,##0\ "$" > #,##0.00\ "$";;\-#,##0.00\ "$" > #,##0.00\ "$";;[Red]\-#,##0.00\ "$" > 0% > 0.00% > 0.00E+00 > ##0.0E+0 > #" "?/? > #" "??/?? > dd/mm/yy > dd\-mmm\-yy > dd\-mmm > mmm\-yy > h:mm\ AM/PM > h:mm:ss\ AM/PM > hh:mm > hh:mm:ss > dd/mm/yy\ hh:mm > mm:ss > mm:ss.0 > @ > [h]:mm:ss > _-* #,##0\ "$"_-;;\-* #,##0\ "$"_-;;_-* "-"\ "$"_-;;_-@_- > _-* #,##0\ _F_-;;\-* #,##0\ _F_-;;_-* "-"\ _F_-;;_-@_- > _-* #,##0.00\ "$"_-;;\-* #,##0.00\ "$"_-;;_-* "-"??\ "$"_-;;_-@_- > _-* #,##0.00\ _F_-;;\-* #,##0.00\ _F_-;;_-* "-"??\ _F_-;;_-@_- > #,##0.00\ [$F] > ---8<--------------------------------------------------------------- -- 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
