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

Fresh software from the 3.14 menu

If all goes according to plan, I'll be able to merge the aforementioned automatic rotation support into systemd/udev. The kernel API is pretty bad, which makes the user-space code look bad... The first parts of ebooks support in gnome-documents have already been written, scheduled for 3.16 Read more

Florida is back on the Map for Linux and Open Source conventions with FOSSETCON 2

In summary the event was a good investment in time and booth expenses spent. We were able to distribute and promote Fedora in a very positive manner. More importantly getting more information on the various spins offered on our website pointed out to many individuals that there are more available on the Fedora Project website.. As the event ended on the 13th, I had had a conversation with the event coordinator with the plus side and the down side of what was going on. Read more

Linux 3.17-rc6

It's been quiet - enough so that coupled with my upcoming travel, this might just be the last -rc, and final 3.17 might be next weekend. Of course, that still depends on what happens - if we have something scary coming up next week, I may have to delay things. But as it looks right now, we're all good to go. The shortlog is appended, but the view from ten thousand feet is pretty normal: a bit more than half is drivers (gpu, sound, iio, media, usb), just under a third is arch updates (arm, mips, x86), and the rest is mainly filesystem updates (gfs2, cifs, btrfs, nfs). Nothing particular stands out, and I'm not aware of any big pending issues either. So please go out and test, because this *should* all be pretty close to release. Read more

today's leftovers