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

XFree KWin, Plasma, KDE, and Qt/GTK

  • Announcing the XFree KWin project
    Over the last weeks I concentrated my work on KWin on what I call the XFree KWin project. The idea is to be able to start KWin/Wayland without XWayland support. While most of the changes required for it are already in Plasma 5.11, not everything got ready in time, but now everything is under review on phabricator, so it’s a good point in time to talk about this project.
  • Adapta Theme is Now Available for the #KDE Plasma Desktop
    A new port brings the Adapta GTK theme to the KDE Plasma 5 desktop for the first time, news that will please fans of its famous flat stylings.
  • A New Project To Let You Run Qt Apps With GTK+ Windowing System Integration
    A Norwegian developer has developed a new Qt platform abstraction plug-in to let Qt applications make use of GTK+ for windowing system integration. The Qt apps rely upon GTK+ as a host toolkit to provide GTK menus, GTK for input, and other integration bits.
  • Ant is a Flat GTK Theme with a Bloody Bite
    Between Arc, Adapta and Numix it kind of feels like Linux has the whole flat GTK theme thing covered. But proving their’s always room for one more is Ant.

Android Leftovers

Development: Blockchain for Good Hackathon, ASUS Tinker Board, React License, JavaScript, Pascal, Python

  • Blockchain for Good Hackathon, Saturday, 30 September and Sunday, 1 October
    The Blockchain for Good Hackathon takes place Saturday, 30 September and Sunday, 1 October. Full agenda can be found here.
  • ASUS Tinker Board Is An Interesting ARM SBC For About $60 USD
    Earlier this year ASUS announced the Tinker Board as their first step into the ARM single board computer world. Earlier this month I finally received a Tinker Board for testing and it has been quite interesting to say the least. The Tinker Board with its Rockchip SoC has been among the most competitive ARM SBCs we have tested to date in its price range and the form factor is compatible with the Raspberry Pi.
  • Configure Thunderbird to send patch friendly
  • Facebook to Relicense React Under MIT [Ed: as we hoped [1, 2]]
    Facebook has decided to change the React license from BSD+Patents to MIT to make it possible for companies to include React in Apache projects, and to avoid uncertain relationship with the open source community. Adam Wolff, an Engineering Director at Facebook, has announced that a number of projects - React, Jest, Flow, and Immutable.js – will soon start using the more standard MIT License instead of BSD+Patents. The reason provided is "because React is the foundation of a broad ecosystem of open source software for the web, and we don't want to hold back forward progress for nontechnical reasons." While aware that the React’s BSD+Patents license has created "uncertainty" among users of the library, prompting some to select an alternative solution, Facebook does not "expect to win these teams back" but they still hope some will reconsider the issue. The change in license will become effective when React 16 will be released next week. Regarding other projects, Wolff said that "many of our popular projects will keep the BSD + Patents license for now", while they are "evaluating those projects' licenses too, but each project is different and alternative licensing options will depend on a variety of factors." It seems from this clause that Facebook plans to get rid of the BSD+Patents license entirely, but they need to figure out the best option for each project. [...] Facebook’s plan to switch to a standard license MIT, supported by Apache, completely solves this problem with React and several other projects. It remains to see what happens with the license of other Facebook projects, and how much this license issue has affected how React is perceived by the community.
  • To type or not to type: quantifying detectable bugs in JavaScript
  • Plug For PASCAL
  • V. Anton Spraul's Think Like a Programmer, Python Edition

New Manjaro Release

What a week we had. With this update we have removed most of our EOL tagged kernels. Please adopt to newer series of each, when still be used. PulseAudio and Gstreamer got renewed. Also most of our kernels got newer point-releases. Series v4.12 is now marked as EOL. Guillaume worked on Pamac to solve reported issues within our v6 series. The user experience should be much better now. Latest NetworkManager, Python and Haskell updates complete this update-pack. Please report back and give us feedback for given changes made to our repositories. Read more