OpenOffice.org Calc: The Mysteries of DataPilots Revealed

Written By
BB
Bruce Byfield
Jul 17, 2009

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


Complete Story

BB

Bruce Byfield

Linux Today Logo

LinuxToday is a trusted, contributor-driven news resource supporting all types of Linux users. Our thriving international community engages with us through social media and frequent content contributions aimed at solving problems ranging from personal computing to enterprise-level IT operations. LinuxToday serves as a home for a community that struggles to find comparable information elsewhere on the web.

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.