Apache OpenOffice is the leading open-source office suite software for word processing, spreadsheets, presentations, graphics, databases and more. More Information
In the video I give an explanation how to using Macro function and connect it with Push Button in 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.
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.
Intermediate
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.
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.
If you want to learn more about OpenOffice, I have uploaded my previous video, you can see below :
