Language Selection

English French German Italian Portuguese Spanish

Dropdown lists in Calc

Filed under

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 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

Android Leftovers

GNOME Shell vs. KDE Plasma Graphics Tests On Wayland vs. X.Org Server

A premium member this week had requested some benchmarks of openSUSE Tumbleweed when looking at the performance of KDE Plasma vs. GNOME Shell in some open-source graphics/gaming tests while also looking at the Wayland vs. X.Org Server performance. With KDE Plasma 5.12 that openSUSE Tumbleweed has picked up, there is much better Wayland session support compared to previous releases. While KDE developers aren't yet ready to declare their Wayland session the default, in my experience so far it's been working out very well but still routinely will find application crashes in Kate and the like when testing under the KWin's Wayland compositor. Read more

Stable kernels 4.15.6, 4.14.22, 4.9.84, 4.4.118 and 3.18.96

Android Leftovers