Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/DataPilot"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Using the DataPilot}} {{Documentation/CG3Ch6TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Digital signing |NextPage=Documentation/OOo3_User_Gui...)
 
m
Line 2: Line 2:
 
{{Documentation/CG3Ch6TOC
 
{{Documentation/CG3Ch6TOC
 
|ShowPrevNext=block
 
|ShowPrevNext=block
|PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Digital signing
+
|PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Using regular expressions in functions
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/DataPilot example 1
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/DataPilot example 1
 
}}__notoc__
 
}}__notoc__
This is Chapter '''6''' of the '''OpenOffice.org 3 Calc Guide''', produced by the [http://oooauthors.org/ OOoAuthors group].
+
This is Chapter '''8''' of the '''OpenOffice.org 3 Calc Guide''', produced by the [http://oooauthors.org/ OOoAuthors group].
 
<!-- A PDF of this chapter is available from [http://documentation.openoffice.org/manuals/userguide3/ Documentation] at OpenOffice.org. -->
 
<!-- A PDF of this chapter is available from [http://documentation.openoffice.org/manuals/userguide3/ Documentation] at OpenOffice.org. -->
  

Revision as of 21:51, 17 May 2009



This is Chapter 8 of the OpenOffice.org 3 Calc Guide, produced by the OOoAuthors group.


Introduction

In requests for office software support there are regularly questions caused by some awkward solution strategies for day to day exercises in a spreadsheet. By not knowing simple but powerful concepts, users create very complicated formulas. A much more solid, simple, and flexible solution is based on using the DataPilot.

The DataPilot is not just a tool for advanced users. If beginners would know about this tool, it would save them many hours of work.

This chapter is divided into two sections:

  • Examples with step by step descriptions uses three typical cases to demonstrate the advantages and applications of the DataPilot. You can follow these examples and learn by doing how easy it is to use the DataPilot.
  • DataPilot functions in detail describes the DataPilot in detail. You can use this part for looking up how a function is used.

Examples with step by step descriptions

This section demonstrates some of the possibilities of the DataPilot in some typical use cases. By following the step by step description, you should be able to recreate the examples yourself and learn about the power of the DataPilot.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools