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

Graphics: Vulkan and Vega M

  • Vulkan Virgl Has Kicked Off For Supporting This Graphics/Compute API Within VMs
    Of the hundreds of projects for this year's Google Summer of Code, there are many interesting GSoC 2018 projects but one of those that I am most excited for is Vulkan-Virgl for getting this modern API supported with hardware acceleration by guest virtual machines. As implied by the name, this effort is based upon the Virgl project started by David Airlie and originally tasked with getting OpenGL acceleration to guest VMs using a fully open-source Linux driver stack. Virgl has been in good shape for a while now with OpenGL, while this summer the hope is to get the Vulkan API support going for opening up VMs to using this high-performance graphics and compute API.
  • AMDVLK Driver Lands Half-Float Additions, Many Other Improvements
    There's been another weekly-ish public code push to the AMDVLK open-source AMD Vulkan Linux driver stack and this time around it's heavy on feature work. There has been a fair amount of changes pertaining to half-float (FP16) support including support for the AMD_gpu_shader_half_float extension, prepping for VK_AMD_gpu_shader_half_float_fetch, FP16 interpolation intrinsics and register settings, and more.
  • Vega M Graphics On Intel Kabylake G CPUs Are Beginning To Work Under Linux
    We have been covering the Linux driver upbringing of "Vega M" for the Vega/Polaris graphics found in select newer Intel "Kabylake G" processors. The code is still in flight before it will work in all released versions of the Linux driver components, but for those willing to build the code or rely upon third party repositories, Vega M is now working on Linux. As I have covered in various past articles, the open-source driver support for Radeon Vega M is queued into DRM-Next for the upcoming Linux 4.18 kernel cycle, Mesa 18.1 albeit with new hardware I always recommend using the latest Git (current Mesa 18.2), and there are also binary GPU microcode files needed too.

Plasma 5.13 – Amazing Tux, How Sweet Plasma

Plasma 5.13 is (going to be) a very nice release. It builds on the solid foundation that is the LTS edition, and adds cool, smart touches. The emphasis is on seamless integration of elements, which is what separates professionals from amateurs. It’s all around how the WHOLE desktop behaves, and not individual programs in isolation. And Plasma is making great strides, offering a polished version of an already mature and handsome product, with extra focus on fonts, media and browser connectivity and good performance. There are some rough patches. Apart from the obvious beta issues, those goes without saying, KDE Connect ought to be a true multi-phone product, the network stack really needs to be spotless, and that means full Microsoft Windows inter-operability, Spectacle should allow for configurable shadows and alpha channel, and I want to see if the decorative backend has been cleaned up, i.e. can you search and install new themes and icons without encountering useless errors and inconsistencies. But all in all, I’m quite impressed. The changes are big and noticeable, and above all, meaningful. You don’t just get features for the sake of it, you get things that improve the quality and consistency of the desktop, that maximize fun and productivity, and there’s deep thought in orchestrating it all together. It ain’t just a random bunch of options that happen to work. I like seeing patterns in things, and I’m happy when there’s functional harmony. This spring season of distro testing hasn’t been fun, and Plasma 5.13 is balm for my weary wrists, so hurting from all that angry typing. More than worth a spin, and highly recommended. Full steam on, Tuxers. Read more Also: This week in Usability & Productivity, part 20

Sad News! Development Stopped for Korora and BackSlash Linux

It seems more and more small distributions are facing a had time. Recently we saw the crisis at Void Linux. Now we have two more small Linux distributions calling it quit, albeit temporarily. Read more

Android Leftovers