poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MSB <markbrd...@tiscali.co.uk>
Subject Re: Suppressing cell errors like xlNumberAsText
Date Mon, 08 Mar 2010 15:54:30 GMT

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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 
> 
> 

-- 
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message