Macros & Basic with OpenOffice Calc
()
About this ebook
This book focuses on the macros you can record with OpenOffice CALC. A macro is actually a BASIC procedure that you can modify in a specific programming environment. It enables you to create customized applications to control the objects interaction in the spreadsheet accurately. You will learn how to develop a dialogue box to manage information easily.
BASIC programming is relatively simple to understand and all the exercises of this book will help you to achieve manual actions automatically.
ABOUT THE AUTHOR
Rémy Lentzner has been an IT trainer since 1985. Specialized in mastering office automation tools, he supports companies in the professional training of their employees. Self-taught, he has several computer books to his credit.
Read more from Remy Lentzner
UPGRADING YOUR SKILLS WITH POWERPOINT Rating: 0 out of 5 stars0 ratingsGetting started with OpenOffice Base Rating: 0 out of 5 stars0 ratingsUPGRADING YOUR SKILLS WITH OUTLOOK Rating: 0 out of 5 stars0 ratingsGetting started with Sparkle Rating: 0 out of 5 stars0 ratingsGETTING STARTED WITH OPENOFFICE CALC Rating: 0 out of 5 stars0 ratingsGETTING STARTED WITH OPENOFFICE WRITER Rating: 0 out of 5 stars0 ratingsGetting started with Numbers Rating: 0 out of 5 stars0 ratingsGetting started with OpenOffice Impress Rating: 0 out of 5 stars0 ratingsGETTING STARTED WITH SQL: Exercises with PhpMyAdmin and MySQL Rating: 0 out of 5 stars0 ratings
Related to Macros & Basic with OpenOffice Calc
Related ebooks
Autodesk Revit Architecture 2015 Essentials: Autodesk Official Press Rating: 0 out of 5 stars0 ratingsAutodesk AutoCAD A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsApple In the Classroom: A Guide to Mac, iPad, and iWork Rating: 0 out of 5 stars0 ratingsIntroduction to Unity Rating: 0 out of 5 stars0 ratingsHow to Install Ringtone on iOS Rating: 0 out of 5 stars0 ratingsEssential Visual Studio 2019: Boosting Development Productivity with Containers, Git, and Azure Tools Rating: 0 out of 5 stars0 ratingsVisual Studio VS The Ultimate Step-By-Step Guide Rating: 0 out of 5 stars0 ratingsBeginning Visual Basic 2010 Rating: 0 out of 5 stars0 ratingsProgramming macros with Google Sheets: Professional training Rating: 0 out of 5 stars0 ratingsThe Secret Life of Word: A Professional Writer's Guide to Microsoft Word Automation Rating: 0 out of 5 stars0 ratingsGETTING STARTED WITH OPENOFFICE WRITER Rating: 0 out of 5 stars0 ratingsExcel 2007 VBA Programmer's Reference Rating: 5 out of 5 stars5/5GETTING STARTED WITH SQL: Exercises with PhpMyAdmin and MySQL Rating: 0 out of 5 stars0 ratingsUpgrading your skills with Word Rating: 0 out of 5 stars0 ratingsGetting started with Adobe Acrobat Pro Rating: 5 out of 5 stars5/5Improve your skills with Google Sheets: Professional training Rating: 0 out of 5 stars0 ratingsGetting started with php & mysql: Professional training Rating: 0 out of 5 stars0 ratingsGetting started with programming: Professional Training Rating: 0 out of 5 stars0 ratingsMastering VBA for Microsoft Office 2016 Rating: 5 out of 5 stars5/5Upgrading your skills with Access Rating: 0 out of 5 stars0 ratingsExcel 2019 Power Programming with VBA Rating: 5 out of 5 stars5/5Getting started with OpenOffice Impress Rating: 0 out of 5 stars0 ratingsExcel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch: 1 Rating: 4 out of 5 stars4/5Excel VBA 24-Hour Trainer Rating: 3 out of 5 stars3/5Mastering VBA for Microsoft Office 2013 Rating: 0 out of 5 stars0 ratings40 Ready to Use Excel VBA and Macros Rating: 0 out of 5 stars0 ratingsMastering VBA for Microsoft Office 365 Rating: 5 out of 5 stars5/5Excel for Beginners 2023: A Step-by-Step and Comprehensive Guide to Master the Basics of Excel, with Formulas, Functions, & Charts Rating: 0 out of 5 stars0 ratings
Applications & Software For You
Adobe After Effects: A Complete Course and Compendium of Features Rating: 5 out of 5 stars5/5Logic Pro X For Dummies Rating: 0 out of 5 stars0 ratingsSound Design for Filmmakers: Film School Sound Rating: 5 out of 5 stars5/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5The Best Hacking Tricks for Beginners Rating: 4 out of 5 stars4/5Adobe Illustrator: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsAdobe Photoshop: A Complete Course and Compendium of Features Rating: 5 out of 5 stars5/5GarageBand For Dummies Rating: 5 out of 5 stars5/5Digital Filmmaking for Beginners A Practical Guide to Video Production Rating: 0 out of 5 stars0 ratingsSynthesizer Cookbook: How to Use Filters: Sound Design for Beginners, #2 Rating: 3 out of 5 stars3/5Power OneNote Rating: 4 out of 5 stars4/5Blender 3D Basics Beginner's Guide Second Edition Rating: 5 out of 5 stars5/5The Little SAS Book: A Primer, Sixth Edition Rating: 5 out of 5 stars5/5Digital Video Production Handbook Rating: 0 out of 5 stars0 ratingsStart Your Own Podcast Business: Your Step-By-Step Guide to Success Rating: 5 out of 5 stars5/5Six Figure Blogging In 3 Months Rating: 3 out of 5 stars3/5Adobe Illustrator CC For Dummies Rating: 5 out of 5 stars5/5Data Science and Big Data Analytics: Discovering, Analyzing, Visualizing and Presenting Data Rating: 0 out of 5 stars0 ratingsBlender 3D Printing Essentials Rating: 0 out of 5 stars0 ratingsGarageBand Basics: The Complete Guide to GarageBand: Music Rating: 0 out of 5 stars0 ratingsBlender 3D By Example Rating: 4 out of 5 stars4/5Learning Robotics Using Python Rating: 0 out of 5 stars0 ratingsGray Hat Hacking the Ethical Hacker's Rating: 5 out of 5 stars5/5Kodi User Manual: Watch Unlimited Movies & TV shows for free on Your PC, Mac or Android Devices Rating: 0 out of 5 stars0 ratings
Reviews for Macros & Basic with OpenOffice Calc
0 ratings0 reviews
Book preview
Macros & Basic with OpenOffice Calc - Remy Lentzner
Chapter 1
Macros with CALC
This chapter deals with macros inside the CALC spreadsheet. You will learn how to create, save and execute them to make your manual actions automatic. A macro is also a BASIC procedure that you can modify in a programming environment. You will study the language and its various features.
1.1 General information about macros
A macro or macro command is a sequence of keystrokes that performs an operation on one or more parts of the spreadsheet.
For instance, to hide a column, you place the pointer in a column and you perform the actions Format / Column / Hide. If you consider that this operation is often repeated in your daily work, you can memorize this sequence of manual actions using a macro.
Another example is the printing of a part of a table. If you have to print a specific group of rows every month, you can record the whole manual process.
The macro feature makes it easier to perform repetitive tasks. You can record as many macros as you like.
With OpenOffice, a recorded macro automatically creates a suite of code in the BASIC language.
Figure 1.1 shows an INCOME.ODS document containing some accounting data and formulas.
Figure 1.1 : Formulas inside a document
Workshop : Creating a macro to format the whole table with a Calibri font and a size of 10.
1.1.1 Recording a macro
The following shows how to create a macro:
Select the cells.
Tools / Macros
Record Macro
Figure 1.2 : Recording the tasks and waiting to stop
Perform all the operations manually to record the macro.
Click on the Stop Recording button to stop the macro.
Figure 1.3 shows the dialogue box that displays the existing macros, their locations and the different buttons than can help you to manage macros.
Figure 1.3 : The macros management
Click on the New Module button.
Enter a module name then finish with the OK button.
Close the dialogue box. The creation of the macro is completed.
Enter the name of the macro in the Macro name box then finish with the Save button.
A macro is always stored in a module that is a macros container.
If a module already exists, it is not necessary to create a new module. Select the module you are interested in before saving the new macro.
After stopping the macro, OpenOffice will display the OpenOffice BASIC Macros dialogue box in which you specify a macro name and a particular location.
You can save a macro in several places:
In the My Macros library. Here, you can use the macros for other documents.
In the OpenOffice Macros library. These pre-existing macros are used by OpenOffice.
In the INCOMES.ODS document. The macros saved here are only available in this document.
In brief, you can store macros in a public container, a system container or a local container.
1.1.2 Running a macro
Once the macros have been created, you can run it with the following:
Tools / Macros / Run macro
Select the library.
Choose the macro name then click on the Run button.
1.1.3 Modules and procedures
A procedure is the structure that is automatically created when you record a macro. It starts with the keyword Sub and ends with the keyword End Sub. A procedure is always stored in a module, i.e. a container of procedures. When the macro is completed, OpenOffice will save it in a procedure called main if you don't rename the macro.
You can always edit a macro with the following:
Tools / Macros / Organize Macros
OpenOffice BASIC
Figure 1.4 : Editing a macro
Select the macro to edit.
Edit
OpenOffice displays the BASIC programming environment