From mboxrd@z Thu Jan 1 00:00:00 1970 From: Rainer Stengele Subject: Re: executing org-table TBLFM form changes (resets) language settings Date: Mon, 29 Jan 2018 08:49:16 +0100 Message-ID: <45d4aef9-5e98-6153-0316-eaec502f5530@online.de> References: <87inbphh77.fsf@alphaville.usersys.redhat.com> <59222bd6-d62a-23a4-544b-66466bdc3380@online.de> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:44428) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1eg4Bx-0002Pb-9N for emacs-orgmode@gnu.org; Mon, 29 Jan 2018 02:49:26 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1eg4Bu-00039s-6F for emacs-orgmode@gnu.org; Mon, 29 Jan 2018 02:49:25 -0500 Received: from [195.159.176.226] (port=58855 helo=blaine.gmane.org) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1eg4Bt-00037k-Vw for emacs-orgmode@gnu.org; Mon, 29 Jan 2018 02:49:22 -0500 Received: from list by blaine.gmane.org with local (Exim 4.84_2) (envelope-from ) id 1eg49k-0003er-Nn for emacs-orgmode@gnu.org; Mon, 29 Jan 2018 08:47:08 +0100 In-Reply-To: <59222bd6-d62a-23a4-544b-66466bdc3380@online.de> Content-Language: de-DE-1901 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: emacs-orgmode@gnu.org Am 26.01.2018 um 10:46 schrieb Rainer Stengele: > Am 25.01.2018 um 20:27 schrieb Nick Dokos: >> Rainer Stengele writes: >> >>> All, >>> >>> My current-language-environment is "German". >>> Having an Org table with a TBLFM attached: >>> >>> | IM Startzeit          | IM Endezeit           | Stunden | delta(x,16) | Anm. | >>> |-----------------------+-----------------------+---------+-------------+------| >>> | [2018-01-22 Mo 19:30] | [2018-01-23 Di 14:30] |   19.00 |        3.00 |      | >>> |                       |                       |         |             |      | >>> >>> #+TBLFM: $3=24*(date(<$2>)-date(<$1>)); %.2f::$4=$3-16.0; %.2f >>> >>> entering a new timestamp correctly inserts German dayname abbrevs: ("Do", German for "Thu", English): >>> >>> | IM Startzeit          | IM Endezeit           | Stunden | delta(x,16) | Anm. | >>> |-----------------------+-----------------------+---------+-------------+------| >>> | [2018-01-22 Mo 19:30] | [2018-01-23 Di 14:30] |   19.00 |        3.00 |      | >>> | [2018-01-25 Do 14:19] |                       |         |             |      | >>> >>> #+TBLFM: $3=24*(date(<$2>)-date(<$1>)); %.2f::$4=$3-16.0; %.2f >>> >>> Executing the TBLFM line with C-c C-c changes (resets) the language environment to English. >>> >>> Now inserting a timestamp inserts "Thu" instead of "Do", that is it uses the English day name abbrevs: >>> >>> | IM Startzeit          | IM Endezeit           |      Stunden |  delta(x,16) | Anm. | >>> |-----------------------+-----------------------+--------------+--------------+------| >>> | [2018-01-22 Mo 19:30] | [2018-01-23 Di 14:30] |        19.00 |         3.00 |      | >>> | [2018-01-25 Thu 14:21]|                       |              |              |      | >>> >>> #+TBLFM: $3=24*(date(<$2>)-date(<$1>)); %.2f::$4=$3-16.0; %.2f >>> >>> Believe me it took me some time to find out what action in Emacs changes the whole lang environment. >>> >>> Is that a bug or is there a language setting in the TBLFM form? >>> >>> Thanks for any hint. >>> >>> Regards, >>> Rainer >>> >> >> I can reproduce this if I start emacs like this: >> >>     emacs -q -l ~/src/minimal/min.org.el /tmp/dates.org & >> >> set the language environment inside emacs and then do C-c C-c on the TBLFM line >> and try to add another date. >> >> I cannot reproduce it when invoking emacs like this: >> >>     LANG=de_DE.UTF-8 emacs -q -l ~/src/minimal/min.org.el /tmp/dates.org >> >> so it seems you are right that in the first case, something changes the language >> environment. >> > Hi Nick, > > thanks for confirming. > I am running under Windows and cannot apply your environment setting like this. > > Does anyboday have a chance to correct the misbehaviour in the TBLFM table code that changes the language settings? > I will not be able to do it on my own. > > Thank you. > Regards, Rainer > > Hi again, I found out that it is the "date" function that changes the language settings. TBLFM lines without date calc don't change the behaviour. May I please ask a calc expert to look into that function and investigate the unwanted behaviour. I am also not sure how to easily reset the language setting manually to the correct one. Can someone give me a hint please. Thank you. Regards, Rainer