How to set environment variables

ovvldc · Posted: Tue Aug 11, 2009 12:44 pm Post subject: How to set environment variables

I voted on a request to OOo to allow for not translating formula names.

I got a reply to set the environment variable OOO_CALC_USE_ENGLISH_FORMULAS (which is experimental but I'll give it a go).

But how do I set that for NeoOffice?

best wishes,
Oscar

sardisson · Town Crier Joined: Feb 01, 2004 Posts: 4588

Assuming the ones you want are supported in the current version of Neo, you could use something like RCEnvironment to set it globally.

I think there's a way to set them per-app using user defaults (e.g., org.neooffice.neooffice.plist), but I've forgotten what it is.

Smokey

pluby · The Architect Joined: Jun 16, 2003 Posts: 11949

You should not need any special application to set environment variables on your Mac. Instead follow the steps in the following Apple tech note:

http://developer.apple.com/qa/qa2001/qa1067.html

Patrick

sardisson · Town Crier Joined: Feb 01, 2004 Posts: 4588

ovvldc · Posted: Wed Aug 12, 2009 12:29 am Post subject:

So do I add this to the ~/.MacOSX/environment.plist file or do I add it to ~/Library/Preferences/org.neooffice.NeoOffice.plist?

Best wishes,
Oscar

pluby · The Architect Joined: Jun 16, 2003 Posts: 11949

ovvldc · Posted: Wed Aug 12, 2009 12:42 pm Post subject:

OK. I just wondered if it was possible to set it per application as well. My apologies.

pluby · The Architect Joined: Jun 16, 2003 Posts: 11949

ovvldc · Posted: Thu Aug 13, 2009 3:44 pm Post subject:

Woot! It works. Thanks go to Smokey for sending me the Property List Editor app, Patrick for pointing me to the Apple pages and Regina at OpenOffice.org for pointing me to the environment variable.

I put the attached file in the ~/.MacOSX/ folder and now all my formulae are in English while the UI is in Dutch Smile

.

Thanks again,
Oscar

pluby · The Architect Joined: Jun 16, 2003 Posts: 11949

Important note: Apple removed support for the ~/.MacOSX/environment.plist file so if you are running Mac OS X 10.8 Mountain Lion or higher, use the following steps to set the OOO_CALC_USE_ENGLISH_FORMULAS environment variable:

1. Create a "LaunchAgents" subfolder within your ~/Library folder (note: "~" means your Home folder)

2. Save the this file in the ~/Library/LaunchAgents folder. Be sure to name the saved file "local.launchd.conf.plist".

3. Log out or reboot your machine.

After the above steps, formulas in Calc documents should be displayed in English.

Patrick

ovvldc · Posted: Fri Dec 27, 2013 5:28 am Post subject:

I can confirm that it works with NeoOffice 3.4 with test patch 8 and NeoOffice 2013.1 on 10.9 Mavericks as well (at least on my machine).

Thanks, Patrick!

sardisson · Town Crier Joined: Feb 01, 2004 Posts: 4588

There's now a wiki article about this, with instructions for 10.8+ and 10.7- and links to the relevant files that Patrick uploaded for each.

Smokey

ovvldc · Posted: Sat Dec 28, 2013 3:42 am Post subject:

Great work Smokey, thanks!