How to suppress excel warnings using POI?

[rama <ra...@gmail.com>]

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: How to suppress excel warnings using POI?

[Mark Beardsley <ma...@tiscali.co.uk>]

You could always use a custom number format -
http://support.microsoft.com/KB/81518 - this would allow you to show leading
zeros and, if the requirement changes, still use the value in formulae.



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-suppress-excel-warnings-using-POI-tp5717632p5717636.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org