OpenOffice.org Calc: Pivot tables by another name

Posted by Scott_Ruecker on Aug 1, 2007 4:39 AM EDT
Linux Journal; By Bruce Byfield
Mail this story
Print this story

DataPilots are OpenOffice.org Calc's equivalent of what MS Excel and other spreadsheets call pivot tables. Under any name, they are a tool for extracting and summarizing the information contained in spreadsheet cells in a more convenient form. Using a DataPilot, you can immediately see relationships between different pieces of data that would be difficult -- if not impossible -- to find using formulas, and tedious to extract manually. In effect, a DataPilot gives you something of the power of using a database without actually switching out of a spreadsheet. Small wonder, then, that over half of spreadsheet users are said to use datapilots or pivot tables.

Full Story

  Nav
» Read more about: Story Type: News Story; Groups: Linux, OpenOffice.org

« Return to the newswire homepage

This topic does not have any threads posted yet!

You cannot post until you login.