Setting environment variables

From NeoWiki

Jump to: navigation, search

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

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.
Personal tools