Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 80526 invoked from network); 7 Jan 2010 07:55:43 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 Jan 2010 07:55:43 -0000 Received: (qmail 24490 invoked by uid 500); 7 Jan 2010 07:55:42 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 24468 invoked by uid 500); 7 Jan 2010 07:55:42 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Received: (qmail 24458 invoked by uid 99); 7 Jan 2010 07:55:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jan 2010 07:55:42 +0000 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=FROM_LOCAL_NOVOWEL,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 Jan 2010 07:55:34 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1NSnD7-0008BT-Rr for user@poi.apache.org; Wed, 06 Jan 2010 23:55:13 -0800 Message-ID: <27056259.post@talk.nabble.com> Date: Wed, 6 Jan 2010 23:55:13 -0800 (PST) From: MSB To: user@poi.apache.org Subject: Re: bug in cell.setCellType(Cell.CELL_TYPE_NUMERIC) (POI 3.6) In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: markbrdsly@tiscali.co.uk References: Yes, that would work for your requirement Filip but I can easilly imagine another using say that the String value "$2,500" should be converted to a number and a format should be generated and applied automatically to the cell so that they did not lose the dollar sign and comma separator - and is this really the function of a setCellYtpe() method? I think that we could convincingly argue that if you try to convert a cell whose type is text or string into a numeric cell (for example) then a warning should be issued that information may be lost. In my opinion, it will not be possible to catch and handle every little requirement, so the conversion of the value should be performed and the user ought to be warned that changes may occur to the appearence of the cell. Yours Mark B Filip Defoort wrote: > >> In my opinion, I think that poi should be changed to option (C) - >> always attempt conversion, with strict parsing. >> > > I would agree with that - it'd be really handy to have string to > number conversion, but it can be a really simple numeric parsing > without dealing with $, % and the likes. > > Cheers, > - Filip > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@poi.apache.org > For additional commands, e-mail: user-help@poi.apache.org > > > -- View this message in context: http://old.nabble.com/bug-in-cell.setCellType%28Cell.CELL_TYPE_NUMERIC%29-%28POI-3.6%29-tp27034280p27056259.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org