Thanks, you (I) really do live and learn. Yours
Mark B Nick Burch-11 wrote: > > On Mon, 8 Mar 2010, MSB wrote: >> That's a surprise Nick because I just did some simple testing myself - >> using Excel - and could not store these settings in the file. > > It's not impossible that your version of excel isn't storing them in the > file, despite that being possible....! > > Pages 669 and 670 of the excel docs cover FeatFormulaErr2, which is held > in FeatRecord shared features, which in theory allows you to store the > fact that "number as text" should be ignored for a cell range > > We've also got two test files, one with the warnings on, and one with them > off - 46136-NoWarnings.xls and 46136-WithWarnings.xls . I didn't create > them however! > > Nick > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/Suppressing-cell-errors-like-xlNumberAsText-tp27810457p27823222.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]
