Getting Started with OpenOffice (LibreOffice): The Free Replacement for Microsoft Office by Rob Spahitz

Author:Rob Spahitz [Spahitz, Rob]
Language: eng
Format: mobi
Tags: Word, OpenOffice.org, productivity software, Excel, spreadsheet, word processing, presentation software, LibreOffice, Microsoft Office, PowerPoint
Publisher: ComputorEdge E-Books
Published: 2012-07-10T18:30:00+00:00

Figure 1. Sample data.

At this point, I'm not sure if pivot tables are proprietary to Excel. However, as far as I can tell, they are simply fancy summary blocks that could be created using a variety of built-in Excel functions. Let's see what I find.

In Calc I searched for pivot tables and found, under the Data menu, something called Data Pilot. With some simple exploration, it appears very similar. For it to work, it looked like I had to preselect my data (whereas Excel will auto-search for a data block based on where the cursor is located). So I selected cells A1 through E12 and started the tool. The first thing that appears involves whether you want to use the selected data, as seen in Figure 2.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.