Nick,Mark; Thanks for your quick responses. I tried upgrading POI version to latest stable release 3.9 & with MS Office 2010..still issue is reproducible. Let me explain complete requirement from my side: I have web based application where in users can select different date formats like DD-MMM-YYYY,MM-DD-YYYY,YYYY-MM-DD so on. So user selects date format as per his/her choice & date field related data gets rendered on browser as per user selected date format.Application also provide option to export such data in excel so whats happens is this data gets exported into Excel using POI APIs..& data gets displayed in format set in date format of machine[columns are exported as Date columns].If i right click & choose format set & set format as per what is set in application then format data get displayed with selected format permanently.But i want default behavior as when data is exported in excel it should get rendered with date format in application; my user's do not want additional work of formatting cells for each date column every time they export excel file.Hope, problem is clear now; my guess is that during format cells operation in cell, it must be setting some metadata flag; so is it possible to set such flag from POI side while generating excel file?
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-Date-cells-with-different-date-formats-generates-Excel-cell-with-custom-data-type-insteade-tp5711889p5712001.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
