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

Snag the Android Auto compatible Pioneer AVH-4100NEX for just $570 from Amazon

While the unit carries an MSRP of $700, Amazon's deal marks it down from its previous list price of $849.99. While it's still a tad expensive, the discount makes it a bit easier to get some Android Auto into your car. In case you've somehow managed to avoid any mention of Android Auto up until now, it allows you to connect any Android device running on Android 5.0 Lollipop with the relatively new Android Auto app in order to use it to control everything from navigation to music and phone calls. Read more

A Data-Driven Look at the Open Source E-Commerce Market

Compared to Q4 2013, last quarter’s US online sales rose 14.6 percent to a staggering $79.6 billion dollars. This accounted for 6.7 percent of the total US retail sales market. Major trends fueling this growth include the proliferation of mobile devices, faster online checkout flows and improved fulfillment practices. The availability of open source e-commerce platforms is helping some offline business with the move online. Much like WordPress provides free, customizable CMS solutions, popular open source e-commerce platforms like WooCommerce, Magento and PrestaShop offer a variety of pre-built templates and plugins that DIY retailers can customize to build and grow an online business from scratch. Read more

Tiny WiFi-loaded OpenWRT COM starts at $12

OpenEmbed launched a 52 x 28mm “SOM9331″ COM for IoT that runs OpenWRT Linux on a MIPS-based Atheros AR9331 SoC, and offers WiFi and extended temperatures. Shenzhen OpenEmbed M&C Ltd (OpenEmbed) has introduced a tiny MIPS-based computer-on-module starting at $12 and aimed at home automation, wearables, medical devices, toys, and industrial router and sensor devices. Read more

EC to create level playing field for open source

The European Commission will create a level playing field for open source software when procuring new software solutions, it announced on 27 March. Evaluation of open source and proprietary software will take into account their total cost of ownership and exit costs. Read more