Macro Archives - DebugPoint.com

String Processing in LibreOffice Calc Macro with Examples

Arindam — Sun, 02 Oct 2022 12:43:00 +0000

This tutorial will show how to do various common string processing using macro in LibreOffice. We will use LibreOffice Calc cells to use the strings for this tutorial. These processes are essential for any macro development. Let’s put three strings like below in a LibreOffice calc sheet and join them. Joining Strings in Calc In...

The post String Processing in LibreOffice Calc Macro with Examples appeared first on DebugPoint.com. Do not reproduce this post without permission.

Export or Save As PDF A Specific Range in LibreOffice Calc Sheets using Macro

Arindam — Sat, 10 Sep 2022 15:42:00 +0000

A simple program to show you how you can export range from LibreOffice as pdf using macro. Exporting a LO sheet’s content to PDF is often necessary because of the wide use of PDF files for distributions, reporting etc. In the earlier tutorial, I showed how to export an entire sheet’s content to a pdf...

The post Export or Save As PDF A Specific Range in LibreOffice Calc Sheets using Macro appeared first on DebugPoint.com. Do not reproduce this post without permission.

LibreOffice Macro Organization

Arindam — Sun, 06 Mar 2016 17:55:25 +0000

This tutorial will share the basic idea of LibreOffice Macro file structures and organizations which can be used to export or share LibreOffice Macro as part of the office file. If you are familiar with M$ Excel VBA or VBA in general, you would know that the VB codes of a macro reside in a...

The post LibreOffice Macro Organization appeared first on DebugPoint.com. Do not reproduce this post without permission.

Form Processing with LibreOffice Calc Macro – Part 2

Arindam — Tue, 19 May 2015 16:33:08 +0000

This is the second part of tutorial series of ‘Working with forms controls in LibreOffice/OpenOffice Calc’. First part can be found here. In the first part, a simple text box and a button is covered. This tutorial will cover all other basic controls – Label, Check Box, Option Box Combo Box, List Box – how...

The post Form Processing with LibreOffice Calc Macro – Part 2 appeared first on DebugPoint.com. Do not reproduce this post without permission.

Use Open File Dialog using Macro in LibreOffice/OpenOffice

Arindam — Sun, 25 Jan 2015 17:40:47 +0000

This tutorial will show how to open a file selection dialog in LibreOffice, OpenOffice using Macro. File selection dialog is used to select single/multiple file(s) in various automation activities e.g. opening an OpenOffice, LibreOffice workbook, importing a text/csv file etc. Create Objects Lets define a function which can be used from any macro to open...

The post Use Open File Dialog using Macro in LibreOffice/OpenOffice appeared first on DebugPoint.com. Do not reproduce this post without permission.

Working with Dialog Controls in LibreOffice Calc using Macro – Part 1

Arindam — Sun, 04 Jan 2015 12:52:23 +0000

This tutorial will cover on how to create a basic LibreOffice Dialog and adding various controls such as TextBox. Also it covers on how to read the control values using Calc Macros. Adding a Dialog To add a Dialog in LibreOffice Calc, select from menu: Tools -> Macros -> Organize Dialogs… Once above options is...

The post Working with Dialog Controls in LibreOffice Calc using Macro – Part 1 appeared first on DebugPoint.com. Do not reproduce this post without permission.

LibreOffice Calc Macro – Multiple values from vlookup result

Arindam — Sat, 06 Dec 2014 13:27:32 +0000

This LibreOffice Macro Tutorial will search for data in cells like VLOOKUP function and the result will be stored in a different cells. This problem is picked up from here. The Calc spreadsheet contains the data like this: We will search each product_id from A2 to A4 in product_image. Each of the image contains first...

The post LibreOffice Calc Macro – Multiple values from vlookup result appeared first on DebugPoint.com. Do not reproduce this post without permission.

Export or Save As PDF in LibreOffice Calc Sheets using Macro

Arindam — Tue, 28 Oct 2014 17:50:38 +0000

This tutorial will show how to save a LibreOffice Calc sheet directly as a pdf file using basic macro. In many automation task this simple feature frequently required. Writing the Macro Lets call the function as “exportToPDF()” that we will hold the entire process. First define two objects which would hold the Calc document and...

The post Export or Save As PDF in LibreOffice Calc Sheets using Macro appeared first on DebugPoint.com. Do not reproduce this post without permission.

Range Processing using Macro in LibreOffice Calc – Part 1

Arindam — Sat, 18 Oct 2014 09:15:47 +0000

In many automation tasks we need to access spreadsheet using range to reduce processing time. One can access each cells using “row, column” way which is expensive in terms of processing time and complexity. Thus Range is sometimes preferred on top of the individual cell processing. In this two part tutorial series I will talk...

The post Range Processing using Macro in LibreOffice Calc – Part 1 appeared first on DebugPoint.com. Do not reproduce this post without permission.

Using Form Controls in LibreOffice Macro

Arindam — Sun, 28 Sep 2014 04:51:58 +0000

This tutorial will use the form controls such as a button inside LibreOffice Calc spreadsheet and assign a macro which will fire when the button is clicked. This is a simple tutorial depicting the basics, you can extend it to your other needs. Adding a button to Calc spreadsheet To open up the form controls,...

The post Using Form Controls in LibreOffice Macro appeared first on DebugPoint.com. Do not reproduce this post without permission.