Re: executing org-table TBLFM form changes (resets) language settings

[Rainer Stengele <rainer.stengele@online.de>]

Am 26.01.2018 um 10:46 schrieb Rainer Stengele:
> Am 25.01.2018 um 20:27 schrieb Nick Dokos:
>> Rainer Stengele <rainer.stengele@online.de> 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