Changing locale so Excel on wine shows dates correctly

37bodie
Crew Member

Learning Bodhi Linux (I hope)

Posts: 64

Likes: 22

Changing locale so Excel on wine shows dates correctly Nov 24, 2020 12:56:13 GMT

Quote

Post by 37bodie on Nov 24, 2020 12:56:13 GMT

Using Microsoft Excel 2007 on wine-stable, it works fine, just my dates are US format mm/dd/yyyy and I want dd/mm/yyy

- yes, I can change them individually in Excel but this is annoying.

On Windows, Excel uses the Regional Settings in Control Panel, but I have no idea how to fix this on wine, other than perhaps tweaking the command line for each program, which is way too dangerous on Bodhi as it might never start again.

Is there an easy way to change my locale so Excel uses the correct date format? (I want Euro and English, so Ireland is fine)

Based in Austria on an English system, entering the following at the command line: locale

I get:

LANG=en_US.UTF-8
LANGUAGE=
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC=de_AT.UTF-8
LC_TIME=de_AT.UTF-8
LC_COLLATE="en_US.UTF-8"
LC_MONETARY=de_AT.UTF-8
LC_MESSAGES="en_US.UTF-8"
LC_PAPER=de_AT.UTF-8
LC_NAME=de_AT.UTF-8
LC_ADDRESS=de_AT.UTF-8
LC_TELEPHONE=de_AT.UTF-8
LC_MEASUREMENT=de_AT.UTF-8
LC_IDENTIFICATION=de_AT.UTF-8
LC_ALL=

I have tried this from the command line:

sudo update-locale LANGUAGE=en_IE.utf8

it doesn't work (it always stays the same as the settings shown above).

Also, locale -a shows me en_IE.utf8 is in the output.

So why can't I get it? Any help appreciated as always.

Last Edit: Nov 24, 2020 12:58:52 GMT by 37bodie

------
Oh my good gawd ... please keep anything posted below nice and simple.

37bodie
Crew Member

Learning Bodhi Linux (I hope)

Posts: 64

Likes: 22

Changing locale so Excel on wine shows dates correctly Nov 24, 2020 13:37:22 GMT

Quote

Post by 37bodie on Nov 24, 2020 13:37:22 GMT

Oh well, I have fiddled about and fixed it myself, using this line, it loads Excel and the date and currency are correct

So, I run this from the command line and it works fine:

env WINEPREFIX="/home/jno/.wine" LANG=en_IE.UTF-8 wine C:\\windows\\command\\start.exe /Unix /home/jno/.wine/dosdevices/c:/users/jno/Start\ Menu/Programs/Microsoft\ Office/Microsoft\ Office\ Excel\ 2007.lnk

jno is of course my username.

However, being a Bodhi n00b, how can I simply assign this to a desktop icon and so it runs when I click ? (I have desktop icons ON) but as a 30 year Windows veteran, sadly this is no Right Click > New > Shortcut

Tried this: www.bodhilinux.com/w/enlightenment-basics/#Desktop_Icons

I get the icon, but it doesn't run, despite using copy/paste.

Last Edit: Nov 24, 2020 13:54:14 GMT by 37bodie

------
Oh my good gawd ... please keep anything posted below nice and simple.

fidoedidoe
Web Dev

Posts: 126
Likes: 81

Changing locale so Excel on wine shows dates correctly Nov 24, 2020 15:44:12 GMT

Quote

Post by fidoedidoe on Nov 24, 2020 15:44:12 GMT

Nov 24, 2020 13:37:22 GMT 37bodie said:

So, I run this from the command line and it works fine:

env WINEPREFIX="/home/jno/.wine" LANG=en_IE.UTF-8 wine C:\\windows\\command\\start.exe /Unix /home/jno/.wine/dosdevices/c:/users/jno/Start\ Menu/Programs/Microsoft\ Office/Microsoft\ Office\ Excel\ 2007.lnk

Tried this: www.bodhilinux.com/w/enlightenment-basics/#Desktop_Icons

I get the icon, but it doesn't run, despite using copy/paste.

if you can you post the output of the desktop icon file you created in the above it will be helpful. You will find the file in ~/Desktop (although you'l need to know the name you gave the desktop file). If you don't know file name, then use the ls command to find out). Once you have the file name post the output of the cat command here and we'll try to help get your desktop launcher working

ls -l ~/Desktop
cat ~/Desktop <filename>.desktop