Return-Path: Delivered-To: apmail-poi-dev-archive@www.apache.org Received: (qmail 15531 invoked from network); 7 Jul 2009 20:39:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Jul 2009 20:39:28 -0000 Received: (qmail 18968 invoked by uid 500); 7 Jul 2009 20:39:38 -0000 Delivered-To: apmail-poi-dev-archive@poi.apache.org Received: (qmail 18930 invoked by uid 500); 7 Jul 2009 20:39:38 -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 18920 invoked by uid 99); 7 Jul 2009 20:39:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Jul 2009 20:39:37 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Jul 2009 20:39:34 +0000 Received: by brutus.apache.org (Postfix, from userid 33) id C01FB234C051; Tue, 7 Jul 2009 13:39:13 -0700 (PDT) From: bugzilla@apache.org To: dev@poi.apache.org Subject: DO NOT REPLY [Bug 47490] New: HSSFDataFormatter.createFormat(double,int,string) does not handle '@' format X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: newchanged X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: HSSF X-Bugzilla-Keywords: X-Bugzilla-Severity: major X-Bugzilla-Who: jgarrison@troux.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: dev@poi.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Changed-Fields: Message-ID: Auto-Submitted: auto-generated Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Date: Tue, 7 Jul 2009 13:39:13 -0700 (PDT) X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=47490 Summary: HSSFDataFormatter.createFormat(double,int,string) does not handle '@' format Product: POI Version: 3.2-FINAL Platform: PC OS/Version: Windows Server 2003 Status: NEW Severity: major Priority: P2 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: jgarrison@troux.com This method contains the following code at the end: // TODO - when does this occur? return null; The answer is that this occurs whenever a numeric cell is given "Text" format (format string '@') in Excel. Returning null at this point results in the value being formatted with the default numeric format (a decimal place) even though the value displayed in Excel is an integer. I would contribute a patch but don't yet understand enough of the framework to know the best way to fix this. -- 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