On Thu, 30 Dec 2010, Aniket Banerjee wrote:
What I could observe is as follows :
if the cell contains "*All Geography all*" POI does calculation properly.
But in case there is a line feed (by pressing ALT+ENTER) after first letter
*"all*" then POI fails to calculate correctly. But excel can do t
ooking to match one or more characters. Do not know if this is the case
> and
> I cannot seem to find out from searching at MSDN but it would certainly be
> worth looking at the source of the COUNTIF function's implementation in
> POI.
>
> Yours
>
> Mark B
> --
> V
;s implementation in POI.
Yours
Mark B
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Formula-evaluates-wrong-value-tp3321261p3322409.html
Sent from the POI - User mailing list archive at Nabble.com.
---
Hi Aniket,
>> Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which
>> should return 1 is returning 0.
>> T2 contains "*Target Geography in all*".
>>
> Again the above formula does not return any error but simply wrong value.
>>
>And also if I skip evaluation excel calcula
- Original Message
From: Aniket Banerjee
To: POI Users List
Sent: Wed, December 29, 2010 6:58:30 AM
Subject: Re: Formula evaluates wrong value.
>
> Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which
> should return 1 is return
>
> Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which
> should return 1 is returning 0.
> T2 contains "*Target Geography in all*".
>
Again the above formula does not return any error but simply wrong value.
>
And also if I skip evaluation excel calculates the correct valu
Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which
should return 1 is returning 0.
T2 contains Target Geography in all. Again the above formula does not return
any error but simply wrong value.
And also if I skip evaluation excel calculates the correct value ie 1.
On Wed, Dec
Also I found another formula : =*COUNTIF(T2,"*"&"Geography"&"*") *which
should return 1 is returning 0.
T2 contains Target Geography in all. Again the above formula does not return
any error but simply wrong value.
And also if I skip evaluation excel calculates the correct value ie 1.
On Wed, D
No Nick!! I am not getting any error but the result it returns is 0 which is
a wrong.
On Wed, Dec 29, 2010 at 6:21 PM, Nick Burch wrote:
> On Wed, 29 Dec 2010, Aniket Banerjee wrote:
>
>> Formula : =*SUMIF(C1:C199,"<>#VALUE!",C1:C199)*
>> Is evaluating wrong value ie 0 instead of the correct val
On Wed, 29 Dec 2010, Aniket Banerjee wrote:
Formula : =*SUMIF(C1:C199,"<>#VALUE!",C1:C199)*
Is evaluating wrong value ie 0 instead of the correct value.
Quick check - are you getting an error from the evaluation?
Nick
-
To un
Hi,
Formula : =*SUMIF(C1:C199,"<>#VALUE!",C1:C199)*
Is evaluating wrong value ie 0 instead of the correct value.
If I do not evaluate the formula explicitly then excel evaluates the correct
value. Is this a bug? If yes is there any bug filed for this?
Kindly help...Thanks!!!
Regards,
Aniket
11 matches
Mail list logo