Hi, I have a requirement to export value "00123" to excel using POI retaining leading zeros. I know there is a way to do it by exporting as String instead of number. However excel file shows a warning ( dog-ear) on the cell saying " Number stored as text". How to suppress those warnings in exported file using POI in java program? In MS Excel we can do that manually from options as shown in attached screen.
<http://apache-poi.1045710.n5.nabble.com/file/n5717632/Suppress_warnigs_screen.jpg> -- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-suppress-excel-warnings-using-POI-tp5717632.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]
