Re: countif formula issues

[Swapy <sw...@atosorigin.com>]

Please help me for this issues.
We need the solution for this error has soon as possible.

If there is any work around then also that is ok. but we need the solution
or work around for this issues.



Chris Cheshire wrote:
> 
> I am using 2.5.1 and countif and sumif formulae result in a #VALUE
> error when opened in excel (but not in open office). Searching through
> the list I notice this has been reported before with this version.
> 
> Is this fixed in the 3.0 alpha? Is it slated to be fixed for 2.5?
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/countif-formula-issues-tf3293946.html#a13589881
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

Re: countif formula issues

[Nick Burch <ni...@torchbox.com>]

On Mon, 5 Nov 2007, Swapy wrote:
> Please help me for this issues.
> We need the solution for this error has soon as possible.

If you are altering values in the sheet used by formulas, or altering the 
forumlas, you'll need to re-evaluate the formulas to get their new values

http://poi.apache.org/hssf/eval.html

Also, you should try with a new svn checkout - 2.5.1 is very old, and 
there have been a few formula fixes since 3.0.1

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org