Introduction

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 >

Introduction

A macro is a saved sequence of instructions stored for later use. An example of a simple macro is one that “types” your address. OpenOffice macros are very flexible, allowing automation of a range of tasks, from simple to very complex. In the right situation, a macro can improve the speed and accuracy of using a spreadsheet. However, it is important to remember that Calc includes powerful tools like Pivot Tables and Database Ranges. It is wise to investigate whether a built-in tool can do what you need before deciding to make a macro.

Macros are especially useful for repetitive tasks. This chapter briefly discusses common problems related to macro programming using Calc. Macros can be written in several programming languages, but the most common is Basic. Before we get into the details of making Calc macros, we will briefly explain some features of the OpenOffice Basic language.