getCurrentSelection Archives - DebugPoint.com https://www.debugpoint.com/tag/getcurrentselection/ Linux and Dev Portal Sat, 10 Sep 2022 15:45:29 +0000 en-US hourly 1 https://www.debugpoint.com/wp-content/uploads/2021/07/cropped-drawing2-site-icon-32x32.png getCurrentSelection Archives - DebugPoint.com https://www.debugpoint.com/tag/getcurrentselection/ 32 32 178518717 Export or Save As PDF A Specific Range in LibreOffice Calc Sheets using Macro https://www.debugpoint.com/export-or-save-as-pdf-a-specific-range-in-libreoffice-calc-sheets-using-macro/ https://www.debugpoint.com/export-or-save-as-pdf-a-specific-range-in-libreoffice-calc-sheets-using-macro/#comments Sat, 10 Sep 2022 15:42:00 +0000 http://www.debugpoint.com/?p=1441 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.

]]>
https://www.debugpoint.com/export-or-save-as-pdf-a-specific-range-in-libreoffice-calc-sheets-using-macro/feed/ 22 1441
Get the Selection Cell and Range Address using Macro in LibreOffice https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/ https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comments Mon, 13 Jul 2015 02:47:26 +0000 http://www.debugpoint.com/?p=1382 This tutorial will show how to get the human readable address of selected cells and ranges using basic macro. Selections In Calc, one can select a single cell Or multiple cells i.e. Ranges. Often it was required to know what is the current selection and its addresses. Declare some variables to hold activeCell and conversion...

The post Get the Selection Cell and Range Address using Macro in LibreOffice appeared first on DebugPoint.com. Do not reproduce this post without permission.

]]>
https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/feed/ 7 1382
Calc Cell Selection Processing Using Macro https://www.debugpoint.com/calc-cell-selection-processing-using-macro/ https://www.debugpoint.com/calc-cell-selection-processing-using-macro/#respond Sat, 14 Mar 2015 14:53:10 +0000 http://www.debugpoint.com/?p=1147 In this tutorial I will cover selection mechanism in LibreOffice Calc cells and via macro. getCurrentSelection() Method First we need to get hold of the Calc workbook that is open. To do that, you can use ThisComponent and hold the return object in a variable. To find out the selections done by user in a...

The post Calc Cell Selection Processing Using Macro appeared first on DebugPoint.com. Do not reproduce this post without permission.

]]>
https://www.debugpoint.com/calc-cell-selection-processing-using-macro/feed/ 0 1147