Conclusion

Apache OpenOffice 4.1 Calc Guide

Chapter 12 Calc Macros

< Previous Section

Next Section >

• Introduction
  • The OpenOffice Basic Language
• Using the Macro Recorder
• Write Your Own Functions
  • Using a Macro as a Function
  • Passing Arguments to a Macro
  • Arguments are Passed as Values
  • Writing Macros that Act Like Built-in Functions
• Accessing Cells Directly
• Sorting
• Conclusion

< Previous Page

Next Page >

Conclusion

We briefly covered how macros are organized into libraries and modules, how to use the macro recorder, using macros as Calc functions, and writing macros using the Application Programming Interface (API) rather than the recorder. The macro recorder stores the effects of keystrokes or mouse clicks and can be used without any programming knowledge. It cannot record every possible user action but can often automate tedious, repetitive tasks, saving time and reducing errors. Writing functions and macros using the API are more advanced topics requiring some programming knowledge. They can be used to make very powerful tools but may require spending a lot of time learning the Application Programming Interface , writing code, and testing it. When the situation requires it, OpenOffice provides the infrastructure to implement complex and robust macros.