Connecting Macro on OpenOffice

Source Image

Apache OpenOffice is the leading open-source office suite software for word processing, spreadsheets, presentations, graphics, databases and more. More Information

What Will I Learn?

In the video I give an explanation how to using Macro function and connect it with Push Button in OpenOffice calc.

• You will learn to using Macro
• You will learn to create Push Button.
• You will learn how to connect your macro to push button

What is OpenOffice Calc?

Calc is similar to Microsoft Excel, with almost the same abilities. Calc is capable of opening and saving spreadsheets in Microsoft Excel's file format. It provides a number of features not present in Excel, including a system which automatically defines a series for graphing based on the layout of the user's data. Calc is also capable of writing spreadsheets directly as PDF files.

What is Macro?

Macros are used to make a sequence of computing instructions available to the programmer as a single program statement, making the programming task less tedious and less error-prone. Macros often allow positional or keyword parameters that dictate what the conditional assembler program generates and have been used to create entire programs or program suites according to such variables as operating system, platform or other factors. The term derives from "macro instruction", and such expansions were originally used in generating assembly language code.

Requirements

• System Requirements : Program Install Support Install and Uninstall
• System Requirements : No special requirements.
• OS Support : Windows (XP, 2003, Vista, 7, 8 and 10) GNU/Linux (x86 and x86-64, RPM and DEB based Linux distributions) Mac OS X (x86-64 only)

Information

• Website & Download: https://www.openoffice.org/
• Type : Office suite software
• License : Dual-licensed under the SISSL and GNU LGPL
• Operating System : Linux, OS X, Microsoft Windows, Solaris
• Platform : IA-32, x86-64, PowerPC, SPARC

Difficulty

Intermediate

Description

Apache OpenOffice is the leading open source office software for word processing, spreadsheets, presentations, graphics, databases and more. It can be downloaded and used completely free for any purpose. In the video below, I explain how to relating a macro to push button.

Little additional explanation

The photo above is the process of making a macro, there I delete the contents of some cells.

The photo above is the process of connecting the macros on the Push button, you can see the completeness of the video below.

The photo above is the result of making a Push button with macro function that we created.

Video Tutorial

Curriculum

If you want to learn more about OpenOffice, I have uploaded my previous video, you can see below :

• Apache Open Office learn to create relationship on OpenOffice Base
• Apache OpenOffice learn to use Mail Merge
• Apache OpenOffice Formula learning (1)
• Apache OpenOffice Formula learning (2)
• And if you want to know more of tutorials you can directly see on my profile

---

Posted on Utopian.io - Rewarding Open Source Contributors

---