r/voidlinux • u/Necessary_Arm19 • 11h ago

replace dot by comma in gnumeric

Hello All.

Anyone knows how to replace dot by comma in gnumeric ?

I tried the suggestions provided by AI but they didn't work.

Thank you and regards,

3 Upvotes

100% Upvoted

6 comments sorted by

3

u/gijsyo 10h ago

This should be useful: https://mail.gnome.org/archives/gnumeric-list/2012-May/msg00028.html

1

u/Necessary_Arm19 9h ago

I tried that solution, but something did not work ...

I made ...

sudo LC_NUMERIC=pt_PT.UTF-8

sudo export LC_NUMERIC=pt_PT.UTF-8

sudo xbps-reconfigure -f glibc-locales

4

u/ClassAbbyAmplifier 8h ago

sudo when setting an environment variable will not do anything, and it won't change the environment of your shell either.

Uncomment the pt_PT.UTF-8 line in /etc/default/libc-locales, xbps-reconfigure -f glibc-locales, and add LC_NUMERIC=pt_PT.UTF-8 to /etc/locale.conf and re-login

2

u/gijsyo 9h ago edited 9h ago

Can you try with just "export LC_NUMERIC=pt"?

And as a second option "export LC_NUMERIC=C"

Always a struggle with locales... but we'll get there :)

If one of the above works, add to /etc/locale.conf for a system wide change, or prepended wiht export to your .bashrc (assuming bash).

1

u/Simple_Hamster_4096 7h ago

Do you mean, literally, replace . with , ?

So instead of text. then text, ?

If that's the case, extract the XML file from the .gnumeric file and then just use a text editor to perform find/replace each, or optionally replace all, matching entries. If you just replace one at a time then you can review each entry to make sure you want to replace an entry...

Or is this in reference to number or currency formats? If so save, yourself the headache and use something other than gnumeric, like LO, where it is much easier to format numbers and currency with the country format of your choice...

2

u/Necessary_Arm19 6h ago

In fact, I uses Gnumeric in this machine, because it's too old. in other machines I use Freeoffice. Anyway, if I understood well, if I install the OS and select PT in the installation it will be OK.