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

Chromebook to come with Intel Broadwell chips

Intel is expected to launch its 5th-gen Intel Core CPUs based on Broadwell architecture by the end of this year. According to the latest leaked information, Google’s Chromebook might feature this Broadwell chip. Intel is focusing on bringing high performance CPU which has minimum power requirement with Broadwell chip. Even though Broadwell is the scaled down version of Haswell, it will still maintain the same CPU performance as Haswell. The company is working on better performance-per-watt and lower power consumption to improve battery life of devices. Broadwell is just 14 nanometer in size. Read more

Deepin 2014.1 Released With Bug Fixes And Minor Enhancements

Deepin 2014.1 was released today with numerous bug fixes meant to improve the system stability and performance as well as a few interesting enhancements / new features. Users who have already installed Deepin 2014 don't have to reinstall - a simple upgrade via the Deepin Store or command line (sudo apt-get dist-upgrade) is enough to get the latest Deepin 2014.1. Read more

Quod Libet 3.2.1 Review – An Almost Perfect Music Player

It's a mystery why Quod Libet is not a more popular media player. It's been around for years and the developers have constantly worked on it. The last major update was done back in May 2014, and the software is stable and full of goodies. Quodlibet is a Latin phrase that means "what pleases" and it's used in music to describe a piece that's a combination of multiple melodies. The name seems to relate very well to the media player and it's actually quite catchy. Read more

Making Fedora work better [For me]

I’ve been talking to my fellow Fedora user, James [who happens to be my boss] and he’s told me a few extensions that are available for gnome 3 that make things a little better, and to be honest I like them lots. First of all you need to go here – https://extensions.gnome.org/ [use firefox] The first couple I have install is Applications Menu No Topleft Hot Corner Read more