From mboxrd@z Thu Jan 1 00:00:00 1970 From: Rainer Thiel Subject: comma as decimal point: bug? Date: Sun, 26 Aug 2012 15:54:21 +0200 Message-ID: Reply-To: r.thiel@uni-jena.de Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([208.118.235.92]:56886) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1T5dIL-0004bJ-Ni for emacs-orgmode@gnu.org; Sun, 26 Aug 2012 09:54:30 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1T5dIF-0003HR-Sk for emacs-orgmode@gnu.org; Sun, 26 Aug 2012 09:54:29 -0400 Received: from mail-iy0-f169.google.com ([209.85.210.169]:46502) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1T5dIF-0003HL-O8 for emacs-orgmode@gnu.org; Sun, 26 Aug 2012 09:54:23 -0400 Received: by iahk25 with SMTP id k25so7290293iah.0 for ; Sun, 26 Aug 2012 06:54:22 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode mailing list I have seen that as of v. 7.9, org tables are supposed to accept commas as decimal points which is useful if you set up tables to be used in in files where continental conventions are expected to be followed. But I cannot see this really works. I should have expected that the following two tables should provide the same result: --> | Items | Price | |--------+-------| | Item 1 | 15.3 | | Item 2 | 2.3 | |--------+-------| | Sum | 17.6 | #+TBLFM: @4$2=3Dvsum(@II..@I) | Items | Price | |--------+-------| | Item 1 | 15,3 | | Item 2 | 2,3 | |--------+-------| | Sum | 23 | #+TBLFM: @4$2=3Dvsum(@II..@I) <-- As you can see, the outcome is quite different, and wrong when commas are used instead of decimal points. The value of org-table-number-regexp should be the standard value in org 7.= 9: --> org-table-number-regexp is a variable defined in `org-table.el'. Its value is "^\\([<>]?[-+^.,0-9]*[0-9][-+^.,0-9eEdDx()%:]*\\|\\(0[xX]\\)[0-9a-fA-F]+\\|= nan\\)$" <-- Am I doing wrong something here, or is this a bug in org 7.9? Best regards, and many thanks in advance Rainer --=20 Prof. Dr. Rainer Thiel Institut f=FCr Altertumswissenschaften 07737 Jena, Germany (EU) r.thiel@uni-jena.de