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 792249A97 for ; Sat, 28 Jul 2012 17:27:15 +0000 (UTC) Received: (qmail 17544 invoked by uid 500); 28 Jul 2012 17:27:14 -0000 Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org Received: (qmail 17306 invoked by uid 500); 28 Jul 2012 17:27:14 -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 17124 invoked by uid 99); 28 Jul 2012 17:27:14 -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 17:27:14 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dennis.hamilton@acm.org designates 216.119.133.2 as permitted sender) Received: from [216.119.133.2] (HELO a2s42.a2hosting.com) (216.119.133.2) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 28 Jul 2012 17:27:06 +0000 Received: from 71-217-73-181.tukw.qwest.net ([71.217.73.181]:33278 helo=Astraendo) by a2s42.a2hosting.com with esmtpa (Exim 4.77) (envelope-from ) id 1SvAmr-003pKX-Ma for ooo-users@incubator.apache.org; Sat, 28 Jul 2012 13:26:46 -0400 Reply-To: From: "Dennis E. Hamilton" To: References: In-Reply-To: Subject: RE: [DISCUSS][CALC] String content to numeric value Date: Sat, 28 Jul 2012 10:26:51 -0700 Organization: NuovoDoc Message-ID: <008201cd6ce6$2eb5b2b0$8c211810$@acm.org> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 14.0 Thread-index: AQKyaTwFjLqvsM97ejWnfizGMz5M5QJHbopSlWKxXPA= Content-language: en-us X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - a2s42.a2hosting.com X-AntiAbuse: Original Domain - incubator.apache.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - acm.org X-Virus-Checked: Checked by ClamAV on apache.org +1 -----Original Message----- From: Andreas S=C3=A4ger [mailto:villeroy@t-online.de]=20 Sent: Saturday, July 28, 2012 02:55 To: ooo-users@incubator.apache.org Subject: Re: [DISCUSS][CALC] String content to numeric value 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, =3DVALUE("1,234";"de-DE") is my suggestion. But that would be = incompatible. VALUE("1,234") returns different values in German and English versions=20 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=20 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 --------------------------------------------------------------------- To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org For additional commands, e-mail: ooo-users-help@incubator.apache.org