Return-Path: X-Original-To: apmail-poi-dev-archive@www.apache.org Delivered-To: apmail-poi-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1C2279706 for ; Wed, 8 Feb 2012 17:22:24 +0000 (UTC) Received: (qmail 57247 invoked by uid 500); 8 Feb 2012 17:22:23 -0000 Delivered-To: apmail-poi-dev-archive@poi.apache.org Received: (qmail 57025 invoked by uid 500); 8 Feb 2012 17:22:23 -0000 Mailing-List: contact dev-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Developers List" Delivered-To: mailing list dev@poi.apache.org Received: (qmail 57011 invoked by uid 99); 8 Feb 2012 17:22:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Feb 2012 17:22:22 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.115] (HELO eir.zones.apache.org) (140.211.11.115) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Feb 2012 17:22:20 +0000 Received: by eir.zones.apache.org (Postfix, from userid 80) id CFCC74E9A8; Wed, 8 Feb 2012 17:21:59 +0000 (UTC) From: bugzilla@apache.org To: dev@poi.apache.org Subject: DO NOT REPLY [Bug 51498] Countif.evaluate(int cmpResult) wrong return value for GE Date: Wed, 08 Feb 2012 17:21:59 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: POI Overall X-Bugzilla-Keywords: X-Bugzilla-Severity: trivial X-Bugzilla-Who: nick.burch@alfresco.com X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: dev@poi.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=51498 --- Comment #8 from Nick Burch 2012-02-08 17:21:59 UTC --- OpenOffice seems to be coming up with different answers to excel on countif for empty cells - it agrees with POI on the lower value (eg 29 rather than 34 for D4 in your example spreadsheet) -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org For additional commands, e-mail: dev-help@poi.apache.org