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

CoreOS Releases Building Block For Distributed Systems

Hyperscale Linux operating system specialist CoreOS said it is releasing its latest open source component for sharing and managing configuration data and other functions used in distributed systems. San Francisco-based CoreOS announced its first stable release of etcd, or “etc distributed,” an open-source distributed key value store that provides the backbone of CoreOS clusters and the etcd clients that run on each machine in a cluster. “Our goal with etcd has been to make building and using distributed systems easier,” CoreOS CTO Brandon Philips said Wednesday (January 28) in announcing the release. Read more

The 5 best open source email clients for Linux

Windows users have Outlook; Mac users have Mail. What options are there for Linux users? As it turns out, Linux land is rich with email clients. I have chosen five of the best, fully open source email clients (with two exceptions) for Linux users. Each has its pros and cons, and which email client is best for you is heavily dependent upon your needs. Read more

LibreOffice 4.4 Released With Major UI Revamp

A new version of open-source office suite LibreOffice is now available for download and the hands behind it are calling it ‘the most beautiful’ release ever. Jan Holesovsky, leader of the LibreOffice design team, says “LibreOffice 4.4 has got a lot of UX and design love, and in my opinion is the most beautiful ever.” The productivity suite, which was spun out of the slow moving OpenOffice project back in 2010, has certainly upped its game in the design department over the past few years, with each release of the 4.x series adding finesse. Read more

Android shipments in 2014 exceed 1 billion for first time

Google's Android mobile operating system has reached a major milestone. For the first time ever, worldwide shipments of smartphones packing Android exceeded 1 billion units in 2014, a significant gain from the 780.8 million units that shipped around the world in 2013, researcher Strategy Analytics announced Thursday. Android dwarfed its second-place competitor, Apple's iOS, which mustered 192.7 million worldwide shipments in 2014. Read more