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

Leaked videos, screenshots reveal an HTC One running Android Lollipop

No, you won’t get this gift in time for Christmas, but perhaps seeing an HTC One running Lollipop may make the wait slightly less painful. A batch of videos and screenshots show HTC’s flagship with the newest build of Android, though of course it’s merged with the Sense 6.0 user interface (the HTC One currently runs Sense 5.0). We got a small hint of how Lollipop looks on the One in November, but this leak lays out what the entire operating system makeover looks in clearer detail. Read more

The winning Linux kernel live patch: All of the above

Life's choices often amount to one of two options: Linux or Windows? Android or iOS? Kgraft or Kpatch? That last pair consists of the two major contenders for the technology Linux could use for live kernel patches. Now a winner is in, and it amounts to all of the above. According to a post on the official Linux kernel developer's mailing list, a kernel patching system that works with both Kgraft and Kpatch and uses "core functionality abstracted out of [those] already existing implementations" has been proposed as an addition to the Linux 3.20 kernel. Read more

UNIX Industry Banks on Linux Strategies

Struggling UNIX server makers are strengthening their Linux strategy in line with the open-source application environment. The move is aimed at maintaining remaining customers, since users are increasingly abandoning UNIX servers. However, it is receiving a lukewarm response from the market. According to industry sources on Dec. 22, server vendors such as IBM and HP are concentrating on the development of products so that the Linux operating system and related applications can be used as UNIX servers. Read more

Mageia Beta Delayed, Christmas Quiz, and 7 Best Alternatives

Today in Linux news the Mageia project announced another delay in version 5 Beta 2. The Linux Voice is running a Linux quiz for Christmas and Gary Newell offers up his list of the seven best alternative Linux distributions of the year. The Register says 2015 will be the year of Linux - on mobile. Three reviews need to be highlighted and, finally today, Matt Hartley says everyone should switch to Ubuntu MATE. Read more Also: Linux Bloat, Linux Lite, and Devuan Update