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

What's New for You This June in Open Source CMS

You can't talk about open source content management systems without talking about WordPress, the most popular CMS on the planet. WordPress powers some of the largest websites in the world including CNN, Time magazine and Ted. According to W3tech, WordPress powers 23 percent of the top 10 million websites in the world. Read more

From Linux User, to Electrical Engineer, to Linux Foundation Instructor: Jan-Simon Möller

Jan-Simon Möller is a consultant and trainer for the Linux Foundation's training program and holds an electrical engineering degree. But he started out as a home Linux user tinkering with different distributions before moving on to systems administration. He now teaches a range of Linux Foundation courses, from writing Linux kernel drivers, to embedded Linux development, and system administration. His expertise lies in embedded Linux, Realtime Linux, SELinux, power management, and integration of new compilers. Here Möller tells us more about how he learned Linux, his career path, the projects he's currently involved in, and his ham radio hobby. Read more

Cinnamon 2.6 to Arrive in Linux Mint 17.2 "Rafaela" and LMDE 2 "Betsy" by the End of June

Cinnamon 2.6 was released yesterday and the developers have promised that it will be available in the supported Linux Mint flavors by the end of the month. Read more

The Linux Foundation Offers Course for SysAdmins on EdX

The Linux Foundation partnership with edX platform is expanding, and users will now get the Essentials of Linux Systems Administration (LFS201) online course, which should help prepare the SysAdmins of tomorrow. Read more