Language Selection

English French German Italian Portuguese Spanish

OpenOffice.org Calc function tools

Filed under
OOo
HowTos

Once you are comfortable with inputting functions and formulas, the next step is to learn how to automate the processes. Calc includes over half a dozen tools to help you manipulate functions and formulas, ranging from features for copying and reusing data to creating subtotals automatically to ones for varying information to help you find the answers that you need. These tools are divided between the Tools and Data menus, according to no apparent logic.

If you are a newcomer to spreadsheets, these tools can be overwhelming at first. However, they become simpler if you remember that they all depend on input from either a cell or a range of cells that contain the data with which you are working. You can always enter the cells or range manually, but in many cases, you can also use the Shrink/Maximize icon beside a field to change temporarily the size of the tool's window while you select the cells with the mouse. Sometimes, you may have to experiment with which data goes into one field, but, once you have found out, the rest is simply setting a selection of options, many of which can be ignored in any given case. Just keep the basic purpose of each tool in mind, and you should have little trouble with Calc's function tools.

Copying and reusing data

Data -> Consolidate provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. Most of the available functions are statistical (such as AVERAGE, MIN, MAX, STDEV0, and the tool is most useful when you are working with the same data over and over.

Full Story.

More in Tux Machines

Ubuntu Kylin 14.10 (Utopic Unicorn) Consolidates Its Position in China

Ubuntu Kylin 14.10 (Utopic Unicorn), a Chinese Linux distribution based on Ubuntu and developed in collaboration with Canonical, is looking to expand its user-base in China with this new release. Read more

MSI X99S SLI PLUS On Linux

For Intel Core i7 5960X Haswell-E Linux testing I originally bought an MSI X99S SLI PLUS motherboard as it was one of the most interesting, lowest-priced boards available at the time of the Intel X99 chipset debut. While I initially ran into some problems, those issues have now been confirmed to be isolated, and with a replacement X99S SLI PLUS motherboard I have been stressing it constantly for the past few weeks on Fedora and Ubuntu. The X99S SLI PLUS has now proven itself to be a reliable motherboard that's still among the least expensive X99 ATX motherboards on the market. Read more

Is the Tizen Samsung Z Alive and running Tizen 2.3 SM-Z910F ? #TDS14SH

At the Tizen Developer Summit 2014 Shanghai, Samsung were showing off the Gear S, and also the Samsung Z Smartphone. Taking a further glimpse at the settings we can see that it is listed as running Tizen 2.3, which recently saw the release of the Tizen 2.3 Beta SDK. As a recap, the Samsung Z was the Tizen flagship Smartphone that Samsung were due to release at the Tizen developer summit in Russia, but cancelled the launch with only 48 hours to spare. Read more

The Linux desktop-a-week review: LXDE

Over the last two weeks I’ve run nothing but LXDE as my primary Linux Desktop Environment (other than a few excursions into Android land). Been using LXDE. Been enjoying LXDE. But I have practically nothing to really say about LXDE. I feel like, after all this time, I should have something interesting to talk about. But I just plain don’t. It’s fast, blisteringly fast. And it’s damned lightweight too. After that, things get pretty boring. Read more