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

Netflix FIDO

Chromixium – An Ubuntu Based Google’s Chrome OS Clone

Today, We have come up with an interesting news for both Ubuntu and Chrome OS users. Meet Chromixium – the new modern desktop operating system based on Ubuntu that has the functionality, look and feel of Google’s “Chrome OS”. Chromixium has brought the elegant simplicity of Chromebook and flexibility and stability of Ubuntu together. Chromixium puts the web front and center of the user experience. Web and Chrome apps work straight out of the browser to connect you to all your personal, work and education networks. Sign into Chromium to sync all your apps and bookmarks. When you are offline or when you need more power, you can install any number of applications for work or play, including LibreOffice, Skype, Steam and a whole lot more. Security updates are installed seamlessly and effortlessly in the background and will be supplied until 2019. You can install Chromixium in place of any existing operating system, or alongside Windows or Linux. Read more

BQ Aquaris E4.5 Ubuntu Edition review: A promising start

The first 'production' smartphone running the Ubuntu operating system is finally here. Designed and marketed by the Spanish company BQ (not to be confused with the Chinese company BQ Mobile) and made in China, the first Ubuntu Phone is based on the 4.5-inch BQ Aquaris E4.5, which normally ships with Android 4.4. Included with the BQ Aquaris E4.5 Ubuntu Edition are two copies of the quick-start guide (in four languages each, one of the eight being English), a charger (with a built-in two-pin continental mains plug) and a 1-metre USB-to-Micro-USB cable. A comprehensive User Manual is available for download from the BQ website. The list price for the Aquaris E4.5 Ubuntu Edition, which is only available in the EU, is €169.90 (~£125). Read more Also: Ubuntu and Windows set to contest desktop/smartphone hybrid market Ubuntu phone that works as a desktop PC coming in 2015

Enabling Open Source SDN and NFV in the Enterprise

I recently attended the Intel Developer Forum (IDF) in Shenzhen, China, to promote Intel’s software defined networking (SDN) and network functions virtualization (NFV) software solutions. During this year’s IDF, Intel has made several announcements and our CEO Brian Krzanich showcased Intel’s innovation leadership across a wide range of technologies with our local partners in China. On the heel of Krzanich’s announcements, Intel Software & Services Group Senior VP Doug Fisher extended Krzanich’s message to stress the importance of open source collaboration to drive industry innovation and transformation, citing OpenStack and Hadoop as prime examples. Read more Also: Myth-Busting the Open-Source Cloud Part 2