Setting environment variables

From NeoWiki

Revision as of 05:32, 28 December 2013 (edit) Sardisson (Talk | contribs) (article about setting the OOO_CALC_USE_ENGLISH_FORMULAS in various versions of Mac OS X) ← Previous diff		Current revision (05:35, 28 December 2013) (edit) (undo) Sardisson (Talk | contribs) (link back to trinity)
Line 28:		Line 28:
	After following the above steps, formulas in Calc documents should be displayed in English.		After following the above steps, formulas in Calc documents should be displayed in English.
		+
		+	==Related Links==
		+	* [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=7733 Trinity thread] on the <code>OOO_CALC_USE_ENGLISH_FORMULAS</code> environment variable.
	[[Category:NeoOffice]][[Category:Tips and Hints]]		[[Category:NeoOffice]][[Category:Tips and Hints]]

---

Current revision

Some features or behaviors of NeoOffice's underlying OpenOffice.org code are controlled not by standard application preferences but instead by UNIX environment variables.

Contents 1 OOO_CALC_USE_ENGLISH_FORMULAS 1.1 Mac OS X 10.8 “Mountain Lion” or newer 1.2 Mac OS X 10.7 “Lion” or older 2 Related Links

OOO_CALC_USE_ENGLISH_FORMULAS

One such environment variable is OOO_CALC_USE_ENGLISH_FORMULAS, which controls whether the formula function names (SUM, etc.) are displayed using their English names when NeoOffice running in a non-English language. For example, you may wish to run NeoOffice with Dutch menus, etc., but have functions displayed using their standard English names.

Mac OS X 10.8 “Mountain Lion” or newer

Beginning in Mac OS X 10.8 “Mountain Lion”, you must use a Launch Agent to set environment variables.

1. Create a LaunchAgents subfolder within your user's Library folder (~/Library).

   (Note that the Library folder is hidden by default; it can be accessed from the Finder's Go menu when holding down the Option key.)

2. Save this file in the ~/Library/LaunchAgents folder you created in step 1. Be sure to name the saved file local.launchd.conf.plist.
3. Log out or reboot your Mac.

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

Mac OS X 10.7 “Lion” or older

In Mac OS X 10.7 “Lion” or older, environment variables are set using the hidden global ~/.MacOSX/environment.plist file.

1. Create the hidden .MacOSX folder by executing the following command in the Terminal:

   mkdir -p ~/.MacOSX

2. Save this file on your Mac (for example, in your user's Downloads folder (~/Downloads).
3. Copy the downloaded file to the .MacOSX folder from step 1 by using the following Terminal command (assuming you downloaded the file to ~/Downloads in step 2:

   cp ~/Downloads/Environment.plist ~/.MacOSX/environment.plist

4. Log out or reboot your Mac.

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

Related Links

• Trinity thread on the OOO_CALC_USE_ENGLISH_FORMULAS environment variable.