poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: Green corner on storing number in text cell
Date Tue, 18 Aug 2009 07:51:24 GMT

I could be wrong - and in fact quite often I am so treat this with caution -
but I think I am correct in saying this has nothing to do with your
worksheets but rather with the Excel application itself - POI cannot be used
to alter the application's behaviour. It is Excel's error checking feature
that is producing these little green triangles and the only way to prevent
it from doing so - at least as far as I am aware - is to change a setting
within Excel. How you do this depends on the version you are using - it used
to be simply;

Tools>Options>Error Checking

Since Office 2007, things have got a little more complex, this page will
explain the options to you;



Mark B

Patil Minal wrote:
> Hi,
> I need to store a number as text in a cell formatted as text. But I get
> the green corner on doing so. Is there any solution to remove this green 
> corner, how to achieve this in POI?
> Minal Patil

View this message in context: http://www.nabble.com/Green-corner-on-storing-number-in-text-cell-tp25019188p25020106.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

View raw message