“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.”
Articles
View All Hover to load posts
Articles
View All Hover to load posts
Articles
View All Hover to load posts
Articles
View All Hover to load posts
Articles
View All Hover to load posts
Articles
View All Hover to load posts
Articles
View All Hover to load posts
Articles
View All Hover to load posts