From ooo-users-return-2282-apmail-incubator-ooo-users-archive=incubator.apache.org@incubator.apache.org Sat Jul 28 09:55:51 2012 Return-Path: X-Original-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A04D096AF for ; Sat, 28 Jul 2012 09:55:51 +0000 (UTC) Received: (qmail 48059 invoked by uid 500); 28 Jul 2012 09:55:51 -0000 Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org Received: (qmail 47994 invoked by uid 500); 28 Jul 2012 09:55:51 -0000 Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-users@incubator.apache.org Delivered-To: mailing list ooo-users@incubator.apache.org Received: (qmail 47985 invoked by uid 99); 28 Jul 2012 09:55:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 28 Jul 2012 09:55:51 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of gcaiou-ooo-users@m.gmane.org designates 80.91.229.3 as permitted sender) Received: from [80.91.229.3] (HELO plane.gmane.org) (80.91.229.3) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 28 Jul 2012 09:55:43 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1Sv3k1-0001Tn-Ib for ooo-users@incubator.apache.org; Sat, 28 Jul 2012 11:55:21 +0200 Received: from p57b5a503.dip.t-dialin.net ([87.181.165.3]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 28 Jul 2012 11:55:21 +0200 Received: from villeroy by p57b5a503.dip.t-dialin.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 28 Jul 2012 11:55:21 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: ooo-users@incubator.apache.org From: =?UTF-8?B?QW5kcmVhcyBTw6RnZXI=?= Subject: Re: [DISCUSS][CALC] String content to numeric value Date: Sat, 28 Jul 2012 11:55:07 +0200 Lines: 23 Message-ID: References: Reply-To: villeroy@t-online.de Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: p57b5a503.dip.t-dialin.net User-Agent: Mozilla/5.0 (X11; Linux i686; rv:14.0) Gecko/20120714 Thunderbird/14.0 In-Reply-To: X-Virus-Checked: Checked by ClamAV on apache.org Am 27.07.2012 07:32, Lei Wang wrote: > > In my point of view it is better to support more scenarioes to convert a > text value to a number, such as decimal. Though different locale has > different decimal separator, AOO can support decimal separator for current > locale and standard decimal separator, ".". It will be more complicated for > date format. > > What's your suggestion? > Hi, =VALUE("1,234";"de-DE") is my suggestion. But that would be incompatible. VALUE("1,234") returns different values in German and English versions of MS Excel. This is inacceptable. The current behaviour which converts unambiguous ISO and integer only is a good compromise. Personally I would prefer #VALUE! over any implicit conversion. Broken spreadsheets deserve to be fixed. Just my 2 Cents, A.S --------------------------------------------------------------------- To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org For additional commands, e-mail: ooo-users-help@incubator.apache.org