Linux Today: Linux News On Internet Time.
Search Linux Today
Linux News Sections:  Developer -  High Performance -  Infrastructure -  IT Management -  Security -  Storage -
Linux Today Navigation
LT Home
Contribute
Contribute
Link to Us
Linux Jobs


Top White Papers

More on LinuxToday


OpenOffice.org Calc: The Mysteries of DataPilots Revealed

Jul 17, 2009, 16:32 (0 Talkback[s])
(Other stories by Bruce Byfield)

"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

Related Stories: