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; http://support.microsoft.com/kb/291361 Yours 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-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
