Ok I have a problem. I have a column in my worksheet which may have number or alpha numeric text. Also the number may be prefixed with zeros which need to be preserved. So I formatted those cells as text. But I get the error of excel. Please can you suggest some workaround for this.
- Minal. -----Original Message----- From: MSB [mailto:[email protected]] Sent: Tuesday, August 18, 2009 1:21 PM To: [email protected] Subject: Re: Green corner on storing number in text cell 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
