OpenOffice.org Calc: The Mysteries of DataPilots Revealed
Jul 17, 2009, 16:32 (0 Talkback[s])
(Other stories by Bruce Byfield)
WEBINAR: On-demand webcast
How to Boost Database Development Productivity on Linux, Docker, and Kubernetes with Microsoft SQL Server 2017 REGISTER >
"In a way, you could think of them as the spreadsheet equivalent
of queries in databases. They aren't difficult to create, but they
do take a little bit of thought to set up correctly.
"A DataPilot requires a range of cells as a source. However, to
work properly, the range must be organized as it would be in a
database, with labels at the top of each column. For example, if
you are a college instructor, you might have created a spreadsheet
for entering grades.
"Without the labels, or adding them to rows will leave you
unable to create a DataPilot.
"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 database to register one). Then select Data ->
DataPilot -> Start and make your selection."
- Creating Queries in OpenOffice.org Base(Jun 09, 2009)
- OpenOffice.org 3.1: The next generation(May 12, 2009)
- Creating an invoicing system with OpenOffice.org(Apr 28, 2009)
- OpenOffice.org Base: Editing Information in a Database(Mar 19, 2009)
- OpenOffice.org Base: Creating basic databases and tables(Feb 19, 2009)
- OpenOffice.org 3.1 Features, an Early Look(Jan 20, 2009)
- Managing Invoices with miniInvoices(Jan 09, 2009)
- DataForm Adds Efficient Input to OpenOffice.org Calc(Nov 25, 2008)
- OpenOffice.org Tips and Tricks Part II(Aug 18, 2008)