Bug 51809 - COUNTIF&SUMIF miscalculates ">=" rule
Summary: COUNTIF&SUMIF miscalculates ">=" rule
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-dev
Hardware: All All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-14 12:28 UTC by Antti Koskimäki
Modified: 2011-09-14 18:38 UTC (History)
0 users



Attachments
fix for countif and sumif bug (1.48 KB, application/octet-stream)
2011-09-14 12:28 UTC, Antti Koskimäki
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Antti Koskimäki 2011-09-14 12:28:05 UTC
Created attachment 27493 [details]
fix for countif and sumif bug

Noticed with SUMIF, and bug found to be actually in COUNTIF code. Obvious copy-paste-bug, GE was evaluated as LE. 

Also a unit-test bug, basic cases were not covered :=)

Patch to fix included.
Comment 1 Nick Burch 2011-09-14 14:41:17 UTC
Thanks! Patch applied in r1170652.
Comment 2 Antti Koskimäki 2011-09-14 16:16:07 UTC
Itse fiksattu ja patch contriboitu

https://issues.apache.org/bugzilla/show_bug.cgi?id=51809

Muokkaan nyt vielä POIUtis:in niin että forceRecalculate asetetaan vain jos erikseen pyydetään. Jo pelkästään siksi että proof ajetaan POI:n itsensä jäljiltä ja Excelin re-calculate:n "korjailu" hämärtää tilannetta.

Lisäksi Office2010 vaatii erikseen "enable editing" nappulan painallusta ennenkuin uudelleenlaskenta käynnistyisi, ja PDF-konversion tapauksessa voi olla vastaava ongelma myös.

POI:n laskenta on kuitenkin jo melkoisen hyvällä tolalla.
Comment 3 Antti Koskimäki 2011-09-14 18:38:27 UTC
(In reply to comment #2)
Please ignore, inserted to wrong bug-system by mistake := (if somebody has rights to do so, please remove comment #2)