To create a DataPilot, either highlight a range of shells in the current spreadsheet or locate a database that is registered in OpenOffice.org (go to File -> New -> Database ->Open an existing ...

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 ...

How to Link Data on a Worksheet to Another Worksheet in the Same Spreadsheet. Linked cells often make it easier to organize spreadsheet data that's spread among several worksheets.