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]
