[GNC] Cut and paste does nothing if number formats don't match
Paul Kroitor
paul at kroitor.ca
Sat Aug 9 10:14:54 EDT 2025
I've gone a bit down the rabbit hole on this and learned that in fact
the international standard* separator for digit groups is the "thin
space", and it's English (apparently plus most of the other languages)
that has gone AWOL here. And it's been so since 1948 (and reaffirmed in
2003).
I suspect this may all stem from Napoleon and his implementation of the
Metric system combined with the French use of spaces as separators.
Who knew?
Paul
* At the International Bureau of Weights and Measures, which includes
the SI, the official definition of the metric system.
On 2025-08-09 9:56 a.m., Paul Kroitor wrote:
> Hello all,
>
> Afaik lots of locales use spaces to separate thousands, including
> common ones like French. See
> https://randombits.dev/articles/number-localization/locale-list.
>
> Apparently there are several different Unicode spaces (no-break space,
> narrow no-break space, etc) which are specifically used depending on
> the locale.
>
> Paul
>
>
> On 2025-08-09 9:27 a.m., David Carlson wrote:
>> Graham,
>>
>> There are certain data fields that that have somewhat quirky
>> behavior, but
>> the only one that has bothered me are the value fields in the
>> transaction
>> register where, for me, if I inadvertently insert or omit an intended
>> plus
>> or minus sign or if commas or periods do not comply with the
>> definitions in
>> my locale, then I get a surprise, usually a very different value than
>> the
>> value that I intended to insert. This actually seems to be about the
>> same
>> as what you describe, except that I usually find an easier recovery than
>> the methods you use. As far as I know, at least up through release
>> 5.11 of
>> GnuCash there has not been any change to that behavior. In your first
>> sentence you use the word locale with an example that doesn't seem to be
>> the difference that I might expect, eg swapping the comma and period in
>> numbers depending on which country GnuCash thinks I am in. For me, a
>> space
>> is always a separator between two different numbers. I wonder if
>> that is
>> the source of your confusion.
>>
>> On Sat, Aug 9, 2025 at 3:16 AM Graham Leggett via gnucash-user <
>> gnucash-user at gnucash.org> wrote:
>>
>>> Hi all,
>>>
>>> I have various statements with locales all over the show, for example
>>> "1,234.99". Gnucash wants the figures to look like "1 234.99".
>>>
>>> In the past this hasn't been a problem (other than the annoyance), as I
>>> could correct the format in the register after a cut and paste,
>>> however now
>>> cut and paste no longer works - specifically the paste is ignored.
>>>
>>> What does work, which is more annoying, is to cut and paste to an
>>> intermediate location like a text editor, edit "1,234.99" to "1
>>> 234.99",
>>> and cut and paste a second time. Now the paste works.
>>>
>>> Is there a way to switch this behaviour off?
>>>
>>> Regards,
>>> Graham
>>> --
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user
mailing list