OpenOffice Calc: Macro Recorder
"OpenOffice" is a free and very good Alternative to Microsoft Office. Similar to how in Excel, you can create in the spreadsheet OpenOffice Calc macros. You can either record macros or programming. In the latter case, you need to have basic knowledge of the programming language OpenOffice.org Basic.
- Start recording: to start recording a Macro, go to the menu bar, click "tools" -> "macros" -> "record Macro". The program now logs in the Background of their activities. Next, perform your step you want to automate. You can, for example, create a chart with empty values. If you enter in a later step, the values in the table and run the Macro, this is filled in automatically. When you finish recording, click stop recording. After that, you need to give the Macro a name and save it.
- Running a macro: To run a macro, you need the "Java Runtime Environment". If this is not installed on your PC, you can get a note from OpenOffice. Make sure for safety reasons that the current Version is installed. A recorded Macro, go to the menu bar, click "tools" -> "macros" -> "run Macro...".
- Add icon: If you want to reach your Macro directly by icon, click in the toolbar on a grey arrow, and then click "customize toolbar...". With the "Add..." allows you to place new items on your toolbar. The last entry in the field "field" contains the macros. With the arrows specify the Position of the macro.
Calc: record Macro
OpenOffice Calc: Macro programming
If you are with the program, you can create a Macro yourself. OpenOffice has its own development environment. Detailed instructions can be found on the Wiki page of the manufacturer.
- The basic structure: such As the basic looks of the scaffolding, you can refer to a recorded Macro. Go to the menu bar, click "tools" -> "macros" -> "manage" -> "OpenOffice Basic...". Select your Macro and click "edit...". In the development environment (IDE) you can write your own source code.
OpenOffice Calc: IDE
As an OpenOffice document with a password protect, you can learn in a further practical tip.
