From mboxrd@z Thu Jan 1 00:00:00 1970 From: Vicente Vera Subject: Re: Strings converted to numbers in Org table? Date: Mon, 27 Feb 2017 19:20:04 +0000 Message-ID: References: <87innvcze9.fsf@nicolasgoaziou.fr> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a113def2c7d3c03054987f799 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:44479) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ciQq7-0005z6-Gm for emacs-orgmode@gnu.org; Mon, 27 Feb 2017 14:20:08 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ciQq6-0003lq-AP for emacs-orgmode@gnu.org; Mon, 27 Feb 2017 14:20:07 -0500 Received: from mail-oi0-x230.google.com ([2607:f8b0:4003:c06::230]:35318) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1ciQq6-0003lV-5l for emacs-orgmode@gnu.org; Mon, 27 Feb 2017 14:20:06 -0500 Received: by mail-oi0-x230.google.com with SMTP id 62so43788132oih.2 for ; Mon, 27 Feb 2017 11:20:06 -0800 (PST) In-Reply-To: <87innvcze9.fsf@nicolasgoaziou.fr> 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" To: Nicolas Goaziou Cc: emacs-orgmode --001a113def2c7d3c03054987f799 Content-Type: text/plain; charset=UTF-8 Yes, it is a rare case indeed. It's not necessary nor appropiate to change Babel's behavior. Long story short, I'm building several LaTeX tables from CSV files which in turn come from Excel files. I'm not the author of these Excel files and I have to reproduce them as faithful as possible. The problem is that a comma is used as a decimal mark instead of a dot. `string-to-number' correctly interprets numbers such as "1.100" as floating point. But in this particular case this is not the expected behavior and the tables get messed up. Your solution is a much better option. Thanks. 2017-02-27 17:33 GMT+00:00 Nicolas Goaziou : > Hello, > > Vicente Vera writes: > > > It would be useful to have a header argument to prevent this > > conversion. Probably somebody else has had the same issue? > > Since this case may be rare, what about inserting a non breaking > zero-width space right before 3.350? > > Regards, > > -- > Nicolas Goaziou > --001a113def2c7d3c03054987f799 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Yes, it is a rare case indeed. It's not necessary nor = appropiate to
change Babel's behavior.

Long story short, I= 9;m building several LaTeX tables from CSV files
which in turn come from= Excel files. I'm not the author of these Excel
files and I have to = reproduce them as faithful as possible.

The problem is that a comma = is used as a decimal mark instead of a
dot. `string-to-number' corre= ctly interprets numbers such as "1.100"
as floating point. But= in this particular case this is not the
expected behavior and the table= s get messed up.

Your solution is a much better option. Thanks.
<= /div>

2017-02-27 1= 7:33 GMT+00:00 Nicolas Goaziou <mail@nicolasgoaziou.fr>= :
Hello,

Vicente Vera <vicentemvp@gmail.c= om> writes:

> It would be useful to have a header argument to prevent this
> conversion. Probably somebody else has had the same issue?

Since this case may be rare, what about inserting a non breaking
zero-width space right before 3.350?

Regards,

--
Nicolas Goaziou

--001a113def2c7d3c03054987f799--