Comments on: 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/ Linux and Dev Portal Thu, 25 Jun 2020 18:59:51 +0000 hourly 1 By: Johnny Rosenberg https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comment-661 Thu, 25 Jun 2020 18:59:51 +0000 http://www.debugpoint.com/?p=1382#comment-661 In reply to Daniel Lopes.

If you selected a whole range, getCellAddress won’t work, only getCellRangeAddress. The other way around if you selected a single cell.

]]> By: Arindam Giri https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comment-431 Sun, 10 Sep 2017 06:43:00 +0000 http://www.debugpoint.com/?p=1382#comment-431 In reply to Daniel Lopes.

Please post your entire code here so that we can help.

]]> By: Daniel Lopes https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comment-430 Tue, 29 Aug 2017 13:05:00 +0000 http://www.debugpoint.com/?p=1382#comment-430 Hello, after the execution arises amensagem below:

BASIC run-time error.
Property or method not found: getCellAddress

How to solve?

]]> By: Adriel Shawn https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comment-293 Fri, 06 May 2016 05:32:00 +0000 http://www.debugpoint.com/?p=1382#comment-293 In reply to Arindam Giri.

and whats the code for search after you get the data.. thanks in advance Mr. Giri.

]]> By: Adriel Shawn https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comment-292 Fri, 06 May 2016 05:23:00 +0000 http://www.debugpoint.com/?p=1382#comment-292 In reply to Arindam Giri.

sorry i didnt specify my question sir Giri. i wanna get the data of the specific cell that i highlighted.
example: i highlight a1 to a7. i wanna get the data of a7 and search it in sheet2 and deleting that row.
sorry for wrong question. hope you help me thanks a lot.

]]> By: Arindam Giri https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comment-291 Fri, 06 May 2016 04:39:00 +0000 http://www.debugpoint.com/?p=1382#comment-291 In reply to Adriel Shawn.

You can get the selected cell value using below:

Dim oDoc, oSel
oDoc = ThisComponent
oSel = oDoc.getCurrentSelection()
oSel.getString()

This is described in below article:
http://www.debugpoint.com/2015/03/calc-cell-selection-processing-using-macro/

]]> By: Adriel Shawn https://www.debugpoint.com/get-the-selection-cell-and-range-address-using-macro-in-libreoffice/#comment-288 Fri, 06 May 2016 02:33:00 +0000 http://www.debugpoint.com/?p=1382#comment-288 hi guys can i ask a question?

how can you get the data of the highlighted cell? and search it into another sheet.

is that possible?

thank you in advance

hope you help me guys

newbie here.

]]>