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 051AED345 for ; Tue, 5 Mar 2013 12:26:24 +0000 (UTC) Received: (qmail 4493 invoked by uid 500); 5 Mar 2013 12:26:24 -0000 Delivered-To: apmail-poi-dev-archive@poi.apache.org Received: (qmail 4074 invoked by uid 500); 5 Mar 2013 12:26:18 -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 4024 invoked by uid 99); 5 Mar 2013 12:26:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Mar 2013 12:26:16 +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; Tue, 05 Mar 2013 12:26:15 +0000 Received: by eir.zones.apache.org (Postfix, from userid 80) id C2A8D77DB; Tue, 5 Mar 2013 12:25:54 +0000 (UTC) From: bugzilla@apache.org To: dev@poi.apache.org Subject: [Bug 54636] getNumericCellValue return different result for visually equal numbers Date: Tue, 05 Mar 2013 12:25:54 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: apache@gagravarr.org X-Bugzilla-Status: RESOLVED X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: dev@poi.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: bug_status resolution Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=54636 Nick Burch changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #2 from Nick Burch --- This is to be expected. Excel stores the values in the file as floating point numbers, and applies formatting rules to control how they look to the end user. You should either use something like DataFormatter to get strings based on the format rules, or specify the number of significant digits when comparing the numbers. -- 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