That's a surprise Nick because I just did some simple testing myself - using Excel - and could not store these settings in the file. In short, I created a new workbook, changed the error checking options and then saved the file away. Afdter closing that file, I changed the error checking options again - without the need to have a workbook open - and then reopened the file I had created previously. Opening that file did nto lead to any change on the error checking options and that is why I suspect they are set at the application level and not the workbook level. Admittedly, I did not embark on an serious testing and so will happily be proven wrong.
Yours Mark B Nick Burch-11 wrote: > > On Fri, 5 Mar 2010, Robert Tomanek wrote: >> I would like to programmatically (via POI) set the Ignore property >> for cell errors to True. > > There's currently some low level record support for this, via FeatRecord / > FeatFormulaErr2. However, there's no usermodel support for this, as > no-one's come up with a good way to expose this. > > Short term, you can probably hack something up to inject the required > records (look at the tests for examples of what they need to contain). > Longer term, patches to the usermodel are always gratefully received! :) > > 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-tp27810457p27822473.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]
