Hi, Well I can tell you that I've the same problems as you: -1- I can't use French formats (eg: 'j' intead of 'd' for day) -2- I can't use / create my own format like mmmm\-yyyy for example
AFAIK, it's related to the localization of POI that is not internationalised yet. For the first problem, you can use the english formats (though they can not give you satisfaction) but for the second problem, you'll need to wait (perhaps) for the next version of POI :( Hope this helps. Loic -----Message d'origine----- De : Lorenzo Resta [mailto:[EMAIL PROTECTED]] Envoy� : vendredi 5 avril 2002 11:36 � : 'Poi-User (E-mail) Objet : Dates in Excel Hi, Just a question on Dates in Excel. Since dates are not properly supported yet (in POI 1.20) , i have to check the format number with getCellStyle().getDataFormat(). This works fine, as long as people use the Date specific formatttings in Excel. But whenever someone uses a custom format like 'JJJJMM', where as 'J' stands for 'Year' and 'M' stands for 'Month', things get very unreliable, since the format number that Excel uses in this case varies from 169 -178. Additionally Excel seems to use the same format numbers also for non-date related custom formats, so things get very nasty at this point, since i can' t properly figure out what is a date and what not. Has someone an idea, how to handle such custom formatted dates correctly in POI? Thanks a lot Lorenzo
