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


Reply via email to