Calc Guide

Chapter 12
Calc Macros...........................................................................340
Introduction....................................................................................341
Using the macro recorder...............................................................341
Write your own functions................................................................345
Accessing cells directly...................................................................353
Sorting............................................................................................354
Conclusion......................................................................................356
Chapter 13
Calc as a Simple Database......................................................357
Introduction....................................................................................358
Associating a range with a name....................................................359
Sorting............................................................................................365
Filters.............................................................................................367
Calc functions similar to database functions..................................375
Database-specific functions............................................................387
Conclusion......................................................................................388
Chapter 14
Setting up and Customizing Calc...........................................389
Introduction....................................................................................390
Choosing options that affect all of OOo..........................................390
Choosing options for loading and saving documents......................396
Choosing options for Calc...............................................................400
Controlling Calc’s AutoCorrect functions.......................................409
Customizing the user interface.......................................................410
Adding functionality with extensions..............................................420
Appendix A
Keyboard Shortcuts................................................................422
Introduction....................................................................................423
Navigation and selection shortcuts.................................................423
Function and arrow key shortcuts..................................................425
Cell formatting shortcuts................................................................426
DataPilot shortcuts.........................................................................427
OpenOffice.org 3.x Calc Guide 7