Language Selection

English French German Italian Portuguese Spanish

Dropdown lists in OpenOffice.org Calc

Filed under
OOo

Dropdown lists are a mainstay of many spreadsheets and forms. They help you control what people can enter, as well as giving them ideas for what types of things they might say.

You can make dropdown lists in a couple ways, at least, in OpenOffice.org. The simplest way is to use the tools accessed under Data > Validity. The lists are easy to make, plus you can easily use the values in formulas. In the following illustration, the value in B2, selected from a dropdown list, is referenceable in another cell.

Another way you can use the values in the dropdown list (among many) is to concatenate them. Click the following illustration to see it larger. The formula

More Here.




More in Tux Machines

Git 2.2.1 Released To Fix Critical Security Issue

Today's Git vulnerability affects those using the Git client on case-insensitive file-systems. On case-insensitive platforms like Windows and OS X, committing to .Git/config could overwrite the user's .git/config and could lead to arbitrary code execution. Fortunately with most Phoronix readers out there running Linux, this isn't an issue thanks to case-sensitive file-systems. Read more

Ubuntu 15.04 Alpha 1 For Its Various Flavors

While Ubuntu itself no longer puts out alpha/beta releases in favor of just testing out the daily Live ISOs, the various Ubuntu flavors still participating in the traditional release process have done their first alpha releases this afternoon for Ubuntu 15.04. Read more

Robolinux 7.7.1 LXDE Runs Windows Apps with Stealth VM

Robolinux 7.7.1, a fast and easy-to-use Linux distribution based on Debian has just received a new desktop environment, LXDE, making this the third second flavor of the distribution. Read more

Jolla's Sailfish OS Update 10 Is Now Available

The tenth update to Jolla's Sailfish mobile operating system is now available. This update is version 1.1.1.26 and is codenamed Vaarainjärvi. This latest update to Jolla's Sailfish OS includes the device lock now supporting alpha-numeric codes, copy-paste support between Android and native Sailfish apps, Mail app improvements, new overlays for maps, search improvements, unification to the accounts framework, new MMS settings, UI improvements, and an assortment of other improvements. Read more